APPS.BEN_GENERATE_COMMUNICATIONS dependencies on BEN_PL_F

Line 967: from ben_pl_f pl

963: -- if pl_typ is in usages , validte the pl against pl_type
964: and (ctu.pl_typ_id is null or
965: exists
966: ( select 'x'
967: from ben_pl_f pl
968: where pl.pl_id = pep.pl_id
969: and pl.pl_typ_id = ctu.pl_typ_id
970: and cv_effective_date between
971: pl.effective_start_date

Line 1006: from ben_pl_f pl

1002: AND (ctu.ler_id is null or nvl(ctu.ler_id,-1) = nvl(pil2.ler_id,-1) )
1003: AND (ctu.pl_typ_id is null or
1004: (exists
1005: ( select 'x'
1006: from ben_pl_f pl
1007: where pl.pl_id = pep2.pl_id
1008: and pl.pl_typ_id = ctu.pl_typ_id
1009: and cv_effective_date between
1010: pl.effective_start_date

Line 1037: from ben_pl_f pl

1033: AND (ctu.ler_id is null or nvl(ctu.ler_id,-1) = nvl(pil2.ler_id,-1) )
1034: AND (ctu.pl_typ_id is null or
1035: (exists
1036: ( select 'x'
1037: from ben_pl_f pl
1038: where pl.pl_id = pep2.pl_id
1039: and pl.pl_typ_id = ctu.pl_typ_id
1040: and cv_effective_date between
1041: pl.effective_start_date

Line 1108: from ben_pl_f pl

1104: and (c_ler_id is null or nvl(c_ler_id,-1) = nvl(pep.ler_id,-1) )
1105: and (c_pl_typ_id is null or
1106: (exists
1107: ( select 'x'
1108: from ben_pl_f pl
1109: where pl.pl_id = pep.pl_id
1110: and pl.pl_typ_id = c_pl_typ_id
1111: and cv_effective_date between
1112: pl.effective_start_date

Line 3501: ben_pl_f pln,

3497: --
3498: cursor c_prev_enrt is
3499: select distinct pen.pgm_id, pen.pl_typ_id
3500: from ben_prtt_enrt_rslt_f pen,
3501: ben_pl_f pln,
3502: ben_pl_regn_f plrg,
3503: ben_regn_f regn,
3504: ben_oipl_f cop,
3505: ben_opt_f opt

Line 3541: ben_pl_f pln,

3537: v_pl_typ_id in number) is
3538: select 'Y'
3539: from ben_elig_per_elctbl_chc epe,
3540: ben_per_in_ler pil,
3541: ben_pl_f pln,
3542: ben_oipl_f cop,
3543: ben_opt_f opt
3544: where epe.per_in_ler_id = p_per_in_ler_id
3545: and nvl(epe.pgm_id,-1) = nvl(v_pgm_id,-1)

Line 3571: ben_pl_f pln,

3567: cursor c_crntly_enrd(v_pgm_id in number,
3568: v_pl_typ_id in number) is
3569: select 'Y'
3570: from ben_prtt_enrt_rslt_f pen,
3571: ben_pl_f pln,
3572: ben_oipl_f cop,
3573: ben_opt_f opt
3574: where pen.person_id = p_person_id
3575: -- and nvl(pen.pgm_id,-1) = nvl(v_pgm_id,-1) maagrawa (02/11/00)

Line 4200: l_pl_rec ben_pl_f%rowtype;

4196: --
4197: l_proc varchar2(80) := g_package||'main';
4198: --
4199: l_ass_rec per_all_assignments_f%rowtype;
4200: l_pl_rec ben_pl_f%rowtype;
4201: l_pil_rec ben_per_in_ler%rowtype;
4202: l_loc_rec hr_locations_all%rowtype;
4203: l_effective_date date;
4204: --