VIEW: APPS.PAY_AU_TERM_SUPER_V

Source

View Text - Preformatted

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 , eev3.input_value_id , eev3.screen_entry_value , piv3.uom , eev4.input_value_id , eev4.screen_entry_value , piv4.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_element_entry_values_f eev3 , pay_input_values_f piv3 , pay_element_entry_values_f eev4 , pay_input_values_f piv4 , 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 pet.element_type_id = piv3.element_type_id and eev3.input_value_id = piv3.input_value_id and eev3.element_entry_id = pee.element_entry_id and (piv3.name) = 'Tax Free Amt Part Prev ETP' and pet.element_type_id = piv4.element_type_id and eev4.input_value_id = piv4.input_value_id and eev4.element_entry_id = pee.element_entry_id and (piv4.name) = 'Tax Free Amt 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 eev3.effective_start_date and eev3.effective_end_date and ses.effective_date between piv3.effective_start_date and piv3.effective_end_date and ses.effective_date between eev4.effective_start_date and eev4.effective_end_date and ses.effective_date between piv4.effective_start_date and piv4.effective_end_date and ses.effective_date between pmth.effective_start_date and pmth.effective_end_date

View Text - HTML Formatted

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
, EEV3.INPUT_VALUE_ID
, EEV3.SCREEN_ENTRY_VALUE
, PIV3.UOM
, EEV4.INPUT_VALUE_ID
, EEV4.SCREEN_ENTRY_VALUE
, PIV4.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_ELEMENT_ENTRY_VALUES_F EEV3
, PAY_INPUT_VALUES_F PIV3
, PAY_ELEMENT_ENTRY_VALUES_F EEV4
, PAY_INPUT_VALUES_F PIV4
, 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 PET.ELEMENT_TYPE_ID = PIV3.ELEMENT_TYPE_ID
AND EEV3.INPUT_VALUE_ID = PIV3.INPUT_VALUE_ID
AND EEV3.ELEMENT_ENTRY_ID = PEE.ELEMENT_ENTRY_ID
AND (PIV3.NAME) = 'TAX FREE AMT PART PREV ETP'
AND PET.ELEMENT_TYPE_ID = PIV4.ELEMENT_TYPE_ID
AND EEV4.INPUT_VALUE_ID = PIV4.INPUT_VALUE_ID
AND EEV4.ELEMENT_ENTRY_ID = PEE.ELEMENT_ENTRY_ID
AND (PIV4.NAME) = 'TAX FREE AMT 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 EEV3.EFFECTIVE_START_DATE
AND EEV3.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN PIV3.EFFECTIVE_START_DATE
AND PIV3.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN EEV4.EFFECTIVE_START_DATE
AND EEV4.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN PIV4.EFFECTIVE_START_DATE
AND PIV4.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN PMTH.EFFECTIVE_START_DATE
AND PMTH.EFFECTIVE_END_DATE