Need a sql to fetch costing at assignment and payroll relationship level under Costing for Persons — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!