View: PAY_AU_TERM_LONG_V

Product:	PAY - Payroll
Description:	Australian localisation view.
Implementation/DBA Data:	APPS.PAY_AU_TERM_LONG_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
, PIV0.UOM
, 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
, 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)
, PIV6.INPUT_VALUE_ID /*BUG# 5056831 */
, SUBSTR(PAY_AU_TERMINATIONS.OVERRIDE_ELIG /*BUG# 5056831 */ (PEE.ELEMENT_ENTRY_ID
, PIV6.INPUT_VALUE_ID
, SES.EFFECTIVE_DATE )
, 1
, 1)
, PIV6.UOM /*BUG# 5056831 */
FROM PAY_ELEMENT_TYPES_F PET
, FND_SESSIONS SES
, PAY_INPUT_VALUES_F PIV0
, PAY_INPUT_VALUES_F PIV1
, 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 /*BUG# 5056831 */
, 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
WHERE PET.ELEMENT_NAME = 'LONG SERVICE LEAVE 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) = 'PRE 16_08_1978 PAY'
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) = 'POST 15_08_1978 PAY'
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) = 'POST 17_08_1993 PAY'
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) = 'PRE 16_08_1978 HOURS'
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) = 'POST 15_08_1978 HOURS'
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) = 'POST 17_08_1993 HOURS'
AND PIV6.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID /*BUG# 5056831 */
AND PIV6.NAME = 'OVERRIDE_ELIGIBILITY' /*BUG# 5056831 */
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 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 /*BUG# 5056831 */

Columns