APPS.BEN_PBC_BUS dependencies on BEN_PL_BNF_CTFN_PRVDD_F

Line 189: from ben_pl_bnf_ctfn_prvdd_f

185: l_exists varchar2(1);
186: --
187: cursor c3 is
188: select null
189: from ben_pl_bnf_ctfn_prvdd_f
190: where pl_bnf_id = p_pl_bnf_id
191: and bnf_ctfn_typ_cd = p_bnf_ctfn_typ_cd
192: and pl_bnf_ctfn_prvdd_id <> nvl(p_pl_bnf_ctfn_prvdd_id, hr_api.g_number)
193: and business_group_id + 0 = p_business_group_id

Line 599: ben_pl_bnf_ctfn_prvdd_f b

595: --
596: cursor csr_leg_code is
597: select a.legislation_code
598: from per_business_groups a,
599: ben_pl_bnf_ctfn_prvdd_f b
600: where b.pl_bnf_ctfn_prvdd_id = p_pl_bnf_ctfn_prvdd_id
601: and a.business_group_id = b.business_group_id;
602: --
603: -- Declare local variables