APPS.BEN_DETERMINE_DATE dependencies on BEN_PRTT_ENRT_RSLT_F

Line 983: from ben_prtt_enrt_rslt_f pen

979: cursor c_prtt_enrt_rslt_dts is
980: select pen.enrt_cvg_thru_dt,
981: pen.enrt_cvg_strt_dt,
982: pen.effective_start_date
983: from ben_prtt_enrt_rslt_f pen
984: where pen.per_in_ler_id = l_per_in_ler_id and
985: pen.pl_id=l_pl_id
986: and nvl(pen.pgm_id,-1)=nvl(l_pgm_id,-1)
987: and nvl(pen.oipl_id,-1)=nvl(l_oipl_id,-1)

Line 1008: ben_prtt_enrt_rslt_f pen

1004: select prv.rt_strt_dt,
1005: prv.rt_end_dt
1006:
1007: from ben_prtt_rt_val prv,
1008: ben_prtt_enrt_rslt_f pen
1009: where pen.per_in_ler_id = l_per_in_ler_id
1010: and pen.pl_id=l_pl_id
1011: and nvl(pen.pgm_id,-1)=nvl(l_pgm_id,-1)
1012: and nvl(pen.oipl_id,-1)=nvl(l_oipl_id,-1)

Line 1023: ben_prtt_enrt_rslt_f pen

1019: --
1020: cursor c_prtt_rt_val_dts is
1021: select null
1022: from
1023: ben_prtt_enrt_rslt_f pen
1024: where pen.per_in_ler_id = l_per_in_ler_id
1025: and pen.pl_id=l_pl_id
1026: and nvl(pen.pgm_id,-1)=nvl(l_pgm_id,-1)
1027: -- and nvl(pen.oipl_id,-1)=nvl(l_oipl_id,-1)