APPS.BEN_EAC_BUS dependencies on BEN_ELIG_AGE_CVG_F

Line 146: ben_eac_shd.constraint_error('BEN_ELIG_AGE_CVG_FK2');

142: --
143: -- raise error as FK does not relate to PK in ben_age_fctr
144: -- table.
145: --
146: ben_eac_shd.constraint_error('BEN_ELIG_AGE_CVG_FK2');
147: --
148: end if;
149: --
150: close c1;

Line 655: cursor c1 is select null from ben_elig_age_cvg_f

651: l_proc varchar2(72) := g_package||'chk_duplicate_rows';
652: l_api_updating boolean;
653:
654: dummy varchar2(1);
655: cursor c1 is select null from ben_elig_age_cvg_f
656: where (elig_age_cvg_id <> p_elig_age_cvg_id or p_elig_age_cvg_id is null) and
657: dpnt_cvg_eligy_prfl_id = p_dpnt_cvg_eligy_prfl_id and
658: age_fctr_id = p_age_fctr_id and
659: business_group_id = p_business_group_id and

Line 1092: ben_elig_age_cvg_f b

1088: --
1089: cursor csr_leg_code is
1090: select a.legislation_code
1091: from per_business_groups a,
1092: ben_elig_age_cvg_f b
1093: where b.elig_age_cvg_id = p_elig_age_cvg_id
1094: and a.business_group_id = b.business_group_id;
1095: --
1096: -- Declare local variables