DBA Data[Home] [Help]

APPS.PQH_CORPS_UTILITY dependencies on PER_SPINAL_POINT_PLACEMENTS_F

Line 684: from per_spinal_point_placements_f spp

680: and assignment_id = p_assignment_id;
681:
682: Cursor csr_step_date is
683: Select min(spp.effective_start_date)
684: from per_spinal_point_placements_f spp
685: where assignment_id =p_assignment_id
686: and step_id = p_career_level_id;
687:
688: --

Line 724: FROM per_spinal_point_placements_f spp,

720: IS
721: CURSOR csr_gross_index
722: IS
723: SELECT psp.information1
724: FROM per_spinal_point_placements_f spp,
725: per_spinal_point_steps_f sps,
726: per_spinal_points psp
727: WHERE spp.step_id = p_step_id
728: AND p_effective_date BETWEEN spp.effective_start_date