APPS.BEN_DETERMINE_ACTIVITY_BASE_RT dependencies on BEN_PL_F

Line 619: ben_pl_f pln,

615: --
616: cursor c_pl_opt_name is
617: select pln.name || ' '|| opt.name
618: from ben_elig_per_elctbl_chc epe,
619: ben_pl_f pln,
620: ben_oipl_f oipl,
621: ben_opt_f opt
622: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
623: and epe.pl_id = pln.pl_id

Line 803: ben_pl_f pln

799: )
800: is
801: select ccm.cvg_amt_calc_mthd_id
802: from ben_cvg_amt_calc_mthd_f ccm,
803: ben_pl_f pln
804: where pln.pl_id = l_epe.pl_id
805: and pln.pl_id = ccm.pl_id
806: and c_effective_date
807: between pln.effective_start_date

Line 854: from ben_pl_f pln

850: is
851: select pln.nip_acty_ref_perd_cd
852: ,pln.nip_enrt_info_rt_freq_cd
853: ,name
854: from ben_pl_f pln
855: where pln.pl_id = c_pl_id
856: and c_effective_date
857: between pln.effective_start_date
858: and pln.effective_end_date;

Line 1140: ben_pl_f pln

1136: --
1137: cursor c_pl_typ(p_pl_id number) is
1138: select opt_typ_cd
1139: from ben_pl_typ_f ptp,
1140: ben_pl_f pln
1141: where pln.pl_id = p_pl_id
1142: and ptp.pl_typ_id = pln.pl_typ_id;
1143: --
1144: l_opt_typ_cd ben_pl_typ_f.opt_typ_cd%TYPE;