APPS.PER_ASSIGNMENTS_F1_PKG dependencies on PER_SPINAL_POINT_PLACEMENTS_F

Line 830: from per_spinal_point_placements_f

826: -- then the effective date of the process
827: --
828: cursor csr_min_spp_date is
829: select min(effective_start_date)
830: from per_spinal_point_placements_f
831: where assignment_id = p_ass_id;
832: --
833: --
834: -- Start of 3335915

Line 842: from per_spinal_point_placements_f spp

838: /*
839: cursor csr_grade_step is
840: select spp.placement_id, spp.object_version_number ,step_id,
841: spp.effective_end_date,spp.effective_start_date
842: from per_spinal_point_placements_f spp
843: where spp.assignment_id = p_ass_id
844: and p_val_st_date between spp.effective_start_date
845: and spp.effective_end_date;
846:

Line 849: FROM per_spinal_point_placements_f spp

845: and spp.effective_end_date;
846:
847: CURSOR csr_spp_id IS
848: SELECT spp.placement_id , spp.object_version_number,spp.effective_start_date
849: FROM per_spinal_point_placements_f spp
850: WHERE assignment_id = p_ass_id
851: and p_sess_date between spp.effective_start_date
852: and spp.effective_end_date;
853:

Line 1175: from per_spinal_point_placements_f

1171: IF csr_grade_step%found then
1172: hr_utility.set_location('Record Found ',2);
1173: select max(effective_end_date)
1174: into l_max_spp_date
1175: from per_spinal_point_placements_f
1176: where placement_id = l_placement_id;
1177:
1178: hr_utility.set_location('PD: Max SPP End Dt '|| l_max_spp_date,2);
1179: hr_utility.set_location('PD: Current SPP end dt '||l_spp_end_date,2);

Line 1279: -- PER_SPINAL_POINT_PLACEMENTS_F

1275: --
1276: -- Date Effectively Delete any of the assignments' children
1277: -- records.
1278: -- The following tables are affected
1279: -- PER_SPINAL_POINT_PLACEMENTS_F
1280: -- Warn the user that any associated spinal point placement
1281: -- records will be deleted and prompt the user to continue.
1282: -- Then DE delete any such records.
1283: --