APPS.HR_ASSIGNMENT_INTERNAL dependencies on PER_SECONDARY_ASS_STATUSES

Line 632: from per_secondary_ass_statuses sas

628: for update nowait;
629: --
630: cursor csr_lock_sas is
631: select null
632: from per_secondary_ass_statuses sas
633: where sas.assignment_id = p_assignment_id
634: for update nowait;
635: --
636: cursor csr_lock_pyp is

Line 775: -- per_secondary_ass_statuses (not datetracked)

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

Line 781: update per_secondary_ass_statuses sas

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

Line 788: delete per_secondary_ass_statuses sas

784: and sas.end_date IS NULL;
785: --
786: hr_utility.set_location(l_proc, 140);
787: --
788: delete per_secondary_ass_statuses sas
789: where sas.assignment_id = p_assignment_id
790: and sas.start_date > p_final_process_date;
791: --
792: hr_utility.set_location(l_proc, 150);

Line 2384: from per_secondary_ass_statuses sas

2380: for update nowait;
2381: --
2382: cursor csr_lock_sas is
2383: select null
2384: from per_secondary_ass_statuses sas
2385: where sas.assignment_id = p_assignment_id
2386: for update nowait;
2387: --
2388: cursor csr_lock_pyp is

Line 2517: -- per_secondary_ass_statuses (not datetracked)

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

Line 2523: update per_secondary_ass_statuses sas

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

Line 2530: delete per_secondary_ass_statuses sas

2526: and sas.end_date IS NULL;
2527: --
2528: hr_utility.set_location(l_proc, 140);
2529: --
2530: delete per_secondary_ass_statuses sas
2531: where sas.assignment_id = p_assignment_id
2532: and sas.start_date > p_final_process_date;
2533: --
2534: hr_utility.set_location(l_proc, 150);