APPS.HR_ASSIGNMENT_API dependencies on PER_SPINAL_POINT_STEPS_F

Line 15854: l_step_id per_spinal_point_steps_f.step_id%TYPE;

15850: l_element_entry_id number;
15851: l_organization_id per_all_assignments_f.organization_id%type;
15852: l_location_id per_all_assignments_f.location_id%type;
15853: l_session_id number;
15854: l_step_id per_spinal_point_steps_f.step_id%TYPE;
15855:
15856: -- Start of Fix for Bug 2622747
15857: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE := p_soft_coding_keyflex_id;
15858: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;

Line 16031: from per_spinal_point_steps_f sps,

16027: );
16028: --
16029: cursor csr_chk_grade_and_ceiling is
16030: select sps.step_id
16031: from per_spinal_point_steps_f sps,
16032: per_grade_spines_f pgs
16033: where pgs.grade_id = p_grade_id
16034: and pgs.grade_spine_id = sps.grade_spine_id
16035: and sps.step_id = p_special_ceiling_step_id;