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: APPS.PAY_PAYAUTAX_PYE_ENT_V

Source

View Text - Preformatted


SELECT /*+ ordered */ pee.rowid ,pee.object_version_number ,pee.element_entry_id ,eev0.input_value_id ,hrl0.meaning ,DECODE ( eev0.screen_entry_value ,'YS', 'Y' ,'YI', 'Y' ,'YC', 'Y' ,'NN', 'N' ,'YN', 'Y' ,'Y', 'Y' ,'N', 'N' ,Null ) ,DECODE ( eev0.screen_entry_value ,'YS', 'S' ,'YI', 'I' ,'YC', 'C' ,'NN', 'N' ,'YN', 'N' ,'N' ) ,eev1.input_value_id ,hrl1.meaning ,eev1.screen_entry_value ,eev2.input_value_id ,eev2.screen_entry_value ,eev2.screen_entry_value ,eev3.input_value_id ,hrl3.meaning ,DECODE( eev3.screen_entry_value, 'N', 'N', 'Y', 'Y', 'NF','N', 'NP','N', 'NC','N', 'YF','Y', 'YP','Y', 'YC','Y', 'N' ) ,DECODE( eev3.screen_entry_value, 'Y', 'X', 'N', 'X', 'NF','F', 'NP','P', 'NC','C', 'YF','F', 'YP','P', 'YC','C', 'X') ,eev4.input_value_id ,hrl4.meaning ,eev4.screen_entry_value ,eev5.input_value_id ,hrl5.meaning ,DECODE ( eev5.screen_entry_value ,'Y', 'Y' ,'N', 'N' ,'YY','Y' ,'NY','N' ,Null ) hecs_entry_value ,hrl5.meaning ,DECODE (eev5.screen_entry_value, 'YY', 'Y', 'NY', 'Y', 'N') sfss_entry_value ,eev6.input_value_id ,eev6.screen_entry_value ,eev6.screen_entry_value ,eev7.input_value_id ,hrl7.meaning ,eev7.screen_entry_value ,eev8.input_value_id ,hrl8.meaning ,DECODE ( eev8.screen_entry_value ,'Y', 'Y' ,'N', 'N' ,'YY', 'Y' ,'NY', 'N' ,Null ) spouse_entry_value ,hrl8.meaning ,DECODE (eev8.screen_entry_value, 'YY', 'Y', 'NY', 'Y', 'N') mls_entry_value ,eev9.input_value_id ,eev9.screen_entry_value ,eev9.screen_entry_value ,eev10.input_value_id ,hrl9.meaning ,DECODE ( eev10.screen_entry_value ,'N', 'N' ,'P', 'P' ,'F', 'F' ,'E', 'E' ,'EY', 'E' ,'EN', 'E' ,'PY', 'P' ,'PN', 'P' ,'FY', 'F' ,'FN', 'F' ,'N' ) tvt_entry_value ,hrl9.meaning ,DECODE ( eev10.screen_entry_value ,'N', 'N' ,'P', 'Y' ,'F', 'Y' ,'E', 'Y' ,'EY', 'Y' ,'EN', 'N' ,'PY', 'Y' ,'PN', 'N' ,'FY', 'Y' ,'FN', 'N' ,'N' ) tvb_entry_value /* 5088751 */ ,eev11.input_value_id ,eev11.screen_entry_value ,eev11.screen_entry_value ,eev13.input_value_id ,eev13.screen_entry_value ,eev13.screen_entry_value ,pee.assignment_id ,pee.effective_start_date ,pee.effective_end_date ,pee.entry_information1 from pay_element_entries_f pee /* 4179174 */ , fnd_sessions ses , pay_element_types_f pet ,pay_input_values_f piv0 ,pay_element_entry_values_f eev0 ,pay_input_values_f piv1 ,pay_element_entry_values_f eev1 ,pay_input_values_f piv2 ,pay_element_entry_values_f eev2 ,pay_input_values_f piv3 ,pay_element_entry_values_f eev3 ,pay_input_values_f piv4 ,pay_element_entry_values_f eev4 ,pay_input_values_f piv5 ,pay_element_entry_values_f eev5 ,pay_input_values_f piv6 ,pay_element_entry_values_f eev6 ,pay_input_values_f piv7 ,pay_element_entry_values_f eev7 ,pay_input_values_f piv8 ,pay_element_entry_values_f eev8 ,pay_input_values_f piv9 ,pay_element_entry_values_f eev9 ,pay_input_values_f piv10 ,pay_element_entry_values_f eev10 ,pay_input_values_f piv11 ,pay_element_entry_values_f eev11 ,pay_input_values_f piv13 ,pay_element_entry_values_f eev13 ,hr_lookups hrl0 ,hr_lookups hrl1 ,hr_lookups hrl3 ,hr_lookups hrl4 ,hr_lookups hrl5 ,hr_lookups hrl7 ,hr_lookups hrl8 ,hr_lookups hrl9 WHERE pet.element_name = 'Tax Information' 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) = 'Australian Resident' and hrl0.lookup_type(+) = 'AU_AUST_RES_SENR_AUS' and hrl0.lookup_code(+) = eev0.screen_entry_value and hrl0.enabled_flag(+) = 'Y' and eev1.input_value_id = piv1.input_value_id and eev1.element_entry_id = pee.element_entry_id and piv1.element_type_id = pet.element_type_id and (piv1.NAME) = 'Tax Free Threshold' and hrl1.lookup_type(+) = 'YES_NO' and hrl1.lookup_code(+) = eev1.screen_entry_value and hrl1.enabled_flag(+) = 'Y' 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) = 'Rebate Amount' 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) = 'FTA Claim' and hrl3.lookup_type(+) = 'HR_AU_FTA_PAYMENT_BASIS' and hrl3.lookup_code(+) = eev3.screen_entry_value and hrl3.enabled_flag(+) = 'Y' 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) = 'Savings Rebate' and hrl4.lookup_type(+) = 'YES_NO' and hrl4.lookup_code(+) = eev4.screen_entry_value and hrl4.enabled_flag(+) = 'Y' 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) = 'HECS' and hrl5.lookup_type(+) = 'AU_HECS_SFSS' and hrl5.lookup_code(+) = eev5.screen_entry_value and hrl5.enabled_flag(+) = 'Y' 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) = 'Date Declaration Signed' 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) = 'Medicare Levy Variation' and hrl7.lookup_type(+) = 'AU_MED_LEV_VAR' and hrl7.lookup_code(+) = eev7.screen_entry_value and hrl7.enabled_flag(+) = 'Y' 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) = 'Spouse' and hrl8.lookup_type(+) = 'AU_SPOUSE_MLS' and hrl8.lookup_code(+) = eev8.screen_entry_value and hrl8.enabled_flag(+) = 'Y' 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) = 'Dependent Children' and eev10.input_value_id = piv10.input_value_id and piv10.element_type_id = pet.element_type_id and eev10.element_entry_id = pee.element_entry_id and (piv10.NAME) = 'Tax Variation Type' AND hrl9.lookup_type(+) = 'AU_TVT_TVB' and hrl9.lookup_code(+) = eev10.screen_entry_value and hrl9.enabled_flag(+) = 'Y' and eev11.input_value_id = piv11.input_value_id and piv11.element_type_id = pet.element_type_id and eev11.element_entry_id = pee.element_entry_id and (piv11.NAME) = 'Tax Variation Amount' and eev13.input_value_id = piv13.input_value_id and piv13.element_type_id = pet.element_type_id and eev13.element_entry_id = pee.element_entry_id and (piv13.NAME) = 'Tax File Number' 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 eev10.effective_start_date and eev10.effective_end_date and ses.effective_date between eev11.effective_start_date and eev11.effective_end_date and ses.effective_date between eev13.effective_start_date and eev13.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 and ses.effective_date between piv13.effective_start_date and piv13.effective_end_date

