VIEW: APPS.PAY_KR_SEP_RESULT_EEV_V

Source

View Text - Preformatted

SELECT paa.assignment_action_id assignment_action_id, paa.assignment_id assignment_id, ppa.effective_date effective_date, ppa.date_earned date_earned, paa.run_type_id run_type_id, pee.element_entry_id element_entry_id, pliv.link_input_value_id link_input_value_id, pliv.element_link_id element_link_id, pliv.default_value ldefault_value, piv.input_value_id input_value_id, piv.name name, piv.display_sequence display_sequence, piv.hot_default_flag hot_default_flag, piv.default_value idefault_value, pet.element_type_id element_type_id, pivt.name uname, peev.element_entry_value_id element_entry_value_id, peev.effective_start_date veffective_start_date, peev.effective_end_date veffective_end_date, peev.screen_entry_value screent_entry_value, substr(hr_chkfmt.changeformat( decode(piv.lookup_type, null, nvl(peev.screen_entry_value,decode(piv.hot_default_flag, 'Y',nvl(pliv.default_value,piv.default_value), pliv.default_value)), hr_general.decode_lookup(piv.lookup_type, nvl(peev.screen_entry_value,decode(piv.hot_default_flag, 'Y',nvl(pliv.default_value,piv.default_value), pliv.default_value)))),piv.uom,pet.output_currency_code),1,60) entry_value from pay_element_entry_values_f peev, pay_element_types_f pet, pay_input_values_f_tl pivt, pay_input_values_f piv, pay_link_input_values_f pliv, pay_element_entries_f pee, pay_payroll_actions ppa, pay_assignment_actions paa where ppa.payroll_action_id = paa.payroll_action_id and pee.assignment_id = paa.assignment_id and ppa.date_earned between pee.effective_start_date and pee.effective_end_date and pee.creator_type in ('B','EE','F','H','R','RR') and pliv.element_link_id = pee.element_link_id and ppa.date_earned between pliv.effective_start_date and pliv.effective_end_date and piv.input_value_id = pliv.input_value_id and ppa.date_earned between piv.effective_start_date and piv.effective_end_date and pivt.input_value_id = piv.input_value_id and pivt.language = userenv('LANG') and pet.element_type_id = piv.element_type_id and ppa.date_earned between pet.effective_start_date and pet.effective_end_date and peev.input_value_id = pliv.input_value_id and peev.element_entry_id = pee.element_entry_id and peev.effective_start_date = pee.effective_start_date and peev.effective_end_date = pee.effective_end_date

View Text - HTML Formatted

SELECT PAA.ASSIGNMENT_ACTION_ID ASSIGNMENT_ACTION_ID
, PAA.ASSIGNMENT_ID ASSIGNMENT_ID
, PPA.EFFECTIVE_DATE EFFECTIVE_DATE
, PPA.DATE_EARNED DATE_EARNED
, PAA.RUN_TYPE_ID RUN_TYPE_ID
, PEE.ELEMENT_ENTRY_ID ELEMENT_ENTRY_ID
, PLIV.LINK_INPUT_VALUE_ID LINK_INPUT_VALUE_ID
, PLIV.ELEMENT_LINK_ID ELEMENT_LINK_ID
, PLIV.DEFAULT_VALUE LDEFAULT_VALUE
, PIV.INPUT_VALUE_ID INPUT_VALUE_ID
, PIV.NAME NAME
, PIV.DISPLAY_SEQUENCE DISPLAY_SEQUENCE
, PIV.HOT_DEFAULT_FLAG HOT_DEFAULT_FLAG
, PIV.DEFAULT_VALUE IDEFAULT_VALUE
, PET.ELEMENT_TYPE_ID ELEMENT_TYPE_ID
, PIVT.NAME UNAME
, PEEV.ELEMENT_ENTRY_VALUE_ID ELEMENT_ENTRY_VALUE_ID
, PEEV.EFFECTIVE_START_DATE VEFFECTIVE_START_DATE
, PEEV.EFFECTIVE_END_DATE VEFFECTIVE_END_DATE
, PEEV.SCREEN_ENTRY_VALUE SCREENT_ENTRY_VALUE
, SUBSTR(HR_CHKFMT.CHANGEFORMAT( DECODE(PIV.LOOKUP_TYPE
, NULL
, NVL(PEEV.SCREEN_ENTRY_VALUE
, DECODE(PIV.HOT_DEFAULT_FLAG
, 'Y'
, NVL(PLIV.DEFAULT_VALUE
, PIV.DEFAULT_VALUE)
, PLIV.DEFAULT_VALUE))
, HR_GENERAL.DECODE_LOOKUP(PIV.LOOKUP_TYPE
, NVL(PEEV.SCREEN_ENTRY_VALUE
, DECODE(PIV.HOT_DEFAULT_FLAG
, 'Y'
, NVL(PLIV.DEFAULT_VALUE
, PIV.DEFAULT_VALUE)
, PLIV.DEFAULT_VALUE))))
, PIV.UOM
, PET.OUTPUT_CURRENCY_CODE)
, 1
, 60) ENTRY_VALUE
FROM PAY_ELEMENT_ENTRY_VALUES_F PEEV
, PAY_ELEMENT_TYPES_F PET
, PAY_INPUT_VALUES_F_TL PIVT
, PAY_INPUT_VALUES_F PIV
, PAY_LINK_INPUT_VALUES_F PLIV
, PAY_ELEMENT_ENTRIES_F PEE
, PAY_PAYROLL_ACTIONS PPA
, PAY_ASSIGNMENT_ACTIONS PAA
WHERE PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID
AND PEE.ASSIGNMENT_ID = PAA.ASSIGNMENT_ID
AND PPA.DATE_EARNED BETWEEN PEE.EFFECTIVE_START_DATE
AND PEE.EFFECTIVE_END_DATE
AND PEE.CREATOR_TYPE IN ('B'
, 'EE'
, 'F'
, 'H'
, 'R'
, 'RR')
AND PLIV.ELEMENT_LINK_ID = PEE.ELEMENT_LINK_ID
AND PPA.DATE_EARNED BETWEEN PLIV.EFFECTIVE_START_DATE
AND PLIV.EFFECTIVE_END_DATE
AND PIV.INPUT_VALUE_ID = PLIV.INPUT_VALUE_ID
AND PPA.DATE_EARNED BETWEEN PIV.EFFECTIVE_START_DATE
AND PIV.EFFECTIVE_END_DATE
AND PIVT.INPUT_VALUE_ID = PIV.INPUT_VALUE_ID
AND PIVT.LANGUAGE = USERENV('LANG')
AND PET.ELEMENT_TYPE_ID = PIV.ELEMENT_TYPE_ID
AND PPA.DATE_EARNED BETWEEN PET.EFFECTIVE_START_DATE
AND PET.EFFECTIVE_END_DATE
AND PEEV.INPUT_VALUE_ID = PLIV.INPUT_VALUE_ID
AND PEEV.ELEMENT_ENTRY_ID = PEE.ELEMENT_ENTRY_ID
AND PEEV.EFFECTIVE_START_DATE = PEE.EFFECTIVE_START_DATE
AND PEEV.EFFECTIVE_END_DATE = PEE.EFFECTIVE_END_DATE