DBA Data[Home] [Help]

APPS.HR_ASSIGNMENT_API dependencies on PER_SPINAL_POINT_STEPS_F

Line 15252: l_step_id per_spinal_point_steps_f.step_id%TYPE;

15248: l_element_entry_id number;
15249: l_organization_id per_all_assignments_f.organization_id%type;
15250: l_location_id per_all_assignments_f.location_id%type;
15251: l_session_id number;
15252: l_step_id per_spinal_point_steps_f.step_id%TYPE;
15253:
15254: -- Start of Fix for Bug 2622747
15255: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE := p_soft_coding_keyflex_id;
15256: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;

Line 15428: from per_spinal_point_steps_f sps,

15424: );
15425: --
15426: cursor csr_chk_grade_and_ceiling is
15427: select sps.step_id
15428: from per_spinal_point_steps_f sps,
15429: per_grade_spines_f pgs
15430: where pgs.grade_id = p_grade_id
15431: and pgs.grade_spine_id = sps.grade_spine_id
15432: and sps.step_id = p_special_ceiling_step_id;