APPS.PQH_GSP_UTILITY dependencies on BEN_PL_TYP_F

Line 19: from ben_pl_typ_f

15: begin
16: hr_utility.set_location('Entering:'|| l_proc, 10);
17: select min(effective_start_date)
18: into l_plan_type_date
19: from ben_pl_typ_f
20: where business_group_id = p_business_group_id
21: and opt_typ_cd ='GSP'
22: and pl_typ_stat_cd ='A';
23: hr_utility.set_location('Plan Type date is :'|| l_plan_type_date, 20);

Line 56: from ben_pl_typ_f

52: hr_utility.set_location('Entering:'|| l_proc, 10);
53: begin
54: select 'Y'
55: into l_status
56: from ben_pl_typ_f
57: where business_group_id = p_business_group_id
58: and opt_typ_cd ='GSP'
59: and pl_typ_stat_cd ='A'
60: and rownum<2 ;