APPS.BEN_GENERATE_COMMUNICATIONS dependencies on BEN_PL_F

Line 1155: from ben_pl_f pl

1151: -- if pl_typ is in usages , validte the pl against pl_type
1152: and (ctu.pl_typ_id is null or
1153: exists
1154: ( select 'x'
1155: from ben_pl_f pl
1156: where pl.pl_id = pep.pl_id
1157: and pl.pl_typ_id = ctu.pl_typ_id
1158: and cv_effective_date between
1159: pl.effective_start_date

Line 1195: from ben_pl_f pl

1191: AND (ctu.ler_id is null or nvl(ctu.ler_id,-1) = nvl(pil2.ler_id,-1) )
1192: AND (ctu.pl_typ_id is null or
1193: (exists
1194: ( select 'x'
1195: from ben_pl_f pl
1196: where pl.pl_id = nvl(pep2.pl_id,pl.pl_id)
1197: and pl.pl_typ_id = nvl(ctu.pl_typ_id,pl.pl_typ_id)
1198: and cv_effective_date between
1199: pl.effective_start_date

Line 1230: from ben_pl_f pl

1226: -- AND (ctu.ler_id is null or nvl(ctu.ler_id,-1) = nvl(pil2.ler_id,-1) )
1227: AND (ctu.pl_typ_id is null or
1228: (exists
1229: ( select 'x'
1230: from ben_pl_f pl
1231: where pl.pl_id = nvl(pep2.pl_id,pl.pl_id)
1232: and pl.pl_typ_id = nvl(ctu.pl_typ_id,pl.pl_typ_id)
1233: and cv_effective_date between
1234: pl.effective_start_date

Line 1258: from ben_pl_f pl

1254: AND (ctu.ler_id is null or nvl(ctu.ler_id,-1) = nvl(pil2.ler_id,-1) )
1255: AND (ctu.pl_typ_id is null or
1256: (exists
1257: ( select 'x'
1258: from ben_pl_f pl
1259: where pl.pl_id = nvl(pep2.pl_id,pl.pl_id)
1260: and pl.pl_typ_id = nvl(ctu.pl_typ_id,pl.pl_typ_id)
1261: and cv_effective_date between
1262: pl.effective_start_date

Line 1330: from ben_pl_f pl

1326: and (c_ler_id is null or nvl(c_ler_id,-1) = nvl(pep.ler_id,-1) )
1327: and (c_pl_typ_id is null or
1328: (exists
1329: ( select 'x'
1330: from ben_pl_f pl
1331: where pl.pl_id = pep.pl_id
1332: and pl.pl_typ_id = c_pl_typ_id
1333: and cv_effective_date between
1334: pl.effective_start_date

Line 3741: ben_pl_f pln,

3737: --
3738: cursor c_prev_enrt is
3739: select distinct pen.pgm_id, pen.pl_typ_id
3740: from ben_prtt_enrt_rslt_f pen,
3741: ben_pl_f pln,
3742: ben_pl_regn_f plrg,
3743: ben_regn_f regn,
3744: ben_oipl_f cop,
3745: ben_opt_f opt

Line 3782: ben_pl_f pln,

3778: v_pl_typ_id in number) is
3779: select 'Y'
3780: from ben_elig_per_elctbl_chc epe,
3781: ben_per_in_ler pil,
3782: ben_pl_f pln,
3783: ben_oipl_f cop,
3784: ben_opt_f opt
3785: where epe.per_in_ler_id = p_per_in_ler_id
3786: and nvl(epe.pgm_id,-1) = nvl(v_pgm_id,-1)

Line 3812: ben_pl_f pln,

3808: cursor c_crntly_enrd(v_pgm_id in number,
3809: v_pl_typ_id in number) is
3810: select 'Y'
3811: from ben_prtt_enrt_rslt_f pen,
3812: ben_pl_f pln,
3813: ben_oipl_f cop,
3814: ben_opt_f opt
3815: where pen.person_id = p_person_id
3816: -- and nvl(pen.pgm_id,-1) = nvl(v_pgm_id,-1) maagrawa (02/11/00)

Line 4529: l_pl_rec ben_pl_f%rowtype;

4525: --
4526: l_proc varchar2(80) := g_package||'main';
4527: --
4528: l_ass_rec per_all_assignments_f%rowtype;
4529: l_pl_rec ben_pl_f%rowtype;
4530: l_pil_rec ben_per_in_ler%rowtype;
4531: l_loc_rec hr_locations_all%rowtype;
4532: l_effective_date date;
4533: --