APPS.HR_ASSIGNMENT_INTERNAL dependencies on PAY_COST_ALLOCATIONS_F

Line 569: from pay_cost_allocations_f csa

565: --
566: --
567: cursor csr_lock_csa is
568: select null
569: from pay_cost_allocations_f csa
570: where csa.assignment_id = p_assignment_id
571: for update nowait;
572: --
573: cursor csr_lock_alu is

Line 776: -- pay_cost_allocations_f

772: -- of the final process date, and ZAP any rows which start after the final
773: -- process date:
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: --

Line 796: update pay_cost_allocations_f pca

792: hr_utility.set_location(l_proc, 150);
793: --
794: hr_utility.set_location(l_proc, 170);
795: --
796: update pay_cost_allocations_f pca
797: set pca.effective_end_date = p_final_process_date
798: where pca.assignment_id = p_assignment_id
799: and p_final_process_date between pca.effective_start_date
800: and pca.effective_end_date;

Line 804: delete pay_cost_allocations_f pca

800: and pca.effective_end_date;
801: --
802: hr_utility.set_location(l_proc, 180);
803: --
804: delete pay_cost_allocations_f pca
805: where pca.assignment_id = p_assignment_id
806: and pca.effective_start_date > p_final_process_date;
807: --
808: hr_utility.set_location(l_proc, 190);

Line 2326: from pay_cost_allocations_f csa

2322: --
2323: --
2324: cursor csr_lock_csa is
2325: select null
2326: from pay_cost_allocations_f csa
2327: where csa.assignment_id = p_assignment_id
2328: for update nowait;
2329: --
2330: cursor csr_lock_alu is

Line 2518: -- pay_cost_allocations_f

2514: -- of the final process date, and ZAP any rows which start after the final
2515: -- process date:
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: --

Line 2538: update pay_cost_allocations_f pca

2534: hr_utility.set_location(l_proc, 150);
2535: --
2536: hr_utility.set_location(l_proc, 170);
2537: --
2538: update pay_cost_allocations_f pca
2539: set pca.effective_end_date = p_final_process_date
2540: where pca.assignment_id = p_assignment_id
2541: and p_final_process_date between pca.effective_start_date
2542: and pca.effective_end_date;

Line 2546: delete pay_cost_allocations_f pca

2542: and pca.effective_end_date;
2543: --
2544: hr_utility.set_location(l_proc, 180);
2545: --
2546: delete pay_cost_allocations_f pca
2547: where pca.assignment_id = p_assignment_id
2548: and pca.effective_start_date > p_final_process_date;
2549: --
2550: hr_utility.set_location(l_proc, 190);