View: PAYBV_RETRO_ELEMENT_ENTRIES

Product:	PAY - Payroll
Description:
Implementation/DBA Data:	APPS.PAYBV_RETRO_ELEMENT_ENTRIES

View Text

SELECT /*+ LEADING(PF) INDEX(PF.PAP PAY_PAYROLLS_F_PK) */ LAST_NAME
, FIRST_NAME
, MIDDLE_NAMES
, EMPLOYEE_NUMBER
, ASSIGNMENT_NUMBER
, NATIONAL_IDENTIFIER
, PF.PAYROLL_NAME
, HOU_ORG.NAME ORGANIZATION_NAME
, PAA.TAX_UNIT_ID
, PAY_COSTING_DETAIL_REP_PKG.GET_COSTING_TAX_UNIT_NAME(PAA.TAX_UNIT_ID) GRE_NAME
, PETTL.ELEMENT_NAME RETRO_ELEMENT
, PEEV.SCREEN_ENTRY_VALUE RETRO_PAY_VALUE
, PTP1.PERIOD_NAME ORIGINATING_PAY_PERIOD
, CASE WHEN PEE.CREATOR_TYPE = 'EE' THEN PAY_ADHOC_UTILS_PKG.GET_ELEMENT_NAME(PEE.SOURCE_ID
, PPARET.EFFECTIVE_DATE
, NVL(PPA.DATE_EARNED
, PPA.EFFECTIVE_DATE)) WHEN PEE.CREATOR_TYPE <> 'EE' THEN PAY_ADHOC_UTILS_PKG.DECODE_ELEMENT_TYPE(PRR.ELEMENT_TYPE_ID
, PPARET.EFFECTIVE_DATE) END ORIGINATING_ELEMENT_TYPE
, PTP.START_DATE
, PTP.END_DATE
, PPA.BUSINESS_GROUP_ID
, PET.ELEMENT_TYPE_ID
, PEE.ELEMENT_ENTRY_ID
, PIV.INPUT_VALUE_ID
, PF.PAYROLL_ID
, CASE WHEN PPA.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PPA.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
, HL.LOCATION_CODE LOCATION
, PTP.PERIOD_NAME TARGET_PAY_PERIOD
, PPARET.EFFECTIVE_DATE DATE_OF_RETRO_RUN
, PAARET.ASSIGNMENT_ACTION_ID RETRO_ASSIGNMENT_ACTION_ID
, PAF.ASSIGNMENT_ID
, PPF.PERSON_ID
, PECTL.CLASSIFICATION_NAME RETRO_ELEMENT_CLASS
, NULL ASSIGNMENT_SET_NAME
FROM PAY_PAYROLL_ACTIONS PPARET
, PAY_ASSIGNMENT_ACTIONS PAARET
, PAY_PAYROLLS_F PF
, PAY_PAYROLL_ACTIONS PPA
, PAY_ASSIGNMENT_ACTIONS PAA
, PAY_ELEMENT_ENTRIES_F PEE
, PAY_ELEMENT_TYPES_F PET
, PAY_ELEMENT_TYPES_F_TL PETTL
, PAY_ELEMENT_ENTRY_VALUES_F PEEV
, PAY_INPUT_VALUES_F PIV
, PAY_INPUT_VALUES_F_TL PIVTL
, PER_PEOPLE_F PPF
, PER_ASSIGNMENTS_F PAF
, PER_TIME_PERIODS PTP
, PER_TIME_PERIODS PTP1
, PAY_RUN_RESULTS PRR
, HR_ORGANIZATION_UNITS HOU_ORG
, HR_LOCATIONS HL
, PAY_ELEMENT_CLASSIFICATIONS PEC
, PAY_ELEMENT_CLASSIFICATIONS_TL PECTL
WHERE PEE.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND PEE.SOURCE_ID = PRR.RUN_RESULT_ID(+)
AND PET.ELEMENT_TYPE_ID = PETTL.ELEMENT_TYPE_ID
AND PETTL.LANGUAGE = USERENV('LANG')
AND PIV.INPUT_VALUE_ID = PIVTL.INPUT_VALUE_ID
AND PIVTL.LANGUAGE = USERENV('LANG')
AND PEEV.INPUT_VALUE_ID = PIV.INPUT_VALUE_ID
AND PET.ELEMENT_TYPE_ID = PIV.ELEMENT_TYPE_ID
AND PEE.ELEMENT_ENTRY_ID = PEEV.ELEMENT_ENTRY_ID
AND PEE.CREATOR_TYPE IN ('EE'
, 'NR'
, 'PR'
, 'R'
, 'RR')
AND PAARET.ASSIGNMENT_ID = PEE.ASSIGNMENT_ID
AND PAARET.ASSIGNMENT_ID = PAF.ASSIGNMENT_ID
AND PAF.PERSON_ID = PPF.PERSON_ID
AND PPARET.PAYROLL_ID = PF.PAYROLL_ID
AND HOU_ORG.ORGANIZATION_ID = PAF.ORGANIZATION_ID
AND HL.LOCATION_ID = PAF.LOCATION_ID
AND PTP.PAYROLL_ID = PF.PAYROLL_ID
AND PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID
AND PPA.TIME_PERIOD_ID = PTP1.TIME_PERIOD_ID
AND PPARET.EFFECTIVE_DATE BETWEEN PTP.START_DATE
AND PTP.END_DATE
AND PAA.ASSIGNMENT_ACTION_ID = PEE.SOURCE_ASG_ACTION_ID
AND PPARET.EFFECTIVE_DATE BETWEEN PEEV.EFFECTIVE_START_DATE
AND PEEV.EFFECTIVE_END_DATE
AND PPARET.EFFECTIVE_DATE BETWEEN PEE.EFFECTIVE_START_DATE
AND PEE.EFFECTIVE_END_DATE
AND PPARET.EFFECTIVE_DATE BETWEEN PET.EFFECTIVE_START_DATE
AND PET.EFFECTIVE_END_DATE
AND PPARET.EFFECTIVE_DATE BETWEEN PIV.EFFECTIVE_START_DATE
AND PIV.EFFECTIVE_END_DATE
AND PPARET.EFFECTIVE_DATE BETWEEN PPF.EFFECTIVE_START_DATE
AND PPF.EFFECTIVE_END_DATE
AND PPARET.EFFECTIVE_DATE BETWEEN PAF.EFFECTIVE_START_DATE
AND PAF.EFFECTIVE_END_DATE
AND PPARET.EFFECTIVE_DATE BETWEEN PF.EFFECTIVE_START_DATE
AND PF.EFFECTIVE_END_DATE
AND PIV.NAME = 'PAY VALUE'
AND PPARET.PAYROLL_ACTION_ID = PAARET.PAYROLL_ACTION_ID
AND PAARET.ASSIGNMENT_ACTION_ID = PEE.CREATOR_ID
AND PEC.CLASSIFICATION_ID = PECTL.CLASSIFICATION_ID
AND PECTL.LANGUAGE = USERENV('LANG')
AND PEC.CLASSIFICATION_ID = PET.CLASSIFICATION_ID
AND PPARET.ACTION_TYPE IN ('G'
, 'L'
, 'O')
AND PPA.ACTION_TYPE IN ('R'
, 'Q')

Columns