APPS.HR_ASSIGNMENT_INTERNAL dependencies on PER_ASSIGNMENT_BUDGET_VALUES_F

Line 605: from per_assignment_budget_values_f

601: and effective_end_date;
602: --
603: cursor csr_lock_abv is
604: select assignment_budget_value_id
605: from per_assignment_budget_values_f
606: where assignment_id = p_assignment_id
607: and p_final_process_date between effective_start_date
608: and effective_end_date;
609: --

Line 713: -- per_assignment_budget_values_f

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: --
715: update per_secondary_ass_statuses sas
716: set sas.end_date = p_final_process_date
717: where sas.assignment_id = p_assignment_id

Line 761: update per_assignment_budget_values_f abv

757:
758: --
759: -- SASmith date track of abv. 16-APR-1998
760:
761: update per_assignment_budget_values_f abv
762: set abv.effective_end_date = p_final_process_date
763: where abv.assignment_id = p_assignment_id
764: and p_final_process_date between abv.effective_start_date
765: and abv.effective_end_date;

Line 769: delete per_assignment_budget_values_f abv

765: and abv.effective_end_date;
766: --
767: hr_utility.set_location(l_proc, 212);
768: --
769: delete per_assignment_budget_values_f abv
770: where abv.assignment_id = p_assignment_id
771: and abv.effective_start_date > p_final_process_date;
772: --
773: hr_utility.set_location(l_proc, 214);

Line 2295: from per_assignment_budget_values_f

2291: --
2292: --
2293: cursor csr_lock_abv is
2294: select assignment_budget_value_id
2295: from per_assignment_budget_values_f
2296: where assignment_id = p_assignment_id
2297: and p_final_process_date between effective_start_date
2298: and effective_end_date;
2299:

Line 2388: -- per_assignment_budget_values_f

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: --
2390: update per_secondary_ass_statuses sas
2391: set sas.end_date = p_final_process_date
2392: where sas.assignment_id = p_assignment_id

Line 2436: update per_assignment_budget_values_f abv

2432:
2433: --
2434: -- SASmith date track of abv. 16-APR-1998
2435:
2436: update per_assignment_budget_values_f abv
2437: set abv.effective_end_date = p_final_process_date
2438: where abv.assignment_id = p_assignment_id
2439: and p_final_process_date between abv.effective_start_date
2440: and abv.effective_end_date;

Line 2444: delete per_assignment_budget_values_f abv

2440: and abv.effective_end_date;
2441: --
2442: hr_utility.set_location(l_proc, 212);
2443: --
2444: delete per_assignment_budget_values_f abv
2445: where abv.assignment_id = p_assignment_id
2446: and abv.effective_start_date > p_final_process_date;
2447: --
2448: hr_utility.set_location(l_proc, 214);