APPS.BEN_DETERMINE_DATE dependencies on BEN_PRTT_ENRT_RSLT_F

Line 985: from ben_prtt_enrt_rslt_f pen

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

Line 1010: ben_prtt_enrt_rslt_f pen

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)
1014: and nvl(pen.oipl_id,-1)=nvl(l_oipl_id,-1)

Line 1025: ben_prtt_enrt_rslt_f pen

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

Line 1093: from ben_prtt_enrt_rslt_f pen

1089: cursor c_prtt_enrt_rslt_dts_bckdt(c_per_in_ler_id number) is
1090: select pen.enrt_cvg_thru_dt,
1091: pen.enrt_cvg_strt_dt,
1092: pen.effective_start_date
1093: from ben_prtt_enrt_rslt_f pen
1094: where pen.per_in_ler_id = c_per_in_ler_id
1095: and pen.pl_id=l_pl_id
1096: and nvl(pen.pgm_id,-1)=nvl(l_pgm_id,-1)
1097: and nvl(pen.oipl_id,-1)=nvl(l_oipl_id,-1)

Line 1102: (select '1' from ben_prtt_enrt_rslt_f pen1

1098: --and pen.pl_typ_id = l_pl_typ_id
1099: and pen.business_group_id = l_business_group_id
1100: and pen.enrt_cvg_thru_dt = hr_api.g_eot
1101: and not exists
1102: (select '1' from ben_prtt_enrt_rslt_f pen1
1103: where pen.prtt_enrt_rslt_id = pen1.RPLCS_SSPNDD_RSLT_ID
1104: and pen1.per_in_ler_id = c_per_in_ler_id);
1105:
1106:

Line 1110: from ben_prtt_enrt_rslt_f pen,

1106:
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)

Line 1122: (select '1' from ben_prtt_enrt_rslt_f pen1

1118: and pen.enrt_cvg_thru_dt = hr_api.g_eot
1119: and prv.per_in_ler_id = c_per_in_ler_id
1120: and prv.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
1121: and not exists
1122: (select '1' from ben_prtt_enrt_rslt_f pen1
1123: where pen.prtt_enrt_rslt_id = pen1.RPLCS_SSPNDD_RSLT_ID
1124: and pen1.per_in_ler_id = c_per_in_ler_id);
1125:
1126: l_rt_strt_dt1 date;

Line 7495: from ben_prtt_enrt_rslt_f pen,

7491:
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)

Line 7507: (select '1' from ben_prtt_enrt_rslt_f pen1

7503: and pen.enrt_cvg_thru_dt = hr_api.g_eot
7504: and prv.per_in_ler_id = c_per_in_ler_id
7505: and prv.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
7506: and not exists
7507: (select '1' from ben_prtt_enrt_rslt_f pen1
7508: where pen.prtt_enrt_rslt_id = pen1.RPLCS_SSPNDD_RSLT_ID
7509: and pen1.per_in_ler_id = c_per_in_ler_id);
7510:
7511: l_rt_strt_dt1 date;