APPS.BEN_EPS_BUS dependencies on BEN_ELIG_PSTN_PRTE_F

Line 150: ben_eps_shd.constraint_error('BEN_ELIG_pstn_prte_F_FK3');

146: --
147: -- raise error as FK does not relate to PK in
148: -- per_abs_attendance_reasons table.
149: --
150: ben_eps_shd.constraint_error('BEN_ELIG_pstn_prte_F_FK3');
151: --
152: end if;
153: --
154: close c1;

Line 268: from ben_elig_pstn_prte_f eps

264: l_dummy char(1);
265: --
266: cursor c_elig_pstn_prte is
267: select null
268: from ben_elig_pstn_prte_f eps
269: where eps.eligy_prfl_id = p_eligy_prfl_id
270: and eps.position_id = p_position_id
271: and eps.elig_pstn_prte_id <> nvl(p_elig_pstn_prte_id, hr_api.g_number) ;
272: --

Line 341: from ben_elig_pstn_prte_f

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

Line 705: ben_elig_pstn_prte_f b

701: --
702: cursor csr_leg_code is
703: select a.legislation_code
704: from per_business_groups a,
705: ben_elig_pstn_prte_f b
706: where b.elig_pstn_prte_id = p_elig_pstn_prte_id
707: and a.business_group_id = b.business_group_id;
708: --
709: -- Declare local variables