APPS.PQH_GSP_STAGE_TO_HR dependencies on BEN_PL_TYP_F

Line 187: from ben_pl_typ_f

183: if l_status is null then
184: begin
185: select pl_typ_id,name,effective_start_date
186: into l_pt_id,l_pt_name,l_effective_start_date
187: from ben_pl_typ_f
188: where effective_end_date = hr_general.end_of_time
189: and business_group_id = p_business_group_id
190: and opt_typ_cd ='GSP'
191: and pl_typ_stat_cd ='A';