Product: | PAY - Payroll |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PAYFV_ELEMENT_ENTRIES |
SELECT BGRT.NAME BUSINESS_GROUP_NAME
, PEO.FULL_NAME PERSON_NAME
, PEO.ORDER_NAME ORDER_NAME
, PETT.ELEMENT_NAME ELEMENT
, ORGT.NAME ORGANIZATION_NAME
, DECODE(ASG.JOB_ID
, NULL
, NULL
, PAY_PAYFV_ELEMENT_ENTRIES_PKG.GET_JOB(ASG.JOB_ID)) JOB_NAME
, DECODE(ASG.POSITION_ID
, NULL
, NULL
, PAY_PAYFV_ELEMENT_ENTRIES_PKG.GET_POSITION(ASG.POSITION_ID)) POSITION_NAME
, DECODE(ASG.GRADE_ID
, NULL
, NULL
, PAY_PAYFV_ELEMENT_ENTRIES_PKG.GET_GRADE(ASG.GRADE_ID)) GRADE_NAME
, DECODE(ASG.LOCATION_ID
, NULL
, NULL
, PAY_PAYFV_ELEMENT_ENTRIES_PKG.GET_LOCATION(ASG.LOCATION_ID)) LOCATION_NAME
, DECODE(ASG.PAY_BASIS_ID
, NULL
, NULL
, PAY_PAYFV_ELEMENT_ENTRIES_PKG.GET_PAY_BASIS(ASG.PAY_BASIS_ID)) PAY_BASIS
, DECODE(ASG.PAYROLL_ID
, NULL
, NULL
, PAY_PAYFV_ELEMENT_ENTRIES_PKG.GET_PAYROLL(ASG.PAYROLL_ID)) PAYROLL_NAME
, HR_GENERAL.DECODE_LOOKUP('ENTRY_TYPE'
, PEE.ENTRY_TYPE) ENTRY_TYPE
, PIVT.NAME INPUT_VALUE
, HR_GENERAL.DECODE_LOOKUP('UNITS'
, PIV.UOM) UNIT_OF_MEASURE
, EEV.SCREEN_ENTRY_VALUE ENTRY_VALUE
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE /* IDS */
, ASG.ASSIGNMENT_ID
, ASG.BUSINESS_GROUP_ID
, ASG.PERSON_ID
, PEE.ELEMENT_ENTRY_ID
, EEV.ELEMENT_ENTRY_VALUE_ID
, PEL.ELEMENT_LINK_ID
, PET.ELEMENT_TYPE_ID
, ASG.ORGANIZATION_ID
, ASG.JOB_ID
, ASG.POSITION_ID
, ASG.GRADE_ID
, ASG.LOCATION_ID
, ASG.PAY_BASIS_ID
, ASG.PAYROLL_ID
, EEV.INPUT_VALUE_ID
, PEE.CREATION_DATE
, CREATE_USR.USER_NAME
, PEE.LAST_UPDATE_DATE
, UPDATE_USR.USER_NAME
FROM PAY_ELEMENT_ENTRIES_F PEE
, PAY_INPUT_VALUES_F PIV
, PAY_INPUT_VALUES_F_TL PIVT
, PAY_ELEMENT_ENTRY_VALUES_F EEV
, PAY_ELEMENT_LINKS_F PEL
, PAY_ELEMENT_TYPES_F PET
, PAY_ELEMENT_TYPES_F_TL PETT
, PER_ASSIGNMENTS_F ASG
, PER_PEOPLE_F PEO
, HR_ALL_ORGANIZATION_UNITS_TL ORGT
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
, FND_USER CREATE_USR
, FND_USER UPDATE_USR
WHERE PET.ELEMENT_TYPE_ID = PEL.ELEMENT_TYPE_ID
AND PET.ELEMENT_TYPE_ID = PETT.ELEMENT_TYPE_ID
AND PETT.LANGUAGE = USERENV('LANG')
AND PIV.INPUT_VALUE_ID = PIVT.INPUT_VALUE_ID
AND PIVT.LANGUAGE = USERENV('LANG')
AND PIV.INPUT_VALUE_ID = EEV.INPUT_VALUE_ID
AND EEV.ELEMENT_ENTRY_ID = PEE.ELEMENT_ENTRY_ID
AND PEE.ELEMENT_LINK_ID = PEL.ELEMENT_LINK_ID
AND PEE.ASSIGNMENT_ID = ASG.ASSIGNMENT_ID
AND ASG.PERSON_ID = PEO.PERSON_ID
AND ASG.ORGANIZATION_ID = ORGT.ORGANIZATION_ID
AND ORGT.LANGUAGE = USERENV('LANG')
AND ASG.BUSINESS_GROUP_ID+0 = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND PEE.LAST_UPDATED_BY = UPDATE_USR.USER_ID(+)
AND PEE.CREATED_BY = CREATE_USR.USER_ID(+)
AND TRUNC(SYSDATE) BETWEEN PEE.EFFECTIVE_START_DATE
AND PEE.EFFECTIVE_END_DATE
AND PEE.EFFECTIVE_START_DATE BETWEEN PET.EFFECTIVE_START_DATE
AND PET.EFFECTIVE_END_DATE
AND PEE.EFFECTIVE_START_DATE BETWEEN PIV.EFFECTIVE_START_DATE
AND PIV.EFFECTIVE_END_DATE
AND PEE.EFFECTIVE_START_DATE BETWEEN EEV.EFFECTIVE_START_DATE
AND EEV.EFFECTIVE_END_DATE
AND PEE.EFFECTIVE_START_DATE BETWEEN PEL.EFFECTIVE_START_DATE
AND PEL.EFFECTIVE_END_DATE
AND PEE.EFFECTIVE_START_DATE BETWEEN ASG.EFFECTIVE_START_DATE
AND ASG.EFFECTIVE_END_DATE
AND PEE.EFFECTIVE_START_DATE BETWEEN PEO.EFFECTIVE_START_DATE
AND PEO.EFFECTIVE_END_DATE
AND ASG.BUSINESS_GROUP_ID +0 = NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID
, ASG.BUSINESS_GROUP_ID) WITH READ ONLY