View: PAY_CN_ARCH_ACTIONS_V

Product:	PAY - Payroll
Description:
Implementation/DBA Data:	APPS.PAY_CN_ARCH_ACTIONS_V

View Text

SELECT X_PACT.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, X_PACT.EFFECTIVE_DATE EFFECTIVE_DATE
, P_PACT.PAYROLL_ID PAYROLL_ID
, P_PACT.CONSOLIDATION_SET_ID CONSOLIDATION_SET_ID
, X_PACT.PAYROLL_ACTION_ID PAYROLL_ACTION_ID
, X_ACT.ASSIGNMENT_ACTION_ID ASSIGNMENT_ACTION_ID
, P_ACT.ASSIGNMENT_ACTION_ID PREPAYMENT_ACTION_ID
FROM PAY_PAYROLL_ACTIONS P_PACT
, PAY_ASSIGNMENT_ACTIONS P_ACT
, PAY_ACTION_INTERLOCKS LCK
, PAY_ASSIGNMENT_ACTIONS X_ACT
, PAY_PAYROLL_ACTIONS X_PACT
WHERE X_PACT.ACTION_TYPE = 'X'
AND X_PACT.ACTION_STATUS = 'C'
AND X_PACT.PAYROLL_ACTION_ID = X_ACT.PAYROLL_ACTION_ID
AND NVL(X_ACT.SOURCE_ACTION_ID
, X_ACT.ASSIGNMENT_ACTION_ID) = LCK.LOCKING_ACTION_ID
AND LCK.LOCKED_ACTION_ID = P_ACT.ASSIGNMENT_ACTION_ID
AND P_ACT.PAYROLL_ACTION_ID = P_PACT.PAYROLL_ACTION_ID
AND P_PACT.ACTION_TYPE IN ('P'
, 'U')
AND P_PACT.ACTION_STATUS = 'C'

Columns