APPS.HR_PERIODS_OF_SERVICE_API dependencies on PAY_PERSONAL_PAYMENT_METHODS_F

Line 888: FROM pay_personal_payment_methods_f ppm

884: FOR UPDATE NOWAIT;
885: --
886: CURSOR csr_lock_ppm (p_assignment_id NUMBER) IS
887: SELECT NULL
888: FROM pay_personal_payment_methods_f ppm
889: WHERE ppm.assignment_id = csr_lock_ppm.p_assignment_id
890: FOR UPDATE NOWAIT;
891: --
892: CURSOR csr_lock_sas (p_assignment_id NUMBER) IS

Line 1445: UPDATE pay_personal_payment_methods_f ppm

1441: -- 115.15 (END)
1442: --
1443: per_saladmin_utility.adjust_pay_proposals(l_assignment_id); -- Bug 13936772
1444: --
1445: UPDATE pay_personal_payment_methods_f ppm
1446: SET effective_end_date = l_new_final_process_date
1447: WHERE assignment_id = l_assignment_id
1448: AND p_old_final_process_date BETWEEN effective_start_date
1449: AND effective_end_date;