APPS.HR_ASSIGNMENT_INTERNAL dependencies on PER_SECONDARY_ASS_STATUSES

Line 578: from per_secondary_ass_statuses sas

574: for update nowait;
575: --
576: cursor csr_lock_sas is
577: select null
578: from per_secondary_ass_statuses sas
579: where sas.assignment_id = p_assignment_id
580: for update nowait;
581: --
582: cursor csr_lock_pyp is

Line 709: -- per_secondary_ass_statuses (not datetracked)

705: -- For the following tables, date effectively delete any rows which exist as
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

Line 715: update per_secondary_ass_statuses sas

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
718: and sas.end_date IS NULL;
719: --

Line 722: delete per_secondary_ass_statuses sas

718: and sas.end_date IS NULL;
719: --
720: hr_utility.set_location(l_proc, 140);
721: --
722: delete per_secondary_ass_statuses sas
723: where sas.assignment_id = p_assignment_id
724: and sas.start_date > p_final_process_date;
725: --
726: hr_utility.set_location(l_proc, 150);

Line 2262: from per_secondary_ass_statuses sas

2258: for update nowait;
2259: --
2260: cursor csr_lock_sas is
2261: select null
2262: from per_secondary_ass_statuses sas
2263: where sas.assignment_id = p_assignment_id
2264: for update nowait;
2265: --
2266: cursor csr_lock_pyp is

Line 2384: -- per_secondary_ass_statuses (not datetracked)

2380: -- For the following tables, date effectively delete any rows which exist as
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

Line 2390: update per_secondary_ass_statuses sas

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
2393: and sas.end_date IS NULL;
2394: --

Line 2397: delete per_secondary_ass_statuses sas

2393: and sas.end_date IS NULL;
2394: --
2395: hr_utility.set_location(l_proc, 140);
2396: --
2397: delete per_secondary_ass_statuses sas
2398: where sas.assignment_id = p_assignment_id
2399: and sas.start_date > p_final_process_date;
2400: --
2401: hr_utility.set_location(l_proc, 150);