DBA Data[Home] [Help]

APPS.BEN_GENERATE_DPNT_COMM dependencies on BEN_REGN_F

Line 4289: ben_regn_f regn,

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
4292: where pdp.per_in_ler_id = p_per_in_ler_id
4293: and pdp.dpnt_person_id = p_rcpent_person_id

Line 4334: ben_regn_f regn,

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
4337: where pdp.effective_start_date = p_effective_date
4338: and pdp.dpnt_person_id = p_rcpent_person_id

Line 4416: ,ben_regn_f regn

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
4417: where pen.person_id = p_person_id
4418: and pen.prtt_enrt_rslt_stat_cd is null
4419: and pen.pl_typ_id = l_pl_typ_id
4420: and pen.sspndd_flag = 'N'