View: PAY_KR_SEP_RESULT_EEV_V

Product:	PAY - Payroll
Description:	This view returns Entry Value of Separation Pay Process based on both assignment_action_id and element_entry_id.
Implementation/DBA Data:	APPS.PAY_KR_SEP_RESULT_EEV_V

View Text

SELECT PAA.ASSIGNMENT_ACTION_ID ASSIGNMENT_ACTION_ID
, PAA.ASSIGNMENT_ID ASSIGNMENT_ID
, PPA.EFFECTIVE_DATE EFFECTIVE_DATE
, PPA.DATE_EARNED DATE_EARNED
, PAA.RUN_TYPE_ID RUN_TYPE_ID
, PEE.ELEMENT_ENTRY_ID ELEMENT_ENTRY_ID
, PLIV.LINK_INPUT_VALUE_ID LINK_INPUT_VALUE_ID
, PLIV.ELEMENT_LINK_ID ELEMENT_LINK_ID
, PLIV.DEFAULT_VALUE LDEFAULT_VALUE
, PIV.INPUT_VALUE_ID INPUT_VALUE_ID
, PIV.NAME NAME
, PIV.DISPLAY_SEQUENCE DISPLAY_SEQUENCE
, PIV.HOT_DEFAULT_FLAG HOT_DEFAULT_FLAG
, PIV.DEFAULT_VALUE IDEFAULT_VALUE
, PET.ELEMENT_TYPE_ID ELEMENT_TYPE_ID
, PIVT.NAME UNAME
, PEEV.ELEMENT_ENTRY_VALUE_ID ELEMENT_ENTRY_VALUE_ID
, PEEV.EFFECTIVE_START_DATE VEFFECTIVE_START_DATE
, PEEV.EFFECTIVE_END_DATE VEFFECTIVE_END_DATE
, PEEV.SCREEN_ENTRY_VALUE SCREENT_ENTRY_VALUE
, SUBSTR(HR_CHKFMT.CHANGEFORMAT( DECODE(PIV.LOOKUP_TYPE
, NULL
, NVL(PEEV.SCREEN_ENTRY_VALUE
, DECODE(PIV.HOT_DEFAULT_FLAG
, 'Y'
, NVL(PLIV.DEFAULT_VALUE
, PIV.DEFAULT_VALUE)
, PLIV.DEFAULT_VALUE))
, HR_GENERAL.DECODE_LOOKUP(PIV.LOOKUP_TYPE
, NVL(PEEV.SCREEN_ENTRY_VALUE
, DECODE(PIV.HOT_DEFAULT_FLAG
, 'Y'
, NVL(PLIV.DEFAULT_VALUE
, PIV.DEFAULT_VALUE)
, PLIV.DEFAULT_VALUE))))
, PIV.UOM
, PET.OUTPUT_CURRENCY_CODE)
, 1
, 60) ENTRY_VALUE
FROM PAY_ELEMENT_ENTRY_VALUES_F PEEV
, PAY_ELEMENT_TYPES_F PET
, PAY_INPUT_VALUES_F_TL PIVT
, PAY_INPUT_VALUES_F PIV
, PAY_LINK_INPUT_VALUES_F PLIV
, PAY_ELEMENT_ENTRIES_F PEE
, PAY_PAYROLL_ACTIONS PPA
, PAY_ASSIGNMENT_ACTIONS PAA
WHERE PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID
AND PEE.ASSIGNMENT_ID = PAA.ASSIGNMENT_ID
AND PPA.DATE_EARNED BETWEEN PEE.EFFECTIVE_START_DATE
AND PEE.EFFECTIVE_END_DATE
AND PEE.CREATOR_TYPE IN ('B'
, 'EE'
, 'F'
, 'H'
, 'R'
, 'RR')
AND PLIV.ELEMENT_LINK_ID = PEE.ELEMENT_LINK_ID
AND PPA.DATE_EARNED BETWEEN PLIV.EFFECTIVE_START_DATE
AND PLIV.EFFECTIVE_END_DATE
AND PIV.INPUT_VALUE_ID = PLIV.INPUT_VALUE_ID
AND PPA.DATE_EARNED BETWEEN PIV.EFFECTIVE_START_DATE
AND PIV.EFFECTIVE_END_DATE
AND PIVT.INPUT_VALUE_ID = PIV.INPUT_VALUE_ID
AND PIVT.LANGUAGE = USERENV('LANG')
AND PET.ELEMENT_TYPE_ID = PIV.ELEMENT_TYPE_ID
AND PPA.DATE_EARNED BETWEEN PET.EFFECTIVE_START_DATE
AND PET.EFFECTIVE_END_DATE
AND PEEV.INPUT_VALUE_ID = PLIV.INPUT_VALUE_ID
AND PEEV.ELEMENT_ENTRY_ID = PEE.ELEMENT_ENTRY_ID
AND PEEV.EFFECTIVE_START_DATE = PEE.EFFECTIVE_START_DATE
AND PEEV.EFFECTIVE_END_DATE = PEE.EFFECTIVE_END_DATE

Columns