APPS.BEN_DETERMINE_DATE dependencies on BEN_PRTT_RT_VAL

Line 1009: from ben_prtt_rt_val prv,

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

Line 1111: ben_prtt_rt_val prv

1107: cursor c_rt_dts_bckdt(c_per_in_ler_id number) is
1108: select prv.rt_strt_dt,
1109: prv.rt_end_dt
1110: from ben_prtt_enrt_rslt_f pen,
1111: ben_prtt_rt_val prv
1112: where pen.per_in_ler_id = c_per_in_ler_id
1113: and pen.pl_id=l_pl_id
1114: and nvl(pen.pgm_id,-1)=nvl(l_pgm_id,-1)
1115: and nvl(pen.oipl_id,-1)=nvl(l_oipl_id,-1)

Line 7496: ben_prtt_rt_val prv

7492: cursor c_rt_dts_bckdt(c_per_in_ler_id number) is
7493: select prv.rt_strt_dt,
7494: prv.rt_end_dt
7495: from ben_prtt_enrt_rslt_f pen,
7496: ben_prtt_rt_val prv
7497: where pen.per_in_ler_id = c_per_in_ler_id
7498: and pen.pl_id=l_pl_id
7499: and nvl(pen.pgm_id,-1)=nvl(l_pgm_id,-1)
7500: and nvl(pen.oipl_id,-1)=nvl(l_oipl_id,-1)