APPS.BEN_CEP_BUS dependencies on BEN_PRTN_ELIG_PRFL_F

Line 270: from ben_prtn_elig_prfl_f

266: l_exists varchar2(1);
267: --
268: cursor c1 is
269: select null
270: from ben_prtn_elig_prfl_f
271: where eligy_prfl_id = p_eligy_prfl_id
272: and prtn_elig_id = p_prtn_elig_id
273: and prtn_elig_prfl_id <> nvl(p_prtn_elig_prfl_id, hr_api.g_number)
274: and business_group_id + 0 = p_business_group_id

Line 801: ben_prtn_elig_prfl_f b

797: --
798: cursor csr_leg_code is
799: select a.legislation_code
800: from per_business_groups a,
801: ben_prtn_elig_prfl_f b
802: where b.prtn_elig_prfl_id = p_prtn_elig_prfl_id
803: and a.business_group_id = b.business_group_id;
804: --
805: -- Declare local variables