4 Replies Latest reply: Mar 8, 2013 1:17 AM by Hetal Vaghela Branched to a new discussion. RSS

    Query for Cost Code in oracle HRMS

    984530
      Hello Exports,

      i am new in oacle hrms,
      So Can you please tell how to fetch cost code in oracle hrms r12 ( i need sql query for cost code )


      Thanks
        • 1. Re: Query for Cost Code in oracle HRMS
          Sanjay Singh
          Hi,

          Can you be more specific on what exactly do you need? Do you need cost codes defined at Assignment, Org, Payroll, Element Link, Element entry definition? or are you looking for the details post you have run the Costing process?

          For more details please refer one of my article on the this link: http://www.apps2fusion.com/at/38-ss/194-costing-in-oracle-hrms-payroll

          Thanks,
          Sanjay

          Edited by: Sanjay Singh on Mar 7, 2013 3:34 AM
          • 2. Re: Query for Cost Code in oracle HRMS
            Giuseppe Bonavita
            try the following (assignment costing as at today):

            select ppx.full_name
            ,ppx.employee_number
            ,pax.assignment_number
            ,pax.primary_flag
            ,pcax.proportion
            ,pcak.segment1
            ,pcak.segment2
            ,pcak.segment3
            ,pcak.segment4
            from per_assignments_x pax
            ,per_people_x ppx
            ,pay_cost_allocations_x pcax
            ,pay_cost_allocation_keyflex pcak
            where ppx.person_id = pax.person_id
            and pax.assignment_id = pcax.assignment_id
            and pcak.cost_allocation_keyflex_id = pcax.cost_allocation_keyflex_id
            • 3. Re: Query for Cost Code in oracle HRMS
              984530
              Hello Bonavita,

              i ran your query i did not get any data, i need cost codes defined at Payroll.

              can you pls help me on this.

              Thanks,
              • 4. Re: Query for Cost Code in oracle HRMS
                Hetal Vaghela
                Try this one

                SELECt PPF.PAYROLL_ID, PPF.PAYROLL_NAME,pca.concatenated_segments
                FROM PAY_PAYROLLS_F PPF, PAY_COST_ALLOCATION_KEYFLEX PCA
                where pca.cost_allocation_keyflex_id = ppf.cost_allocation_keyflex_id;