APPS.BEN_EAP_BUS dependencies on BEN_ELIG_AGE_PRTE_F

Line 128: from ben_elig_age_prte_f

124: --
125: --
126: cursor c3 is
127: select null
128: from ben_elig_age_prte_f
129: where age_fctr_id = p_age_fctr_id
130: and eligy_prfl_id = p_eligy_prfl_id
131: and elig_age_prte_id <> nvl(p_elig_age_prte_id,hr_api.g_number)
132: and business_group_id + 0 = p_business_group_id

Line 163: ben_eap_shd.constraint_error('BEN_ELIG_AGE_PRTE_FK1');

159: --
160: -- raise error as FK does not relate to PK in ben_age_fctr
161: -- table.
162: --
163: ben_eap_shd.constraint_error('BEN_ELIG_AGE_PRTE_FK1');
164: --
165: end if;
166: --
167: close c1;

Line 296: from ben_elig_age_prte_f

292: l_proc varchar2(72) := g_package||'chk_duplicate_ordr_num';
293: l_dummy char(1);
294: cursor c1 is
295: select null
296: from ben_elig_age_prte_f
297: where elig_age_prte_id <> nvl(p_elig_age_prte_id,-1)
298: and eligy_prfl_id = p_eligy_prfl_id
299: and ordr_num = p_ordr_num
300: and business_group_id = p_business_group_id;

Line 665: ben_elig_age_prte_f b

661: --
662: cursor csr_leg_code is
663: select a.legislation_code
664: from per_business_groups a,
665: ben_elig_age_prte_f b
666: where b.elig_age_prte_id = p_elig_age_prte_id
667: and a.business_group_id = b.business_group_id;
668: --
669: -- Declare local variables