[Home] [Help]
View: PAY_JP_SOE_ADV_RET_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
, PAY_ASSIGNMENT_ACTIONS PAA2
, PAY_PAYROLL_ACTIONS PPA
, PAY_ASSIGNMENT_ACTIONS PAA
WHERE PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID
AND PPA.ACTION_TYPE = 'L'
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 <= 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 = 'RR' OR PEE.CREATOR_TYPE = 'EE' )
AND PEE.SOURCE_ASG_ACTION_ID = PAA2.ASSIGNMENT_ACTION_ID )
Columns
Name |
CREATOR_ACTION_ID |
ASSIGNMENT_ACTION_ID |
ACTION_SEQUENCE |
ACTION_STATUS |
D_ACTION_STATUS |
ACTION_TYPE |
D_ACTION_TYPE |
EFFECTIVE_DATE |