View: PAY_AU_TERM_SUPER_V

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

View Text

SELECT 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
, PEE.ASSIGNMENT_ID
, PEE.PERSONAL_PAYMENT_METHOD_ID
, PMTH.ORG_PAYMENT_METHOD_ID
, PPT.PAYMENT_TYPE_ID
, HAOU.NAME||' '||OMTH.ORG_PAYMENT_METHOD_NAME||' '||PPT.PAYMENT_TYPE_NAME
, 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)
FROM PAY_ELEMENT_TYPES_F PET
, PAY_ELEMENT_ENTRIES_F PEE
, PAY_ELEMENT_ENTRY_VALUES_F EEV0
, PAY_INPUT_VALUES_F PIV0
, PAY_ELEMENT_ENTRY_VALUES_F EEV1
, PAY_INPUT_VALUES_F PIV1
, PAY_ELEMENT_ENTRY_VALUES_F EEV2
, PAY_INPUT_VALUES_F PIV2
, PAY_PERSONAL_PAYMENT_METHODS_F PMTH
, PAY_ORG_PAYMENT_METHODS_F OMTH
, PAY_PAYMENT_TYPES PPT
, HR_ALL_ORGANIZATION_UNITS HAOU
, FND_SESSIONS SES
WHERE PET.ELEMENT_NAME = 'SUPERANNUATION ROLLOVER 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 VALUE'
AND PET.ELEMENT_TYPE_ID = PIV1.ELEMENT_TYPE_ID
AND EEV1.INPUT_VALUE_ID = PIV1.INPUT_VALUE_ID
AND EEV1.ELEMENT_ENTRY_ID = PEE.ELEMENT_ENTRY_ID
AND (PIV1.NAME) = 'AMOUNT PART PREV ETP'
AND PET.ELEMENT_TYPE_ID = PIV2.ELEMENT_TYPE_ID
AND EEV2.INPUT_VALUE_ID = PIV2.INPUT_VALUE_ID
AND EEV2.ELEMENT_ENTRY_ID = PEE.ELEMENT_ENTRY_ID
AND (PIV2.NAME) = 'AMOUNT NOT PART PREV ETP'
AND PEE.ASSIGNMENT_ID = PMTH.ASSIGNMENT_ID
AND PMTH.PAYEE_TYPE = 'O'
AND PMTH.PAYEE_ID = HAOU.ORGANIZATION_ID
AND PEE.PERSONAL_PAYMENT_METHOD_ID = PMTH.PERSONAL_PAYMENT_METHOD_ID
AND PMTH.ORG_PAYMENT_METHOD_ID = OMTH.ORG_PAYMENT_METHOD_ID
AND OMTH.PAYMENT_TYPE_ID = PPT.PAYMENT_TYPE_ID
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 PIV0.EFFECTIVE_START_DATE
AND PIV0.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN EEV1.EFFECTIVE_START_DATE
AND EEV1.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN PIV1.EFFECTIVE_START_DATE
AND PIV1.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN EEV2.EFFECTIVE_START_DATE
AND EEV2.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN PIV2.EFFECTIVE_START_DATE
AND PIV2.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN PMTH.EFFECTIVE_START_DATE
AND PMTH.EFFECTIVE_END_DATE

Columns