View: PAY_KR_SEP_ARCHIVE_V

Product:	PAY - Payroll
Description:	This view returns Result Value of Separation Pay Archive Process based on assignment_action_id.
Implementation/DBA Data:	APPS.PAY_KR_SEP_ARCHIVE_V

View Text

SELECT XPAA.ASSIGNMENT_ACTION_ID ASSIGNMENT_ACTION_ID
, XPAA.ASSIGNMENT_ID ASSIGNMENT_ID
, XPPA.EFFECTIVE_DATE EFFECTIVE_DATE
, PAA.ASSIGNMENT_ACTION_ID SASSIGNMENT_ACTION_ID
, PPA.EFFECTIVE_DATE SEFFECTIVE_DATE
, PPA.DATE_EARNED SDATE_EARND
, PRT.RUN_TYPE_ID RUN_TYPE_ID
, FUE.USER_ENTITY_ID USER_ENTITY_ID
, FUE.ROUTE_ID ROUTE_ID
, FDI.USER_NAME USER_NAME
, FDI.DATA_TYPE DATA_TYPE
, HR_GENERAL.DECODE_LOOKUP('DATA_TYPE'
, FDI.DATA_TYPE) UDATA_TYPE
, FAI.ARCHIVE_ITEM_ID ARCHIVE_ITEM_ID
, FAI.VALUE VALUE
FROM FF_DATABASE_ITEMS FDI
, FF_USER_ENTITIES FUE
, FF_ARCHIVE_ITEMS FAI
, PAY_RUN_TYPES_F PRT
, PAY_PAYROLL_ACTIONS PPA
, PAY_ASSIGNMENT_ACTIONS PAA
, PAY_ACTION_INTERLOCKS PAI
, PAY_PAYROLL_ACTIONS XPPA
, PAY_ASSIGNMENT_ACTIONS XPAA
WHERE XPAA.ACTION_STATUS = 'C'
AND XPPA.PAYROLL_ACTION_ID = XPAA.PAYROLL_ACTION_ID
AND PAI.LOCKING_ACTION_ID = XPAA.ASSIGNMENT_ACTION_ID
AND PAA.ASSIGNMENT_ACTION_ID = PAI.LOCKED_ACTION_ID
AND PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID
AND PRT.RUN_TYPE_ID = PAA.RUN_TYPE_ID
AND PRT.RUN_TYPE_NAME LIKE 'SEP%'
AND PPA.EFFECTIVE_DATE BETWEEN PRT.EFFECTIVE_START_DATE
AND PRT.EFFECTIVE_END_DATE
AND FAI.CONTEXT1 = XPAA.ASSIGNMENT_ACTION_ID
AND FUE.USER_ENTITY_ID = FAI.USER_ENTITY_ID
AND FUE.LEGISLATION_CODE = PAY_KR_REPORT_PKG.LEGISLATION_CODE(PPA.BUSINESS_GROUP_ID)
AND FUE.CREATOR_TYPE = 'X'
AND FDI.USER_ENTITY_ID = FUE.USER_ENTITY_ID

Columns