APPS.PQH_RBC_STAGE_TO_RBC dependencies on BEN_PL_TYP_F

Line 219: from ben_pl_typ_f

215: begin
216: hr_utility.set_location('Entering:'|| l_proc, 10);
217: select min(effective_start_date)
218: into l_plan_type_date
219: from ben_pl_typ_f
220: where business_group_id = p_business_group_id
221: and opt_typ_cd ='RBC'
222: and pl_typ_stat_cd ='A';
223: hr_utility.set_location('Plan Type date is :'|| l_plan_type_date, 20);

Line 252: from ben_pl_typ_f

248: if l_status is null then
249: begin
250: select pl_typ_id,name,effective_start_date
251: into l_pt_id,l_pt_name,l_effective_start_date
252: from ben_pl_typ_f
253: where trunc(effective_end_date) = hr_general.end_of_time
254: and business_group_id = p_business_group_id
255: and opt_typ_cd ='RBC';
256:

Line 1018: from ben_pl_typ_f

1014: hr_utility.set_location('Entering: get_pl_typ_id', 10);
1015:
1016: select PL_TYP_ID
1017: into l_pl_typ_id
1018: from ben_pl_typ_f
1019: where p_effective_date between effective_start_date and effective_end_date
1020: and business_group_id = p_business_group_id
1021: and opt_typ_cd = 'RBC';
1022: