VIEW: APPS.PAY_AU_TERM_LONG_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 , 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 */

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
, 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 */