APPS.PAY_ACTION_CONTEXTS_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 108: SELECT pay_assignment_actions_s.nextval

104: begin
105: hr_utility.trace('> action_creation()');
106:
107: for rec_asg_act in csr_asg_acts(p_pay_act_id, p_stperson, p_endperson) loop
108: SELECT pay_assignment_actions_s.nextval
109: INTO l_locking_asg_act_id
110: FROM DUAL;
111:
112: --

Line 350: PAY_ASSIGNMENT_ACTIONS aat,

346: aat.assignment_id,
347: aat.assignment_action_id,
348: aat.tax_unit_id
349: FROM PAY_PAYROLL_ACTIONS pa,
350: PAY_ASSIGNMENT_ACTIONS aat,
351: PAY_ASSIGNMENT_ACTIONS aam
352: WHERE aam.assignment_action_id = b_asg_act_id
353: and aat.assignment_id = aam.assignment_id
354: and pa.payroll_action_id = aat.payroll_action_id

Line 351: PAY_ASSIGNMENT_ACTIONS aam

347: aat.assignment_action_id,
348: aat.tax_unit_id
349: FROM PAY_PAYROLL_ACTIONS pa,
350: PAY_ASSIGNMENT_ACTIONS aat,
351: PAY_ASSIGNMENT_ACTIONS aam
352: WHERE aam.assignment_action_id = b_asg_act_id
353: and aat.assignment_id = aam.assignment_id
354: and pa.payroll_action_id = aat.payroll_action_id
355: and pa.action_type in ('R', 'Q', 'B', 'V', 'I')