APPS.PQH_GSP_HR_TO_STAGE dependencies on PER_SPINAL_POINT_STEPS_F

Line 1981: from per_spinal_point_steps_f

1977: hr_utility.set_location('grade scale id is '||p_grade_spine_id,1);
1978: hr_utility.set_location('point id is '||p_point_id,2);
1979: select step_id,sequence,object_version_number
1980: into p_step_id, p_step_name,p_step_ovn
1981: from per_spinal_point_steps_f
1982: where grade_spine_id = p_grade_spine_id
1983: and spinal_point_id = p_point_id
1984: and p_effective_date between effective_start_date and effective_end_date;
1985: exception

Line 2092: from per_spinal_point_steps_f

2088: l_spinal_point_id number;
2089: begin
2090: select spinal_point_id
2091: into l_spinal_point_id
2092: from per_spinal_point_steps_f
2093: where step_id = p_step_id
2094: and p_effective_date between effective_start_date and effective_end_date;
2095: hr_utility.set_location('spinal point id is'||l_spinal_point_id,10);
2096: return l_spinal_point_id;

Line 2218: from per_spinal_point_steps_f sps, per_grade_spines_f gs

2214: begin
2215: -- for a grade there can be only one spine
2216: select gs.grade_id,sps.spinal_point_id
2217: into l_grade_id, l_point_id
2218: from per_spinal_point_steps_f sps, per_grade_spines_f gs
2219: where sps.grade_spine_id = gs.grade_spine_id
2220: and p_effective_date between sps.effective_start_date and sps.effective_end_date
2221: and p_effective_date between gs.effective_start_date and gs.effective_end_date
2222: and sps.step_id = p_step_id;

Line 2298: from per_spinal_point_steps_f sps, per_grade_spines_f gs

2294: begin
2295: -- for a grade there can be only one spine
2296: select step_id
2297: into l_step_id
2298: from per_spinal_point_steps_f sps, per_grade_spines_f gs
2299: where sps.grade_spine_id = gs.grade_spine_id
2300: and p_effective_date between sps.effective_start_date and sps.effective_end_date
2301: and p_effective_date between gs.effective_start_date and gs.effective_end_date
2302: and gs.grade_id = l_grade_id

Line 2947: from per_spinal_point_steps_f sps, per_grade_spines_f gs

2943: hr_utility.set_location('step_id is '||p_step_id,10);
2944: begin
2945: select sps.spinal_point_id,gs.grade_id, gs.grade_spine_id
2946: into p_point_id,p_grade_id,p_grade_spine_id
2947: from per_spinal_point_steps_f sps, per_grade_spines_f gs
2948: where sps.step_id = p_step_id
2949: and sps.grade_spine_id = gs.grade_spine_id
2950: and p_effective_date between sps.effective_start_date and sps.effective_end_date
2951: and p_effective_date between gs.effective_start_date and gs.effective_end_date;

Line 4919: from per_spinal_point_steps_f sps, per_grade_spines_f gs

4915: where p_effective_date between effective_start_date and effective_end_date
4916: and grade_id = p_grade_id;
4917: cursor csr_grd_steps is
4918: select sps.step_id,sps.spinal_point_id,sps.object_version_number,gs.grade_spine_id
4919: from per_spinal_point_steps_f sps, per_grade_spines_f gs
4920: where p_effective_date between sps.effective_start_date and sps.effective_end_date
4921: and gs.grade_spine_id = sps.grade_spine_id
4922: and p_effective_date between gs.effective_start_date and gs.effective_end_date
4923: and gs.grade_id = p_grade_id;