APPS.BEN_GENERATE_DPNT_COMM dependencies on BEN_PL_F

Line 4287: ben_pl_f pln,

4283: cursor c_prev_enrt is
4284: select pen.pgm_id, pen.pl_typ_id, max(pen.enrt_cvg_thru_dt)
4285: from ben_elig_cvrd_dpnt_f pdp,
4286: ben_prtt_enrt_rslt_f pen,
4287: ben_pl_f pln,
4288: ben_pl_regn_f plrg,
4289: ben_regn_f regn,
4290: ben_oipl_f cop,
4291: ben_opt_f opt

Line 4332: ben_pl_f pln,

4328: cursor c_bendsgel_prev_enrt is
4329: select max(pen.enrt_cvg_thru_dt)
4330: from ben_elig_cvrd_dpnt_f pdp,
4331: ben_prtt_enrt_rslt_f pen,
4332: ben_pl_f pln,
4333: ben_pl_regn_f plrg,
4334: ben_regn_f regn,
4335: ben_oipl_f cop,
4336: ben_opt_f opt

Line 4380: ben_pl_f pln,

4376: select 'Y'
4377: from ben_elig_dpnt egd,
4378: ben_elig_per_elctbl_chc epe,
4379: ben_per_in_ler pil,
4380: ben_pl_f pln,
4381: ben_oipl_f cop,
4382: ben_opt_f opt
4383: where epe.per_in_ler_id = p_per_in_ler_id
4384: and nvl(epe.pgm_id,-1) = nvl(l_pgm_id,-1)

Line 4412: ,ben_pl_f pln

4408: --
4409: cursor c_prtt_crntly_enrd is
4410: select 'Y'
4411: from ben_prtt_enrt_rslt_f pen
4412: ,ben_pl_f pln
4413: ,ben_oipl_f cop
4414: ,ben_opt_f opt
4415: ,ben_pl_regn_f plrg
4416: ,ben_regn_f regn

Line 4457: ben_pl_f pln,

4453: cursor c_crntly_enrd is
4454: select 'Y'
4455: from ben_elig_cvrd_dpnt_f pdp,
4456: ben_prtt_enrt_rslt_f pen,
4457: ben_pl_f pln,
4458: ben_oipl_f cop,
4459: ben_opt_f opt
4460: where pdp.cvg_thru_dt = hr_api.g_eot
4461: and pdp.dpnt_person_id = p_rcpent_person_id

Line 4496: ben_pl_f pln,

4492: v_pl_typ_id in number) is
4493: select 'Y'
4494: from ben_elig_per_elctbl_chc epe,
4495: ben_per_in_ler pil,
4496: ben_pl_f pln,
4497: ben_oipl_f cop,
4498: ben_opt_f opt
4499: where epe.per_in_ler_id = p_per_in_ler_id
4500: and nvl(epe.pgm_id,-1) = nvl(v_pgm_id,-1)