VIEW: APPS.PA_PAY_EXT_INTERAFACE_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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