Need a sql to fetch costing at assignment and payroll relationship level under Costing for Persons
Hello experts,
we are trying to create a sql query that can fetch costing at assignment and payroll relationship level under Costing for Persons.
This is the query that we are trying to build:
SELECT DISTINCT
PPR.PERSON_ID,
PPR.PAYROLL_RELATIONSHIP_ID,
PCAF.SOURCE_TYPE AS PAYROLL_SOURCE_TYPE,
PCAF.EFFECTIVE_START_DATE AS PAYROLL_EFFECTIVE_START_DATE,
PCAF.EFFECTIVE_END_DATE AS PAYROLL_EFFECTIVE_END_DATE,
PCAA.COST_ALLOCATION_RECORD_ID,
PCAA.SEGMENT1 AS PAYROLL_SEGMENT1,
PCAA.SEGMENT2 AS PAYROLL_SEGMENT2,
PCAA.SEGMENT3 AS PAYROLL_SEGMENT3,
PCAA.SEGMENT4 AS PAYROLL_SEGMENT4,
PCAA.PROPORTION AS PAYROLL_PROPORTION,
PCAA.SOURCE_SUB_TYPE AS PAYROLL_SOURCE_SUB_TYPE,