eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: PAY_AU_TERM_ETP_V

Product:	PAY - Payroll
Description:	Australian localisation view.
Implementation/DBA Data:	APPS.PAY_AU_TERM_ETP_V

View Text

SELECT /*+ ORDERED */ PEE.ROWID
, PEE.OBJECT_VERSION_NUMBER
, PEE.ELEMENT_ENTRY_ID
, PEE.ELEMENT_LINK_ID
, PEE.CREATOR_TYPE
, PEE.ENTRY_TYPE
, PET.ELEMENT_TYPE_ID
, EEV0.INPUT_VALUE_ID
, EEV0.SCREEN_ENTRY_VALUE
, EEV1.INPUT_VALUE_ID
, EEV1.SCREEN_ENTRY_VALUE
, PIV1.UOM
, EEV2.INPUT_VALUE_ID
, EEV2.SCREEN_ENTRY_VALUE
, PIV2.UOM
, EEV3.INPUT_VALUE_ID
, EEV3.SCREEN_ENTRY_VALUE
, PIV3.UOM
, EEV4.INPUT_VALUE_ID
, EEV4.SCREEN_ENTRY_VALUE
, PIV4.UOM
, EEV5.INPUT_VALUE_ID
, EEV5.SCREEN_ENTRY_VALUE
, PIV5.UOM
, EEV6.INPUT_VALUE_ID
, EEV6.SCREEN_ENTRY_VALUE
, PIV6.UOM
, PEE.ASSIGNMENT_ID
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE
, SUBSTR (PAY_AU_TERMINATIONS.PROCESSED ( PEE.ELEMENT_ENTRY_ID
, PEE.ORIGINAL_ENTRY_ID
, PET.PROCESSING_TYPE
, PEE.ENTRY_TYPE
, SES.EFFECTIVE_DATE )
, 1
, 1)
, EEV7.INPUT_VALUE_ID
, EEV7.SCREEN_ENTRY_VALUE
, PIV7.UOM
, EEV8.INPUT_VALUE_ID
, EEV8.SCREEN_ENTRY_VALUE
, PIV8.UOM
, EEV9.INPUT_VALUE_ID
, TO_DATE(EEV9.SCREEN_ENTRY_VALUE
, 'YYYY/MM/DD HH24:MI:SS')
, PIV9.UOM
, PIV10.INPUT_VALUE_ID
, SUBSTR(PAY_AU_TERMINATIONS.OVERRIDE_ELIG /*BUG# 5956223 */ (PEE.ELEMENT_ENTRY_ID
, PIV10.INPUT_VALUE_ID
, SES.EFFECTIVE_DATE )
, 1
, 1)
, PIV11.INPUT_VALUE_ID
, SUBSTR(PAY_AU_TERMINATIONS.OVERRIDE_ELIG /*BUG# 5956223 */ (PEE.ELEMENT_ENTRY_ID
, PIV11.INPUT_VALUE_ID
, SES.EFFECTIVE_DATE )
, 1
, 1)
FROM FND_SESSIONS SES
, PAY_ELEMENT_TYPES_F PET
, PAY_INPUT_VALUES_F PIV1
, PAY_INPUT_VALUES_F PIV0
, PAY_INPUT_VALUES_F PIV2
, PAY_INPUT_VALUES_F PIV3
, PAY_INPUT_VALUES_F PIV4
, PAY_INPUT_VALUES_F PIV5
, PAY_INPUT_VALUES_F PIV6
, PAY_INPUT_VALUES_F PIV7
, PAY_INPUT_VALUES_F PIV8
, PAY_INPUT_VALUES_F PIV9
, PAY_INPUT_VALUES_F PIV10
, PAY_INPUT_VALUES_F PIV11
, PAY_ELEMENT_ENTRY_VALUES_F EEV0
, PAY_ELEMENT_ENTRIES_F PEE
, PAY_ELEMENT_ENTRY_VALUES_F EEV1
, PAY_ELEMENT_ENTRY_VALUES_F EEV2
, PAY_ELEMENT_ENTRY_VALUES_F EEV3
, PAY_ELEMENT_ENTRY_VALUES_F EEV4
, PAY_ELEMENT_ENTRY_VALUES_F EEV5
, PAY_ELEMENT_ENTRY_VALUES_F EEV6
, PAY_ELEMENT_ENTRY_VALUES_F EEV7
, PAY_ELEMENT_ENTRY_VALUES_F EEV8
, PAY_ELEMENT_ENTRY_VALUES_F EEV9
WHERE PET.ELEMENT_NAME = 'ETP ON TERMINATION'
AND PET.ELEMENT_TYPE_ID = PIV0.ELEMENT_TYPE_ID
AND EEV0.INPUT_VALUE_ID = PIV0.INPUT_VALUE_ID
AND EEV0.ELEMENT_ENTRY_ID = PEE.ELEMENT_ENTRY_ID
AND (PIV0.NAME) = 'PAY ETP COMPONENTS'
AND EEV1.INPUT_VALUE_ID = PIV1.INPUT_VALUE_ID
AND PIV1.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND EEV1.ELEMENT_ENTRY_ID = PEE.ELEMENT_ENTRY_ID
AND (PIV1.NAME) = 'REDUNDANCY PAYMENT'
AND EEV2.INPUT_VALUE_ID = PIV2.INPUT_VALUE_ID
AND PIV2.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND EEV2.ELEMENT_ENTRY_ID = PEE.ELEMENT_ENTRY_ID
AND (PIV2.NAME) = 'GOLDEN HANDSHAKE'
AND EEV3.INPUT_VALUE_ID = PIV3.INPUT_VALUE_ID
AND PIV3.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND EEV3.ELEMENT_ENTRY_ID = PEE.ELEMENT_ENTRY_ID
AND (PIV3.NAME) = 'SALARY IN LIEU OF NOTICE'
AND EEV4.INPUT_VALUE_ID = PIV4.INPUT_VALUE_ID
AND PIV4.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND EEV4.ELEMENT_ENTRY_ID = PEE.ELEMENT_ENTRY_ID
AND (PIV4.NAME) = 'UNUSED SICK LEAVE'
AND EEV5.INPUT_VALUE_ID = PIV5.INPUT_VALUE_ID
AND PIV5.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND EEV5.ELEMENT_ENTRY_ID = PEE.ELEMENT_ENTRY_ID
AND (PIV5.NAME) = 'UNUSED RDO'
AND EEV6.INPUT_VALUE_ID = PIV6.INPUT_VALUE_ID
AND PIV6.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND EEV6.ELEMENT_ENTRY_ID = PEE.ELEMENT_ENTRY_ID
AND (PIV6.NAME) = 'OTHER'
AND EEV7.INPUT_VALUE_ID = PIV7.INPUT_VALUE_ID
AND PIV7.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND EEV7.ELEMENT_ENTRY_ID = PEE.ELEMENT_ENTRY_ID
AND (PIV7.NAME) = 'PRE 1983 DAYS'
AND EEV8.INPUT_VALUE_ID = PIV8.INPUT_VALUE_ID
AND PIV8.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND EEV8.ELEMENT_ENTRY_ID = PEE.ELEMENT_ENTRY_ID
AND (PIV8.NAME) = 'POST 1983 DAYS'
AND EEV9.INPUT_VALUE_ID = PIV9.INPUT_VALUE_ID
AND PIV9.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND EEV9.ELEMENT_ENTRY_ID = PEE.ELEMENT_ENTRY_ID
AND (PIV9.NAME) = 'ETP SERVICE DATE'
AND PIV10.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND (PIV10.NAME) = 'TRANSITIONAL ETP'
AND PIV11.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND (PIV11.NAME) = 'PART OF PREVIOUSLY PAID ETP'
AND SES.SESSION_ID = USERENV('SESSIONID')
AND SES.EFFECTIVE_DATE BETWEEN PET.EFFECTIVE_START_DATE
AND PET.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN PEE.EFFECTIVE_START_DATE
AND PEE.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN EEV0.EFFECTIVE_START_DATE
AND EEV0.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN EEV1.EFFECTIVE_START_DATE
AND EEV1.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN EEV2.EFFECTIVE_START_DATE
AND EEV2.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN EEV3.EFFECTIVE_START_DATE
AND EEV3.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN EEV4.EFFECTIVE_START_DATE
AND EEV4.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN EEV5.EFFECTIVE_START_DATE
AND EEV5.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN EEV6.EFFECTIVE_START_DATE
AND EEV6.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN EEV7.EFFECTIVE_START_DATE
AND EEV7.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN EEV8.EFFECTIVE_START_DATE
AND EEV8.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN EEV9.EFFECTIVE_START_DATE
AND EEV9.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN PIV0.EFFECTIVE_START_DATE
AND PIV0.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN PIV1.EFFECTIVE_START_DATE
AND PIV1.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN PIV2.EFFECTIVE_START_DATE
AND PIV2.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN PIV3.EFFECTIVE_START_DATE
AND PIV3.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN PIV4.EFFECTIVE_START_DATE
AND PIV4.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN PIV5.EFFECTIVE_START_DATE
AND PIV5.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN PIV6.EFFECTIVE_START_DATE
AND PIV6.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN PIV7.EFFECTIVE_START_DATE
AND PIV7.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN PIV8.EFFECTIVE_START_DATE
AND PIV8.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN PIV9.EFFECTIVE_START_DATE
AND PIV9.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN PIV10.EFFECTIVE_START_DATE
AND PIV10.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN PIV11.EFFECTIVE_START_DATE
AND PIV11.EFFECTIVE_END_DATE

