APPS.PQH_GSP_HR_TO_STAGE dependencies on BEN_ACTY_BASE_RT_F

Line 1892: from ben_acty_base_rt_f

1888: elsif p_plan_id is not null and p_opt_id is null then
1889: begin
1890: select acty_base_rt_id,pay_rate_grade_rule_id
1891: into l_abr_id,p_pay_rule_id
1892: from ben_acty_base_rt_f
1893: where p_effective_date between effective_start_date and effective_end_date
1894: and pl_id = p_plan_id
1895: and acty_typ_cd ='GSPSA'; -- we are interested only in this type
1896: exception

Line 1917: from ben_acty_base_rt_f

1913: elsif p_plan_id is null and p_opt_id is not null then
1914: begin
1915: select acty_base_rt_id,pay_rate_grade_rule_id
1916: into l_abr_id,p_pay_rule_id
1917: from ben_acty_base_rt_f
1918: where p_effective_date between effective_start_date and effective_end_date
1919: and opt_id = p_opt_id
1920: and acty_typ_cd ='GSPSA'; -- we are interested only in this type
1921: exception

Line 2989: from ben_acty_base_rt_f

2985: p_pay_rule_id out nocopy number) is
2986: begin
2987: select pl_id, opt_id, pay_rate_grade_rule_id
2988: into p_plan_id, p_option_id,p_pay_rule_id
2989: from ben_acty_base_rt_f
2990: where acty_base_rt_id = p_abr_id
2991: and p_effective_date between effective_start_date and effective_end_date;
2992: hr_utility.set_location('rate is for plan'||p_plan_id,1);
2993: hr_utility.set_location('rate is for opt'||p_option_id,2);