[Home] [Help]
2017: hr_utility.set_location('grade id is '||p_grade_id,1);
2018: hr_utility.set_location('scale id is '||p_scale_id,2);
2019: select ceiling_step_id,grade_spine_id,starting_step
2020: into p_ceiling_step_id,p_grade_spine_id,p_starting_step
2021: from per_grade_spines_f
2022: where grade_id = p_grade_id
2023: and parent_spine_id = p_scale_id
2024: and p_effective_date between effective_start_date and effective_end_date;
2025: hr_utility.set_location('grade scale id is '||p_grade_spine_id,10);
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;
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
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;
3209: p_business_area in varchar2 default 'PQH_GSP_TASK_LIST',
3210: p_business_group_id in number) is
3211: cursor csr_grd_scales is
3212: select gs.parent_spine_id scale_id,gs.grade_id grade_id
3213: from ben_copy_entity_results cer, per_grade_spines_f gs
3214: where copy_entity_txn_id = p_copy_entity_txn_id
3215: and cer.information294 = gs.grade_id
3216: and table_alias = 'PLN'
3217: and p_effective_date between gs.effective_start_date and gs.effective_end_date
3611: hr_utility.set_location('effdt is '||to_char(p_effective_date,'DD-MM-RRRR'),12);
3612: select psp.parent_spine_id,psp.name,gsp.ceiling_step_id,gsp.grade_spine_id,
3613: gsp.object_version_number,psp.object_version_number,gsp.starting_step
3614: into p_scale_id,p_scale_name, p_ceiling_step_id,p_grade_spine_id,p_grade_spine_ovn,p_scale_ovn,p_starting_step
3615: from per_grade_spines_f gsp, per_parent_spines psp
3616: where gsp.grade_id = p_grade_id
3617: and psp.parent_spine_id = gsp.parent_spine_id
3618: and p_effective_date between gsp.effective_start_date and gsp.effective_end_date;
3619: hr_utility.set_location('scale name is '||p_scale_name,40);
4910: p_plip_cer_id out nocopy number,
4911: p_scale_cer_id out nocopy number) is
4912: cursor csr_grd_scale is
4913: select parent_spine_id
4914: from per_grade_spines_f
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
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;