VIEW: APPS.PAY_CN_ARCH_ACTIONS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'