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 ;

Line 85: BEN_PL_TYP_F bpt,

81: ,bpgm.name
82: from
83: ben_pgm_f bpgm,
84: ben_pl_f bp,
85: BEN_PL_TYP_F bpt,
86: ben_plip_f bplip,
87: per_grade_spines_f pgs,
88: per_grades pg
89: where

Line 141: BEN_PL_TYP_F bpt,

137: ,bpgm.name
138: from
139: ben_pgm_f bpgm,
140: ben_pl_f bp,
141: BEN_PL_TYP_F bpt,
142: ben_plip_f bplip,
143: per_grade_spines_f pgs,
144: per_grades pg,
145: pay_rates pr,