[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;
2541: hr_utility.set_location('issues in creating control rec ',10);
2542: raise;
2543: end create_gsp_control_rec;
2544: function get_bg_grd_pay_rate(p_business_group_id in number) return number is
2545: l_pay_rate_name pay_rates.name%type;
2546: l_pay_rate_id number;
2547: begin
2548: -- for a grade there can be many pay rates, we have to find that pay rate which is
2549: -- having name based on lookup code
2544: function get_bg_grd_pay_rate(p_business_group_id in number) return number is
2545: l_pay_rate_name pay_rates.name%type;
2546: l_pay_rate_id number;
2547: begin
2548: -- for a grade there can be many pay rates, we have to find that pay rate which is
2549: -- having name based on lookup code
2550: l_pay_rate_name := hr_general.decode_lookup(p_lookup_type => 'PQH_GSP_GEN_NAME',
2551: p_lookup_code => 'GRADE_RATEGSP');
2552: if l_pay_rate_name is not null then
2555: -- if the pay rate doesn't exist with this name, no value will be set.
2556: begin
2557: select rate_id
2558: into l_pay_rate_id
2559: from pay_rates
2560: where name = l_pay_rate_name
2561: and rate_type ='G'
2562: and business_group_id = p_business_group_id;
2563: hr_utility.set_location('rate is '||l_pay_rate_id,20);