DBA Data[Home] [Help]

APPS.BEN_MNG_DPNT_BNF dependencies on BEN_PL_BNF_F

Line 245: from ben_pl_bnf_f pbn,

241: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT');
242: --
243: cursor old_bnf_c is
244: select pbn.*
245: from ben_pl_bnf_f pbn,
246: ben_per_in_ler pil
247: where pbn.prtt_enrt_rslt_id = p_old_prtt_enrt_rslt_id
248: and pbn.business_group_id = p_business_group_id
249: and p_effective_date between pbn.effective_start_date