View: PAYBV_ELEMENT_ENTRY_DET

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

View Text

SELECT LAST_NAME
, FIRST_NAME
, MIDDLE_NAMES
, EMPLOYEE_NUMBER
, ASSIGNMENT_NUMBER
, NATIONAL_IDENTIFIER
, PAYROLL_NAME
, HOU_ORG.NAME ORGANIZATION_NAME
, SCL.SEGMENT1 TAX_UNIT_ID
, PAY_COSTING_DETAIL_REP_PKG.GET_COSTING_TAX_UNIT_NAME(SCL.SEGMENT1) GRE_NAME
, HL.LOCATION_CODE LOCATION_CODE
, PAY_ADHOC_UTILS_PKG.GET_INPUT_NAME(PEE.ELEMENT_ENTRY_ID
, 1
, 'ELEMENT_NAME'
, PTP.START_DATE
, PTP.END_DATE
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE) ELEMENT_NAME
, PAY_ADHOC_UTILS_PKG.GET_INPUT_NAME(PEE.ELEMENT_ENTRY_ID
, 1
, 'CLASSIFICATION'
, PTP.START_DATE
, PTP.END_DATE
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE) CLASSIFICATION
, HR_BIS.BIS_DECODE_LOOKUP('CREATOR_TYPE'
, PEE.CREATOR_TYPE) SOURCE
, PAY_ADHOC_UTILS_PKG.GET_INPUT_NAME(PEE.ELEMENT_ENTRY_ID
, 1
, 'RECURRING'
, PTP.START_DATE
, PTP.END_DATE
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE) RECURRING
, PAY_ADHOC_UTILS_PKG.GET_INPUT_NAME(PEE.ELEMENT_ENTRY_ID
, 1
, 'NAME'
, PTP.START_DATE
, PTP.END_DATE
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE) INPUT_VALUE1_NAME
, PAY_ADHOC_UTILS_PKG.GET_INPUT_NAME(PEE.ELEMENT_ENTRY_ID
, 1
, 'VALUE'
, PTP.START_DATE
, PTP.END_DATE
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE) VALUE1
, PAY_ADHOC_UTILS_PKG.GET_INPUT_NAME(PEE.ELEMENT_ENTRY_ID
, 2
, 'NAME'
, PTP.START_DATE
, PTP.END_DATE
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE) INPUT_VALUE2_NAME
, PAY_ADHOC_UTILS_PKG.GET_INPUT_NAME(PEE.ELEMENT_ENTRY_ID
, 2
, 'VALUE'
, PTP.START_DATE
, PTP.END_DATE
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE) VALUE2
, PAY_ADHOC_UTILS_PKG.GET_INPUT_NAME(PEE.ELEMENT_ENTRY_ID
, 3
, 'NAME'
, PTP.START_DATE
, PTP.END_DATE
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE) INPUT_VALUE3_NAME
, PAY_ADHOC_UTILS_PKG.GET_INPUT_NAME(PEE.ELEMENT_ENTRY_ID
, 3
, 'VALUE'
, PTP.START_DATE
, PTP.END_DATE
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE) VALUE3
, PAY_ADHOC_UTILS_PKG.GET_INPUT_NAME(PEE.ELEMENT_ENTRY_ID
, 4
, 'NAME'
, PTP.START_DATE
, PTP.END_DATE
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE) INPUT_VALUE4_NAME
, PAY_ADHOC_UTILS_PKG.GET_INPUT_NAME(PEE.ELEMENT_ENTRY_ID
, 4
, 'VALUE'
, PTP.START_DATE
, PTP.END_DATE
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE) VALUE4
, PAY_ADHOC_UTILS_PKG.GET_INPUT_NAME(PEE.ELEMENT_ENTRY_ID
, 5
, 'NAME'
, PTP.START_DATE
, PTP.END_DATE
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE) INPUT_VALUE5_NAME
, PAY_ADHOC_UTILS_PKG.GET_INPUT_NAME(PEE.ELEMENT_ENTRY_ID
, 5
, 'VALUE'
, PTP.START_DATE
, PTP.END_DATE
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE) VALUE5
, PAY_ADHOC_UTILS_PKG.GET_INPUT_NAME(PEE.ELEMENT_ENTRY_ID
, 6
, 'NAME'
, PTP.START_DATE
, PTP.END_DATE
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE) INPUT_VALUE6_NAME
, PAY_ADHOC_UTILS_PKG.GET_INPUT_NAME(PEE.ELEMENT_ENTRY_ID
, 6
, 'VALUE'
, PTP.START_DATE
, PTP.END_DATE
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE) VALUE6
, PAY_ADHOC_UTILS_PKG.GET_INPUT_NAME(PEE.ELEMENT_ENTRY_ID
, 7
, 'NAME'
, PTP.START_DATE
, PTP.END_DATE
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE) INPUT_VALUE7_NAME
, PAY_ADHOC_UTILS_PKG.GET_INPUT_NAME(PEE.ELEMENT_ENTRY_ID
, 7
, 'VALUE'
, PTP.START_DATE
, PTP.END_DATE
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE) VALUE7
, PAY_ADHOC_UTILS_PKG.GET_INPUT_NAME(PEE.ELEMENT_ENTRY_ID
, 8
, 'NAME'
, PTP.START_DATE
, PTP.END_DATE
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE) INPUT_VALUE8_NAME
, PAY_ADHOC_UTILS_PKG.GET_INPUT_NAME(PEE.ELEMENT_ENTRY_ID
, 8
, 'VALUE'
, PTP.START_DATE
, PTP.END_DATE
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE) VALUE8
, PAY_ADHOC_UTILS_PKG.GET_INPUT_NAME(PEE.ELEMENT_ENTRY_ID
, 9
, 'NAME'
, PTP.START_DATE
, PTP.END_DATE
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE) INPUT_VALUE9_NAME
, PAY_ADHOC_UTILS_PKG.GET_INPUT_NAME(PEE.ELEMENT_ENTRY_ID
, 9
, 'VALUE'
, PTP.START_DATE
, PTP.END_DATE
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE) VALUE9
, PAY_ADHOC_UTILS_PKG.GET_INPUT_NAME(PEE.ELEMENT_ENTRY_ID
, 10
, 'NAME'
, PTP.START_DATE
, PTP.END_DATE
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE) INPUT_VALUE10_NAME
, PAY_ADHOC_UTILS_PKG.GET_INPUT_NAME(PEE.ELEMENT_ENTRY_ID
, 10
, 'VALUE'
, PTP.START_DATE
, PTP.END_DATE
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE) VALUE10
, PAY_ADHOC_UTILS_PKG.GET_INPUT_NAME(PEE.ELEMENT_ENTRY_ID
, 11
, 'NAME'
, PTP.START_DATE
, PTP.END_DATE
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE) INPUT_VALUE11_NAME
, PAY_ADHOC_UTILS_PKG.GET_INPUT_NAME(PEE.ELEMENT_ENTRY_ID
, 11
, 'VALUE'
, PTP.START_DATE
, PTP.END_DATE
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE) VALUE11
, PAY_ADHOC_UTILS_PKG.GET_INPUT_NAME(PEE.ELEMENT_ENTRY_ID
, 12
, 'NAME'
, PTP.START_DATE
, PTP.END_DATE
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE) INPUT_VALUE12_NAME
, PAY_ADHOC_UTILS_PKG.GET_INPUT_NAME(PEE.ELEMENT_ENTRY_ID
, 12
, 'VALUE'
, PTP.START_DATE
, PTP.END_DATE
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE) VALUE12
, PAY_ADHOC_UTILS_PKG.GET_INPUT_NAME(PEE.ELEMENT_ENTRY_ID
, 13
, 'NAME'
, PTP.START_DATE
, PTP.END_DATE
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE) INPUT_VALUE13_NAME
, PAY_ADHOC_UTILS_PKG.GET_INPUT_NAME(PEE.ELEMENT_ENTRY_ID
, 13
, 'VALUE'
, PTP.START_DATE
, PTP.END_DATE
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE) VALUE13
, PAY_ADHOC_UTILS_PKG.GET_INPUT_NAME(PEE.ELEMENT_ENTRY_ID
, 14
, 'NAME'
, PTP.START_DATE
, PTP.END_DATE
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE) INPUT_VALUE14_NAME
, PAY_ADHOC_UTILS_PKG.GET_INPUT_NAME(PEE.ELEMENT_ENTRY_ID
, 14
, 'VALUE'
, PTP.START_DATE
, PTP.END_DATE
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE) VALUE14
, PAY_ADHOC_UTILS_PKG.GET_INPUT_NAME(PEE.ELEMENT_ENTRY_ID
, 15
, 'NAME'
, PTP.START_DATE
, PTP.END_DATE
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE) INPUT_VALUE15_NAME
, PAY_ADHOC_UTILS_PKG.GET_INPUT_NAME(PEE.ELEMENT_ENTRY_ID
, 15
, 'VALUE'
, PTP.START_DATE
, PTP.END_DATE
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE) VALUE15
, PTP.START_DATE
, PTP.END_DATE
, PAF.BUSINESS_GROUP_ID
, PEE.ELEMENT_ENTRY_ID
, PF.PAYROLL_ID
, PEE.EFFECTIVE_START_DATE ENTRY_START_DATE
, PEE.EFFECTIVE_END_DATE ENTRY_END_DATE
, CASE WHEN PF.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PF.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PAY_ELEMENT_ENTRIES_F PEE
, PER_PEOPLE_F PPF
, PER_ASSIGNMENTS_F PAF
, PAY_PAYROLLS_F PF
, HR_ORGANIZATION_UNITS HOU_ORG
, HR_LOCATIONS HL
, PER_TIME_PERIODS PTP
, HR_SOFT_CODING_KEYFLEX SCL
WHERE PEE.CREATOR_TYPE <> 'UT'
AND PEE.ASSIGNMENT_ID = PAF.ASSIGNMENT_ID
AND PAF.PERSON_ID = PPF.PERSON_ID
AND PF.PAYROLL_ID = PAF.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 (PEE.EFFECTIVE_START_DATE <= PTP.END_DATE
AND PEE.EFFECTIVE_END_DATE >= PTP.START_DATE)
AND PTP.START_DATE BETWEEN PPF.EFFECTIVE_START_DATE
AND PPF.EFFECTIVE_END_DATE
AND PTP.START_DATE BETWEEN PAF.EFFECTIVE_START_DATE
AND PAF.EFFECTIVE_END_DATE
AND PTP.START_DATE BETWEEN PF.EFFECTIVE_START_DATE
AND PF.EFFECTIVE_END_DATE
AND SCL.SOFT_CODING_KEYFLEX_ID(+) = PAF.SOFT_CODING_KEYFLEX_ID

Columns