VIEW: APPS.PAY_KR_SEP_RESULT_TAX_PREV_V

Source

View Text - Preformatted

SELECT paa.assignment_action_id, paa.assignment_id, ppa.effective_date, ppa.date_earned, paa.run_type_id, pet.element_type_id, piv.input_value_id input_value_id, pee.element_entry_id element_entry_id, peev.screen_entry_value, piv.name input_value_name from pay_payroll_actions ppa, pay_assignment_actions paa, pay_element_entries_f pee, pay_element_types_f pet, pay_element_entry_values_f peev, pay_input_values_f piv, pay_run_types_f prt where ppa.payroll_action_id = paa.payroll_action_id and pee.assignment_id = paa.assignment_id and pee.element_type_id = pet.element_type_id and pet.element_name = 'PREV_ER_INFO' and pee.element_entry_id = peev.element_entry_id and pet.legislation_code = 'KR' and peev.input_value_id = piv.input_value_id and prt.run_type_id = paa.run_type_id and piv.element_type_id = pet.element_type_id and prt.run_type_name in ('SEP','SEP_I') and ppa.date_earned between pee.effective_start_date and pee.effective_end_date and ppa.date_earned between peev.effective_start_date and peev.effective_end_date and ppa.date_earned between pet.effective_start_date and pet.effective_end_date and ppa.date_earned between prt.effective_start_date and prt.effective_end_date

View Text - HTML Formatted

SELECT PAA.ASSIGNMENT_ACTION_ID
, PAA.ASSIGNMENT_ID
, PPA.EFFECTIVE_DATE
, PPA.DATE_EARNED
, PAA.RUN_TYPE_ID
, PET.ELEMENT_TYPE_ID
, PIV.INPUT_VALUE_ID INPUT_VALUE_ID
, PEE.ELEMENT_ENTRY_ID ELEMENT_ENTRY_ID
, PEEV.SCREEN_ENTRY_VALUE
, PIV.NAME INPUT_VALUE_NAME
FROM PAY_PAYROLL_ACTIONS PPA
, PAY_ASSIGNMENT_ACTIONS PAA
, PAY_ELEMENT_ENTRIES_F PEE
, PAY_ELEMENT_TYPES_F PET
, PAY_ELEMENT_ENTRY_VALUES_F PEEV
, PAY_INPUT_VALUES_F PIV
, PAY_RUN_TYPES_F PRT
WHERE PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID
AND PEE.ASSIGNMENT_ID = PAA.ASSIGNMENT_ID
AND PEE.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND PET.ELEMENT_NAME = 'PREV_ER_INFO'
AND PEE.ELEMENT_ENTRY_ID = PEEV.ELEMENT_ENTRY_ID
AND PET.LEGISLATION_CODE = 'KR'
AND PEEV.INPUT_VALUE_ID = PIV.INPUT_VALUE_ID
AND PRT.RUN_TYPE_ID = PAA.RUN_TYPE_ID
AND PIV.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND PRT.RUN_TYPE_NAME IN ('SEP'
, 'SEP_I')
AND PPA.DATE_EARNED BETWEEN PEE.EFFECTIVE_START_DATE
AND PEE.EFFECTIVE_END_DATE
AND PPA.DATE_EARNED BETWEEN PEEV.EFFECTIVE_START_DATE
AND PEEV.EFFECTIVE_END_DATE
AND PPA.DATE_EARNED BETWEEN PET.EFFECTIVE_START_DATE
AND PET.EFFECTIVE_END_DATE
AND PPA.DATE_EARNED BETWEEN PRT.EFFECTIVE_START_DATE
AND PRT.EFFECTIVE_END_DATE