DBA Data[Home] [Help]

APPS.BEN_ENP_BUS dependencies on BEN_PL_F

Line 2264: from ben_pl_f pln

2260: ) is
2261: --
2262: cursor c_pl_cd is
2263: select pln.pl_cd
2264: from ben_pl_f pln
2265: ,ben_popl_enrt_typ_cycl_f pet
2266: ,ben_enrt_perd enp
2267: where pet.popl_enrt_typ_cycl_id = p_popl_enrt_typ_cycl_id
2268: and pet.pl_id = pln.pl_id

Line 2274: l_pl_cd ben_pl_f.pl_cd%TYPE;

2270: and pet.business_group_id = pln.business_group_id
2271: and p_effective_date between pln.effective_start_date and pln.effective_end_date
2272: and p_effective_date between pet.effective_start_date and pet.effective_end_date;
2273: --
2274: l_pl_cd ben_pl_f.pl_cd%TYPE;
2275: l_api_updating boolean;
2276: l_proc varchar2(72) := g_package||'chk_defer_flag_set_pln_plip';
2277: --
2278: begin