APPS.HR_ASSIGNMENT_INTERNAL dependencies on PAY_COST_ALLOCATIONS_F

Line 534: from pay_cost_allocations_f csa

530: --
531: --
532: cursor csr_lock_csa is
533: select null
534: from pay_cost_allocations_f csa
535: where csa.assignment_id = p_assignment_id
536: for update nowait;
537: --
538: cursor csr_lock_alu is

Line 710: -- pay_cost_allocations_f

706: -- of the final process date, and ZAP any rows which start after the final
707: -- process date:
708: --
709: -- per_secondary_ass_statuses (not datetracked)
710: -- pay_cost_allocations_f
711: -- per_spinal_point_placements_f
712: -- pay_personal_payment_methods_f
713: -- per_assignment_budget_values_f
714: --

Line 730: update pay_cost_allocations_f pca

726: hr_utility.set_location(l_proc, 150);
727: --
728: hr_utility.set_location(l_proc, 170);
729: --
730: update pay_cost_allocations_f pca
731: set pca.effective_end_date = p_final_process_date
732: where pca.assignment_id = p_assignment_id
733: and p_final_process_date between pca.effective_start_date
734: and pca.effective_end_date;

Line 738: delete pay_cost_allocations_f pca

734: and pca.effective_end_date;
735: --
736: hr_utility.set_location(l_proc, 180);
737: --
738: delete pay_cost_allocations_f pca
739: where pca.assignment_id = p_assignment_id
740: and pca.effective_start_date > p_final_process_date;
741: --
742: hr_utility.set_location(l_proc, 190);

Line 2224: from pay_cost_allocations_f csa

2220: --
2221: --
2222: cursor csr_lock_csa is
2223: select null
2224: from pay_cost_allocations_f csa
2225: where csa.assignment_id = p_assignment_id
2226: for update nowait;
2227: --
2228: cursor csr_lock_alu is

Line 2385: -- pay_cost_allocations_f

2381: -- of the final process date, and ZAP any rows which start after the final
2382: -- process date:
2383: --
2384: -- per_secondary_ass_statuses (not datetracked)
2385: -- pay_cost_allocations_f
2386: -- per_spinal_point_placements_f
2387: -- pay_personal_payment_methods_f
2388: -- per_assignment_budget_values_f
2389: --

Line 2405: update pay_cost_allocations_f pca

2401: hr_utility.set_location(l_proc, 150);
2402: --
2403: hr_utility.set_location(l_proc, 170);
2404: --
2405: update pay_cost_allocations_f pca
2406: set pca.effective_end_date = p_final_process_date
2407: where pca.assignment_id = p_assignment_id
2408: and p_final_process_date between pca.effective_start_date
2409: and pca.effective_end_date;

Line 2413: delete pay_cost_allocations_f pca

2409: and pca.effective_end_date;
2410: --
2411: hr_utility.set_location(l_proc, 180);
2412: --
2413: delete pay_cost_allocations_f pca
2414: where pca.assignment_id = p_assignment_id
2415: and pca.effective_start_date > p_final_process_date;
2416: --
2417: hr_utility.set_location(l_proc, 190);