View: PAY_KR_SEP_RESULT_TAX_PREV_V

Product:	PAY - Payroll
Description:	This view returns Result for Previous Employer of Separation Pay Tax based on assignment_action_id.
Implementation/DBA Data:	APPS.PAY_KR_SEP_RESULT_TAX_PREV_V

View Text

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

Columns