APPS.PQH_GSP_STAGE_TO_BEN dependencies on BEN_PL_TYP_F
Line 363: from ben_pl_typ_f
359: p_effective_date in date) return number is
360: l_pt_id number;
361: cursor c1 is
362: select pl_typ_id 363: from ben_pl_typ_f 364: where opt_typ_cd ='GSP'
365: and business_group_id = p_business_group_id
366: and pl_typ_stat_cd ='A'
367: and p_effective_date between effective_start_date and effective_end_date;