APPS.PER_ASSIGNMENTS_F1_PKG dependencies on PER_SPINAL_POINT_PLACEMENTS_F

Line 902: from per_spinal_point_placements_f

898: -- then the effective date of the process
899: --
900: cursor csr_min_spp_date is
901: select min(effective_start_date)
902: from per_spinal_point_placements_f
903: where assignment_id = p_ass_id;
904: --
905: --
906: -- Start of 3335915

Line 914: from per_spinal_point_placements_f spp

910: /*
911: cursor csr_grade_step is
912: select spp.placement_id, spp.object_version_number ,step_id,
913: spp.effective_end_date,spp.effective_start_date
914: from per_spinal_point_placements_f spp
915: where spp.assignment_id = p_ass_id
916: and p_val_st_date between spp.effective_start_date
917: and spp.effective_end_date;
918:

Line 921: FROM per_spinal_point_placements_f spp

917: and spp.effective_end_date;
918:
919: CURSOR csr_spp_id IS
920: SELECT spp.placement_id , spp.object_version_number,spp.effective_start_date
921: FROM per_spinal_point_placements_f spp
922: WHERE assignment_id = p_ass_id
923: and p_sess_date between spp.effective_start_date
924: and spp.effective_end_date;
925:

Line 1254: from per_spinal_point_placements_f

1250: IF csr_grade_step%found then
1251: hr_utility.set_location('Record Found ',2);
1252: select max(effective_end_date)
1253: into l_max_spp_date
1254: from per_spinal_point_placements_f
1255: where placement_id = l_placement_id;
1256:
1257: hr_utility.set_location('PD: Max SPP End Dt '|| l_max_spp_date,2);
1258: hr_utility.set_location('PD: Current SPP end dt '||l_spp_end_date,2);

Line 1358: -- PER_SPINAL_POINT_PLACEMENTS_F

1354: --
1355: -- Date Effectively Delete any of the assignments' children
1356: -- records.
1357: -- The following tables are affected
1358: -- PER_SPINAL_POINT_PLACEMENTS_F
1359: -- Warn the user that any associated spinal point placement
1360: -- records will be deleted and prompt the user to continue.
1361: -- Then DE delete any such records.
1362: --