APPS.HR_ASSIGNMENT_INTERNAL dependencies on PAY_PERSONAL_PAYMENT_METHODS_F

Line 620: from pay_personal_payment_methods_f ppm

616: for update nowait;
617: --
618: cursor csr_lock_ppm is
619: select null
620: from pay_personal_payment_methods_f ppm
621: where ppm.assignment_id = p_assignment_id
622: for update nowait;
623: --
624: cursor csr_lock_asa is

Line 645: from pay_personal_payment_methods_f

641: --
642: -- Start of fix for Bug 2796523
643: cursor csr_zap_ppm is
644: select personal_payment_method_id,object_version_number,effective_start_date
645: from pay_personal_payment_methods_f
646: where assignment_id = p_assignment_id
647: and effective_start_date > p_final_process_date;
648: -- End of fix for Bug 2796523
649: --

Line 652: from pay_personal_payment_methods_f

648: -- End of fix for Bug 2796523
649: --
650: cursor csr_dt_del_ppm is
651: select personal_payment_method_id,object_version_number
652: from pay_personal_payment_methods_f
653: where assignment_id = p_assignment_id
654: and p_final_process_date between effective_start_date
655: and effective_end_date;
656: --

Line 778: -- pay_personal_payment_methods_f

774: --
775: -- per_secondary_ass_statuses (not datetracked)
776: -- pay_cost_allocations_f
777: -- per_spinal_point_placements_f
778: -- pay_personal_payment_methods_f
779: -- per_assignment_budget_values_f
780: --
781: update per_secondary_ass_statuses sas
782: set sas.end_date = p_final_process_date

Line 2378: from pay_personal_payment_methods_f ppm

2374: for update nowait;
2375: --
2376: cursor csr_lock_ppm is
2377: select null
2378: from pay_personal_payment_methods_f ppm
2379: where ppm.assignment_id = p_assignment_id
2380: for update nowait;
2381: --
2382: cursor csr_lock_sas is

Line 2397: from pay_personal_payment_methods_f

2393: --
2394: -- Start of fix for Bug 2796523
2395: cursor csr_zap_ppm is
2396: select personal_payment_method_id,object_version_number,effective_start_date
2397: from pay_personal_payment_methods_f
2398: where assignment_id = p_assignment_id
2399: and effective_start_date > p_final_process_date;
2400: -- End of fix for Bug 2796523
2401: --

Line 2404: from pay_personal_payment_methods_f

2400: -- End of fix for Bug 2796523
2401: --
2402: cursor csr_dt_del_ppm is
2403: select personal_payment_method_id,object_version_number
2404: from pay_personal_payment_methods_f
2405: where assignment_id = p_assignment_id
2406: and p_final_process_date between effective_start_date
2407: and effective_end_date;
2408: cursor csr_lock_asa is

Line 2520: -- pay_personal_payment_methods_f

2516: --
2517: -- per_secondary_ass_statuses (not datetracked)
2518: -- pay_cost_allocations_f
2519: -- per_spinal_point_placements_f
2520: -- pay_personal_payment_methods_f
2521: -- per_assignment_budget_values_f
2522: --
2523: update per_secondary_ass_statuses sas
2524: set sas.end_date = p_final_process_date