APPS.HR_PERIODS_OF_SERVICE_API dependencies on PAY_ASSIGNMENT_ACTIONS

Line 778: ,pay_assignment_actions paa

774: --
775: CURSOR csr_compl_pay_act IS
776: SELECT NULL
777: FROM pay_payroll_actions ppa
778: ,pay_assignment_actions paa
779: ,per_assignments_f asg
780: ,per_periods_of_service pds
781: WHERE pds.period_of_service_id = p_period_of_service_id
782: AND pds.person_id = asg.person_id

Line 896: FROM pay_assignment_actions asa

892: FOR UPDATE NOWAIT;
893: --
894: CURSOR csr_lock_asa (p_assignment_id NUMBER) IS
895: SELECT asa.assignment_action_id
896: FROM pay_assignment_actions asa
897: WHERE asa.assignment_id = csr_lock_asa.p_assignment_id
898: FOR UPDATE NOWAIT;
899: --
900: CURSOR csr_lock_abv (p_assignment_id NUMBER) IS

Line 1098: UPDATE pay_assignment_actions

1094: WHERE assignment_id = l_assignment_id
1095: AND p_old_final_process_date BETWEEN effective_start_date
1096: AND effective_end_date;
1097: --
1098: UPDATE pay_assignment_actions
1099: SET end_date = l_new_final_process_date
1100: WHERE assignment_id = l_assignment_id
1101: AND p_old_final_process_date BETWEEN start_date
1102: AND end_date;