APPS.PAY_MAG_UTILS dependencies on PAY_ASSIGNMENT_ACTIONS

Line 498: UPDATE pay_assignment_actions aa

494: -- Sets all successfully processed assignment actions to 'C'omplete.
495: --
496: hr_utility.set_location('pay_mag_utils.update_action_status',2);
497: --
498: UPDATE pay_assignment_actions aa
499: SET aa.action_status = 'C'
500: WHERE aa.payroll_action_id = p_payroll_action_id
501: AND aa.action_status = 'U';
502: --

Line 616: FROM pay_assignment_actions aa

612: -- tax_unit_id updated yet.
613: --
614: CURSOR csr_assignment_action IS
615: SELECT aa.assignment_action_id
616: FROM pay_assignment_actions aa
617: WHERE aa.payroll_action_id = p_payroll_action_id
618: AND aa.assignment_id = p_assignment_id
619: AND aa.tax_unit_id IS NULL;
620: --

Line 623: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;

619: AND aa.tax_unit_id IS NULL;
620: --
621: -- Local variables.
622: --
623: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
624: --
625: BEGIN
626: --
627: hr_utility.set_location('pay_mag_utils.create_assignment_action',1);

Line 645: UPDATE pay_assignment_actions aa

641: OPEN csr_assignment_action;
642: FETCH csr_assignment_action INTO l_assignment_action_id;
643: CLOSE csr_assignment_action;
644: --
645: UPDATE pay_assignment_actions aa
646: SET aa.tax_unit_id = p_tax_unit_id
647: WHERE aa.assignment_action_id = l_assignment_action_id;
648: --
649: hr_utility.set_location('pay_mag_utils.create_assignment_action',3);