APPS.BEN_DETERMINE_ACTIVITY_BASE_RT dependencies on BEN_PL_F

Line 602: ben_pl_f pln,

598: --
599: cursor c_pl_opt_name is
600: select pln.name || ' '|| opt.name
601: from ben_elig_per_elctbl_chc epe,
602: ben_pl_f pln,
603: ben_oipl_f oipl,
604: ben_opt_f opt
605: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
606: and epe.pl_id = pln.pl_id

Line 786: ben_pl_f pln

782: )
783: is
784: select ccm.cvg_amt_calc_mthd_id
785: from ben_cvg_amt_calc_mthd_f ccm,
786: ben_pl_f pln
787: where pln.pl_id = l_epe.pl_id
788: and pln.pl_id = ccm.pl_id
789: and c_effective_date
790: between pln.effective_start_date

Line 837: from ben_pl_f pln

833: is
834: select pln.nip_acty_ref_perd_cd
835: ,pln.nip_enrt_info_rt_freq_cd
836: ,name
837: from ben_pl_f pln
838: where pln.pl_id = c_pl_id
839: and c_effective_date
840: between pln.effective_start_date
841: and pln.effective_end_date;

Line 1123: ben_pl_f pln

1119: --
1120: cursor c_pl_typ(p_pl_id number) is
1121: select opt_typ_cd
1122: from ben_pl_typ_f ptp,
1123: ben_pl_f pln
1124: where pln.pl_id = p_pl_id
1125: and ptp.pl_typ_id = pln.pl_typ_id;
1126: --
1127: l_opt_typ_cd ben_pl_typ_f.opt_typ_cd%TYPE;