View: PAY_JP_SOE_RETRO_SASSACTS_V

Product:	PAY - Payroll
Description:	This view is used for Japanese localization only.
Implementation/DBA Data:	APPS.PAY_JP_SOE_RETRO_SASSACTS_V

View Text

SELECT PAA.ASSIGNMENT_ACTION_ID
, PAA2.ASSIGNMENT_ACTION_ID
, PAA2.ACTION_SEQUENCE
, PAA2.ACTION_STATUS
, SUBSTRB(HR_GENERAL.DECODE_LOOKUP('ACTION_STATUS'
, PPA2.ACTION_STATUS)
, 1
, 80)
, PPA2.ACTION_TYPE
, SUBSTRB(HR_GENERAL.DECODE_LOOKUP('ACTION_TYPE'
, PPA2.ACTION_TYPE)
, 1
, 80)
, PPA2.EFFECTIVE_DATE FROM PAY_ACTION_CLASSIFICATIONS PAC
, PAY_PAYROLL_ACTIONS PPA2
, /* SOURCE PACT */ PAY_ASSIGNMENT_ACTIONS PAA2
, /* SOURCE ASSACT */ PAY_PAYROLL_ACTIONS PPA
, /* RETRO PACT */ PAY_ASSIGNMENT_ACTIONS PAA /* RETRO ASSACT */ WHERE PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID AND PPA.ACTION_TYPE = 'G' AND PAA2.ASSIGNMENT_ID = PAA.ASSIGNMENT_ID AND PAA2.ACTION_SEQUENCE < PAA.ACTION_SEQUENCE AND PPA2.PAYROLL_ACTION_ID = PAA2.PAYROLL_ACTION_ID AND PPA2.EFFECTIVE_DATE BETWEEN PPA.START_DATE
AND PPA.EFFECTIVE_DATE AND PAC.CLASSIFICATION_NAME = 'BACKPAID' AND PAC.ACTION_TYPE = PPA2.ACTION_TYPE AND EXISTS( SELECT NULL FROM PAY_ELEMENT_ENTRIES_F PEE WHERE PEE.ASSIGNMENT_ID = PAA.ASSIGNMENT_ID AND PEE.ENTRY_TYPE = 'E' AND PPA.EFFECTIVE_DATE BETWEEN PEE.EFFECTIVE_START_DATE
AND PEE.EFFECTIVE_END_DATE AND PEE.CREATOR_ID = PAA.ASSIGNMENT_ACTION_ID AND PEE.CREATOR_TYPE = 'R' AND PEE.SOURCE_ID = PAA2.ASSIGNMENT_ACTION_ID)

Columns