View Text - HTML Formatted

SELECT /*+ ORDERED */ PEE.ROWID
, PEE.OBJECT_VERSION_NUMBER
, PEE.ELEMENT_ENTRY_ID
, EEV0.INPUT_VALUE_ID
, HRL0.MEANING
, DECODE ( EEV0.SCREEN_ENTRY_VALUE
, 'YS'
, 'Y'
, 'YI'
, 'Y'
, 'YC'
, 'Y'
, 'NN'
, 'N'
, 'YN'
, 'Y'
, 'Y'
, 'Y'
, 'N'
, 'N'
, NULL )
, DECODE ( EEV0.SCREEN_ENTRY_VALUE
, 'YS'
, 'S'
, 'YI'
, 'I'
, 'YC'
, 'C'
, 'NN'
, 'N'
, 'YN'
, 'N'
, 'N' )
, EEV1.INPUT_VALUE_ID
, HRL1.MEANING
, EEV1.SCREEN_ENTRY_VALUE
, EEV2.INPUT_VALUE_ID
, EEV2.SCREEN_ENTRY_VALUE
, EEV2.SCREEN_ENTRY_VALUE
, EEV3.INPUT_VALUE_ID
, HRL3.MEANING
, DECODE( EEV3.SCREEN_ENTRY_VALUE
, 'N'
, 'N'
, 'Y'
, 'Y'
, 'NF'
, 'N'
, 'NP'
, 'N'
, 'NC'
, 'N'
, 'YF'
, 'Y'
, 'YP'
, 'Y'
, 'YC'
, 'Y'
, 'N' )
, DECODE( EEV3.SCREEN_ENTRY_VALUE
, 'Y'
, 'X'
, 'N'
, 'X'
, 'NF'
, 'F'
, 'NP'
, 'P'
, 'NC'
, 'C'
, 'YF'
, 'F'
, 'YP'
, 'P'
, 'YC'
, 'C'
, 'X')
, EEV4.INPUT_VALUE_ID
, HRL4.MEANING
, EEV4.SCREEN_ENTRY_VALUE
, EEV5.INPUT_VALUE_ID
, HRL5.MEANING
, DECODE ( EEV5.SCREEN_ENTRY_VALUE
, 'Y'
, 'Y'
, 'N'
, 'N'
, 'YY'
, 'Y'
, 'NY'
, 'N'
, NULL ) HECS_ENTRY_VALUE
, HRL5.MEANING
, DECODE (EEV5.SCREEN_ENTRY_VALUE
, 'YY'
, 'Y'
, 'NY'
, 'Y'
, 'N') SFSS_ENTRY_VALUE
, EEV6.INPUT_VALUE_ID
, EEV6.SCREEN_ENTRY_VALUE
, EEV6.SCREEN_ENTRY_VALUE
, EEV7.INPUT_VALUE_ID
, HRL7.MEANING
, EEV7.SCREEN_ENTRY_VALUE
, EEV8.INPUT_VALUE_ID
, HRL8.MEANING
, DECODE ( EEV8.SCREEN_ENTRY_VALUE
, 'Y'
, 'Y'
, 'N'
, 'N'
, 'YY'
, 'Y'
, 'NY'
, 'N'
, NULL ) SPOUSE_ENTRY_VALUE
, HRL8.MEANING
, DECODE (EEV8.SCREEN_ENTRY_VALUE
, 'YY'
, 'Y'
, 'NY'
, 'Y'
, 'N') MLS_ENTRY_VALUE
, EEV9.INPUT_VALUE_ID
, EEV9.SCREEN_ENTRY_VALUE
, EEV9.SCREEN_ENTRY_VALUE
, EEV10.INPUT_VALUE_ID
, HRL9.MEANING
, DECODE ( EEV10.SCREEN_ENTRY_VALUE
, 'N'
, 'N'
, 'P'
, 'P'
, 'F'
, 'F'
, 'E'
, 'E'
, 'EY'
, 'E'
, 'EN'
, 'E'
, 'PY'
, 'P'
, 'PN'
, 'P'
, 'FY'
, 'F'
, 'FN'
, 'F'
, 'N' ) TVT_ENTRY_VALUE
, HRL9.MEANING
, DECODE ( EEV10.SCREEN_ENTRY_VALUE
, 'N'
, 'N'
, 'P'
, 'Y'
, 'F'
, 'Y'
, 'E'
, 'Y'
, 'EY'
, 'Y'
, 'EN'
, 'N'
, 'PY'
, 'Y'
, 'PN'
, 'N'
, 'FY'
, 'Y'
, 'FN'
, 'N'
, 'N' ) TVB_ENTRY_VALUE /* 5088751 */
, EEV11.INPUT_VALUE_ID
, EEV11.SCREEN_ENTRY_VALUE
, EEV11.SCREEN_ENTRY_VALUE
, EEV13.INPUT_VALUE_ID
, EEV13.SCREEN_ENTRY_VALUE
, EEV13.SCREEN_ENTRY_VALUE
, PEE.ASSIGNMENT_ID
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE
, PEE.ENTRY_INFORMATION1
FROM PAY_ELEMENT_ENTRIES_F PEE /* 4179174 */
, FND_SESSIONS SES
, PAY_ELEMENT_TYPES_F PET
, PAY_INPUT_VALUES_F PIV0
, PAY_ELEMENT_ENTRY_VALUES_F EEV0
, PAY_INPUT_VALUES_F PIV1
, PAY_ELEMENT_ENTRY_VALUES_F EEV1
, PAY_INPUT_VALUES_F PIV2
, PAY_ELEMENT_ENTRY_VALUES_F EEV2
, PAY_INPUT_VALUES_F PIV3
, PAY_ELEMENT_ENTRY_VALUES_F EEV3
, PAY_INPUT_VALUES_F PIV4
, PAY_ELEMENT_ENTRY_VALUES_F EEV4
, PAY_INPUT_VALUES_F PIV5
, PAY_ELEMENT_ENTRY_VALUES_F EEV5
, PAY_INPUT_VALUES_F PIV6
, PAY_ELEMENT_ENTRY_VALUES_F EEV6
, PAY_INPUT_VALUES_F PIV7
, PAY_ELEMENT_ENTRY_VALUES_F EEV7
, PAY_INPUT_VALUES_F PIV8
, PAY_ELEMENT_ENTRY_VALUES_F EEV8
, PAY_INPUT_VALUES_F PIV9
, PAY_ELEMENT_ENTRY_VALUES_F EEV9
, PAY_INPUT_VALUES_F PIV10
, PAY_ELEMENT_ENTRY_VALUES_F EEV10
, PAY_INPUT_VALUES_F PIV11
, PAY_ELEMENT_ENTRY_VALUES_F EEV11
, PAY_INPUT_VALUES_F PIV13
, PAY_ELEMENT_ENTRY_VALUES_F EEV13
, HR_LOOKUPS HRL0
, HR_LOOKUPS HRL1
, HR_LOOKUPS HRL3
, HR_LOOKUPS HRL4
, HR_LOOKUPS HRL5
, HR_LOOKUPS HRL7
, HR_LOOKUPS HRL8
, HR_LOOKUPS HRL9
WHERE PET.ELEMENT_NAME = 'TAX INFORMATION'
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) = 'AUSTRALIAN RESIDENT'
AND HRL0.LOOKUP_TYPE(+) = 'AU_AUST_RES_SENR_AUS'
AND HRL0.LOOKUP_CODE(+) = EEV0.SCREEN_ENTRY_VALUE
AND HRL0.ENABLED_FLAG(+) = 'Y'
AND EEV1.INPUT_VALUE_ID = PIV1.INPUT_VALUE_ID
AND EEV1.ELEMENT_ENTRY_ID = PEE.ELEMENT_ENTRY_ID
AND PIV1.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND (PIV1.NAME) = 'TAX FREE THRESHOLD'
AND HRL1.LOOKUP_TYPE(+) = 'YES_NO'
AND HRL1.LOOKUP_CODE(+) = EEV1.SCREEN_ENTRY_VALUE
AND HRL1.ENABLED_FLAG(+) = 'Y'
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) = 'REBATE AMOUNT'
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) = 'FTA CLAIM'
AND HRL3.LOOKUP_TYPE(+) = 'HR_AU_FTA_PAYMENT_BASIS'
AND HRL3.LOOKUP_CODE(+) = EEV3.SCREEN_ENTRY_VALUE
AND HRL3.ENABLED_FLAG(+) = 'Y'
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) = 'SAVINGS REBATE'
AND HRL4.LOOKUP_TYPE(+) = 'YES_NO'
AND HRL4.LOOKUP_CODE(+) = EEV4.SCREEN_ENTRY_VALUE
AND HRL4.ENABLED_FLAG(+) = 'Y'
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) = 'HECS'
AND HRL5.LOOKUP_TYPE(+) = 'AU_HECS_SFSS'
AND HRL5.LOOKUP_CODE(+) = EEV5.SCREEN_ENTRY_VALUE
AND HRL5.ENABLED_FLAG(+) = 'Y'
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) = 'DATE DECLARATION SIGNED'
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) = 'MEDICARE LEVY VARIATION'
AND HRL7.LOOKUP_TYPE(+) = 'AU_MED_LEV_VAR'
AND HRL7.LOOKUP_CODE(+) = EEV7.SCREEN_ENTRY_VALUE
AND HRL7.ENABLED_FLAG(+) = 'Y'
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) = 'SPOUSE'
AND HRL8.LOOKUP_TYPE(+) = 'AU_SPOUSE_MLS'
AND HRL8.LOOKUP_CODE(+) = EEV8.SCREEN_ENTRY_VALUE
AND HRL8.ENABLED_FLAG(+) = 'Y'
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) = 'DEPENDENT CHILDREN'
AND EEV10.INPUT_VALUE_ID = PIV10.INPUT_VALUE_ID
AND PIV10.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND EEV10.ELEMENT_ENTRY_ID = PEE.ELEMENT_ENTRY_ID
AND (PIV10.NAME) = 'TAX VARIATION TYPE'
AND HRL9.LOOKUP_TYPE(+) = 'AU_TVT_TVB'
AND HRL9.LOOKUP_CODE(+) = EEV10.SCREEN_ENTRY_VALUE
AND HRL9.ENABLED_FLAG(+) = 'Y'
AND EEV11.INPUT_VALUE_ID = PIV11.INPUT_VALUE_ID
AND PIV11.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND EEV11.ELEMENT_ENTRY_ID = PEE.ELEMENT_ENTRY_ID
AND (PIV11.NAME) = 'TAX VARIATION AMOUNT'
AND EEV13.INPUT_VALUE_ID = PIV13.INPUT_VALUE_ID
AND PIV13.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND EEV13.ELEMENT_ENTRY_ID = PEE.ELEMENT_ENTRY_ID
AND (PIV13.NAME) = 'TAX FILE NUMBER'
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 EEV10.EFFECTIVE_START_DATE
AND EEV10.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN EEV11.EFFECTIVE_START_DATE
AND EEV11.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN EEV13.EFFECTIVE_START_DATE
AND EEV13.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
AND SES.EFFECTIVE_DATE BETWEEN PIV13.EFFECTIVE_START_DATE
AND PIV13.EFFECTIVE_END_DATE