APPS.BEN_EXT_ENRT dependencies on BEN_PRTT_ENRT_RSLT_F

Line 529: from ben_prtt_enrt_rslt_f enrt,

525: ptp.ptp_attribute7,
526: ptp.ptp_attribute8,
527: ptp.ptp_attribute9,
528: ptp.ptp_attribute10
529: from ben_prtt_enrt_rslt_f enrt,
530: ben_pl_f pl,
531: ben_pl_typ_f ptp
532: where enrt.person_id = p_person_id
533: and p_effective_date between enrt.effective_start_date

Line 729: from ben_prtt_enrt_rslt_f prst,

725: --
726: cursor c_rpt_grp(l_prtt_enrt_rslt_id number) is
727: select grp.rptg_grp_id,
728: grp.name
729: from ben_prtt_enrt_rslt_f prst,
730: ben_popl_rptg_grp_f prpg,
731: ben_rptg_grp grp
732: where
733: prst.prtt_enrt_rslt_id = l_prtt_enrt_rslt_id

Line 743: ben_prtt_enrt_rslt_f pen

739: cursor c_pl_yr(l_prtt_enrt_rslt_id number) is
740: select yrp.start_date,yrp.end_date
741: from ben_yr_perd yrp,
742: ben_popl_yr_perd pop,
743: ben_prtt_enrt_rslt_f pen
744: where pop.yr_perd_id = yrp.yr_perd_id
745: and pop.pl_id = pen.pl_id
746: and p_effective_date between yrp.start_date and nvl(yrp.end_date,p_effective_date)
747: and p_effective_date between pen.effective_start_date and pen.effective_end_date

Line 756: ben_prtt_enrt_rslt_f pen

752: cursor c_pgm_yr(l_prtt_enrt_rslt_id number) is
753: select yrp.start_date,yrp.end_date
754: from ben_yr_perd yrp,
755: ben_popl_yr_perd pop,
756: ben_prtt_enrt_rslt_f pen
757: where pop.yr_perd_id = yrp.yr_perd_id
758: and pop.pgm_id = pen.pgm_id
759: and p_effective_date between yrp.start_date and nvl(yrp.end_date,p_effective_date)
760: and p_effective_date between pen.effective_start_date and pen.effective_end_date

Line 779: from ben_prtt_enrt_rslt_f enrt

775: and prm.mo_num = to_number(to_char(p_effective_date,'MM'));
776: --
777: cursor c_intrm(l_prtt_enrt_rslt_id number) is
778: select 1
779: from ben_prtt_enrt_rslt_f enrt
780: where enrt.rplcs_sspndd_rslt_id = l_prtt_enrt_rslt_id
781: and enrt.person_id = p_person_id
782: and sspndd_flag = 'Y'
783: and p_effective_date between enrt.effective_start_date

Line 796: from ben_prtt_enrt_rslt_f enrt,

792: enrt.oipl_id,
793: opt.opt_id opt_id,
794: opt.name opt_name,
795: enrt.bnft_amt cvg_amt
796: from ben_prtt_enrt_rslt_f enrt,
797: ben_pl_f pl,
798: ben_oipl_f oipl,
799: ben_opt_f opt
800: where enrt.prtt_enrt_rslt_id = l_rplcs_sspndd_rslt_id