Product: | PA - Projects |
---|---|
Description: | PA_PAY_EXT_INTERAFACE_V stores the payroll cost list of values |
Implementation/DBA Data: | APPS.PA_PAY_EXT_INTERAFACE_V |
SELECT IHEADER.INTERFACE_HEADER_ID INTERFACE_HEADER_ID
, IHEADER.PAYROLL_ID PAYROLL_ID
, IHEADER.PAYROLL_BATCH_ID PAYROLL_BATCH_ID
, IHEADER.TIME_PERIOD_START_DATE TIME_PERIOD_START_DATE
, IHEADER.TIME_PERIOD_END_DATE TIME_PERIOD_END_DATE
, PAY_PERIOD.TIME_PERIOD_ID TIME_PERIOD_ID
, DETAILS.INTERFACE_LINE_ID INTERFACE_LINE_ID
, DETAILS.PERSON_ID PERSON_ID
, DETAILS.ASSIGNMENT_ID ASSIGNMENT_ID
, HR.ORGANIZATION_ID ORGANIZATION_ID
, HR.NAME NAME
, DETAILS.PAY_SOURCE_ORGANIZATION_ID PAY_SOURCE_ORGANIZATION_ID
, DETAILS.PAY_SOURCE_PROJECT_ID PAY_SOURCE_PROJECT_ID
, DETAILS.PAY_SOURCE_TASK_ID PAY_SOURCE_TASK_ID
, DETAILS.PAY_ELEMENT_TYPE_CODE PAY_ELEMENT_TYPE_CODE
, DETAILS.PAY_CURRENCY_CODE PAY_CURRENCY_CODE
, DETAILS.PAY_AMOUNT PAY_AMOUNT
, DETAILS.TRANSFER_STATUS_FLAG TRANSFER_STATUS_FLAG
, DETAILS.REJECTION_CODE REJECTION_CODE
, DETAILS.RETRO_PERIOD_START_DATE RETRO_PERIOD_START_DATE
, DETAILS.RETRO_PERIOD_END_DATE RETRO_PERIOD_END_DATE
FROM PA_PAY_EXT_INTERFACE_HEADER IHEADER
, PA_PAY_EXTERNAL_TIME_PERIODS PAY_PERIOD
, PA_PAY_EXT_INTERFACE_DETAILS DETAILS
, HR_ORGANIZATION_UNITS HR
, PER_ASSIGNMENTS_F PAF
, PER_PEOPLE_F PPF
, HR_LOCATIONS HL
WHERE IHEADER.INTERFACE_HEADER_ID = DETAILS.INTERFACE_HEADER_ID
AND IHEADER.PAYROLL_ID = PAY_PERIOD.PAYROLL_ID
AND TRUNC(PAY_PERIOD.TIME_PERIOD_START_DATE) = TRUNC(IHEADER.TIME_PERIOD_START_DATE)
AND TRUNC(PAY_PERIOD.TIME_PERIOD_END_DATE) = TRUNC(IHEADER.TIME_PERIOD_END_DATE) AND HR.BUSINESS_GROUP_ID = IHEADER.BUSINESS_GROUP_ID AND PAF.PERSON_ID = DETAILS.PERSON_ID AND PAF.PERSON_ID = PPF.PERSON_ID AND PAF.ASSIGNMENT_ID = DETAILS.ASSIGNMENT_ID AND HR.ORGANIZATION_ID = PAF.ORGANIZATION_ID AND HL.LOCATION_ID = PAF.LOCATION_ID