[Home] [Help]
1943: hr_utility.set_location('scale id is '||p_scale_id,10);
1944: -- if the pay rate doesn't exist with this name, no value will be set.
1945: select rate.rate_id
1946: into l_pay_rate_id
1947: from pay_rates rate, per_parent_spines scale
1948: where rate.name = scale.name
1949: and rate.rate_type ='SP'
1950: and rate.parent_spine_id = p_scale_id
1951: and scale.parent_spine_id = p_scale_id;
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);
3654: l_grd_ovn number;
3655:
3656: l_scale_id number;
3657: l_scale_ovn number;
3658: l_scale_name per_parent_spines.name%type;
3659: l_ceiling_step_id number;
3660: l_grd_value number;
3661: l_grd_min number;
3662: l_grd_mid number;
4188: -- this routine will be getting called when the scale is selected for update or for attaching.
4189: -- Data will be written into ben_copy_entity_results row provided for this purpose
4190: --
4191: l_proc varchar2(61) :='Scale_to_stage';
4192: l_scale_name per_parent_spines.name%type;
4193: l_scale_ovn number;
4194: l_increment_frequency per_parent_spines.increment_frequency%type;
4195: l_bg number;
4196: l_increment_period per_parent_spines.increment_period%type;
4190: --
4191: l_proc varchar2(61) :='Scale_to_stage';
4192: l_scale_name per_parent_spines.name%type;
4193: l_scale_ovn number;
4194: l_increment_frequency per_parent_spines.increment_frequency%type;
4195: l_bg number;
4196: l_increment_period per_parent_spines.increment_period%type;
4197: l_scl_tr_id number;
4198: l_scl_tr_name ben_copy_entity_results.table_name%type;
4192: l_scale_name per_parent_spines.name%type;
4193: l_scale_ovn number;
4194: l_increment_frequency per_parent_spines.increment_frequency%type;
4195: l_bg number;
4196: l_increment_period per_parent_spines.increment_period%type;
4197: l_scl_tr_id number;
4198: l_scl_tr_name ben_copy_entity_results.table_name%type;
4199: l_scl_cer_ovn number;
4200: l_information_category varchar2(30);
4206: begin
4207: -- get the scale info in local variables
4208: select name, increment_frequency,business_group_id, increment_period,object_version_number
4209: into l_scale_name,l_increment_frequency,l_bg,l_increment_period,l_scale_ovn
4210: from per_parent_spines
4211: where parent_spine_id = p_scale_id
4212: and business_group_id = p_business_group_id;
4213: hr_utility.set_location('scale name'||l_scale_name,20);
4214: exception