APPS.BEN_GENERATE_DPNT_COMM dependencies on BEN_PL_F

Line 4288: ben_pl_f pln,

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

Line 4333: ben_pl_f pln,

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

Line 4381: ben_pl_f pln,

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

Line 4413: ,ben_pl_f pln

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

Line 4458: ben_pl_f pln,

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

Line 4502: ben_pl_f pln,

4498: v_pl_typ_id in number) is
4499: select 'Y'
4500: from ben_elig_per_elctbl_chc epe,
4501: ben_per_in_ler pil,
4502: ben_pl_f pln,
4503: ben_oipl_f cop,
4504: ben_opt_f opt
4505: where epe.per_in_ler_id = p_per_in_ler_id
4506: and nvl(epe.pgm_id,-1) = nvl(v_pgm_id,-1)