APPS.BEN_EXT_ELIG dependencies on BEN_PL_F

Line 951: ben_pl_f pl,

947: ben_elig_per_elctbl_chc echc,
948: ben_pil_elctbl_chc_popl ppopl,
949: ben_enrt_bnft enb,
950: ben_opt_f opt,
951: ben_pl_f pl,
952: ben_plip_f plip,
953: ben_oipl_f oipl,
954: ben_pgm_f pgm,
955: ben_pl_typ_f ptp,

Line 1153: from ben_pl_f pl

1149: pl.pln_attribute8 pl_flex_08,
1150: pl.pln_attribute9 pl_flex_09,
1151: pl.pln_attribute10 pl_flex_10,
1152: pl.cobra_pymt_due_dy_num
1153: from ben_pl_f pl
1154: where pl.pl_id = p_pl_id
1155: and p_effective_date
1156: between pl.effective_start_date and pl.effective_end_date
1157: ;

Line 1344: l_pl_id ben_pl_f.pl_id%type;

1340: and p_effective_date
1341: between ler.effective_start_date
1342: and ler.effective_end_date;
1343: --
1344: l_pl_id ben_pl_f.pl_id%type;
1345: --
1346:
1347: -- for cobra aetter
1348: cursor c_cbradm_pl (p_pl_id number) is