APPS.BEN_EOP_BUS dependencies on BEN_ELIG_ANTHR_PL_PRTE_F

Line 151: ben_eop_shd.constraint_error('BEN_ELIG_ANTHR_PL_PRTE_F_FK3');

147: --
148: -- raise error as FK does not relate to PK in
149: -- ben_pl_f table.
150: --
151: ben_eop_shd.constraint_error('BEN_ELIG_ANTHR_PL_PRTE_F_FK3');
152: --
153: end if;
154: --
155: close c1;

Line 269: from ben_ELIG_ANTHR_PL_PRTE_f eop

265: l_dummy char(1);
266: --
267: cursor c_ELIG_ANTHR_PL_PRTE is
268: select null
269: from ben_ELIG_ANTHR_PL_PRTE_f eop
270: where eop.eligy_prfl_id = p_eligy_prfl_id
271: and eop.pl_id = p_pl_id
272: and eop.ELIG_ANTHR_PL_PRTE_id <> nvl(p_ELIG_ANTHR_PL_PRTE_id, hr_api.g_number) ;
273: --

Line 342: from ben_ELIG_ANTHR_PL_PRTE_f

338: l_proc varchar2(72) := g_package||'chk_duplicate_ordr_num';
339: l_dummy char(1);
340: cursor c1 is
341: select null
342: from ben_ELIG_ANTHR_PL_PRTE_f
343: where ELIG_ANTHR_PL_PRTE_id <> nvl(p_ELIG_ANTHR_PL_PRTE_id,-1)
344: and eligy_prfl_id = p_eligy_prfl_id
345: and ordr_num = p_ordr_num
346: and business_group_id = p_business_group_id;

Line 720: ben_ELIG_ANTHR_PL_PRTE_f b

716: --
717: cursor csr_leg_code is
718: select a.legislation_code
719: from per_business_groups a,
720: ben_ELIG_ANTHR_PL_PRTE_f b
721: where b.ELIG_ANTHR_PL_PRTE_id = p_ELIG_ANTHR_PL_PRTE_id
722: and a.business_group_id = b.business_group_id;
723: --
724: -- Declare local variables