Columns

Name
ROW_ID
OBJECT_VERSION_NUMBER
ELEMENT_ENTRY_ID
ELEMENT_LINK_ID
CREATOR_TYPE
ENTRY_TYPE
ELEMENT_TYPE_ID
PAY_ETP_INPUT_VALUE_ID
PAY_ETP_ENTRY_VALUE
REDUNDANCY_INPUT_VALUE_ID
REDUNDANCY_ENTRY_VALUE
REDUNDANCY_UOM
GOLDEN_INPUT_VALUE_ID
GOLDEN_ENTRY_VALUE
GOLDEN_UOM
LIEU_INPUT_VALUE_ID
LIEU_ENTRY_VALUE
LIEU_UOM
SICK_INPUT_VALUE_ID
SICK_ENTRY_VALUE
SICK_UOM
RDO_INPUT_VALUE_ID
RDO_ENTRY_VALUE
RDO_UOM
OTHER_INPUT_VALUE_ID
OTHER_ENTRY_VALUE
OTHER_UOM
ASSIGNMENT_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
PROCESSED
PRE_1983_INPUT_VALUE_ID
PRE_1983_ENTRY_VALUE
PRE_1983_UOM
POST_1983_INPUT_VALUE_ID
POST_1983_ENTRY_VALUE
POST_1983_UOM
ETP_CS_DATE_INPUT_VALUE_ID
ETP_CS_DATE_ENTRY_VALUE
ETP_CS_DATE_UOM
TRANS_ETP_INPUT_VALUE_ID
TRANS_ETP_ENTRY_VALUE
PART_PREV_ETP_INPUT_VALUE_ID
PART_PREV_ETP_ENTRY_VALUE