APPS.HR_ASSIGNMENT_INTERNAL dependencies on PER_ASSIGNMENT_BUDGET_VALUES_F

Line 659: from per_assignment_budget_values_f

655: and effective_end_date;
656: --
657: cursor csr_lock_abv is
658: select assignment_budget_value_id
659: from per_assignment_budget_values_f
660: where assignment_id = p_assignment_id
661: and p_final_process_date between effective_start_date
662: and effective_end_date;
663: --

Line 779: -- per_assignment_budget_values_f

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
783: where sas.assignment_id = p_assignment_id

Line 827: update per_assignment_budget_values_f abv

823:
824: --
825: -- SASmith date track of abv. 16-APR-1998
826:
827: update per_assignment_budget_values_f abv
828: set abv.effective_end_date = p_final_process_date
829: where abv.assignment_id = p_assignment_id
830: and p_final_process_date between abv.effective_start_date
831: and abv.effective_end_date;

Line 835: delete per_assignment_budget_values_f abv

831: and abv.effective_end_date;
832: --
833: hr_utility.set_location(l_proc, 212);
834: --
835: delete per_assignment_budget_values_f abv
836: where abv.assignment_id = p_assignment_id
837: and abv.effective_start_date > p_final_process_date;
838: --
839: hr_utility.set_location(l_proc, 214);

Line 2417: from per_assignment_budget_values_f

2413: --
2414: --
2415: cursor csr_lock_abv is
2416: select assignment_budget_value_id
2417: from per_assignment_budget_values_f
2418: where assignment_id = p_assignment_id
2419: and p_final_process_date between effective_start_date
2420: and effective_end_date;
2421:

Line 2521: -- per_assignment_budget_values_f

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
2525: where sas.assignment_id = p_assignment_id

Line 2569: update per_assignment_budget_values_f abv

2565:
2566: --
2567: -- SASmith date track of abv. 16-APR-1998
2568:
2569: update per_assignment_budget_values_f abv
2570: set abv.effective_end_date = p_final_process_date
2571: where abv.assignment_id = p_assignment_id
2572: and p_final_process_date between abv.effective_start_date
2573: and abv.effective_end_date;

Line 2577: delete per_assignment_budget_values_f abv

2573: and abv.effective_end_date;
2574: --
2575: hr_utility.set_location(l_proc, 212);
2576: --
2577: delete per_assignment_budget_values_f abv
2578: where abv.assignment_id = p_assignment_id
2579: and abv.effective_start_date > p_final_process_date;
2580: --
2581: hr_utility.set_location(l_proc, 214);