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.

VIEW: APPS.PAY_AU_TERM_ANNUAL_V

Source

View Text - Preformatted


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 , 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) 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_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 where pet.element_name = 'Annual Leave on Termination' and eev0.input_value_id = piv0.input_value_id and pet.element_type_id = piv0.element_type_id and eev0.element_entry_id = pee.element_entry_id and (piv0.name) = 'Hours' 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) = '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 = 'Loading' 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 = 'Other' 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 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

View Text - HTML Formatted

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
, 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)
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_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
WHERE PET.ELEMENT_NAME = 'ANNUAL LEAVE ON TERMINATION'
AND EEV0.INPUT_VALUE_ID = PIV0.INPUT_VALUE_ID
AND PET.ELEMENT_TYPE_ID = PIV0.ELEMENT_TYPE_ID
AND EEV0.ELEMENT_ENTRY_ID = PEE.ELEMENT_ENTRY_ID
AND (PIV0.NAME) = 'HOURS'
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) = '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 = 'LOADING'
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 = 'OTHER'
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 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