APPS.BEN_EHC_BUS dependencies on BEN_ELIG_HLTH_CVG_PRTE_F

Line 155: ben_ehc_shd.constraint_error('BEN_ELIG_HLTH_CVG_PRTE_F_FK1');

151: --
152: -- raise error as FK does not relate to PK in
153: -- ben_pl_typ_opt_typ_f table.
154: --
155: ben_ehc_shd.constraint_error('BEN_ELIG_HLTH_CVG_PRTE_F_FK1');
156: --
157: end if;
158: --
159: close c1;

Line 243: ben_ehc_shd.constraint_error('BEN_ELIG_HLTH_CVG_PRTE_F_FK2');

239: --
240: -- raise error as FK does not relate to PK in
241: -- ben_oipl_f table.
242: --
243: ben_ehc_shd.constraint_error('BEN_ELIG_HLTH_CVG_PRTE_F_FK2');
244: --
245: end if;
246: --
247: close c1;

Line 361: from ben_ELIG_HLTH_CVG_PRTE_f

357: l_proc varchar2(72) := g_package||'chk_duplicate_ordr_num';
358: l_dummy char(1);
359: cursor c1 is
360: select null
361: from ben_ELIG_HLTH_CVG_PRTE_f
362: where ELIG_HLTH_CVG_PRTE_id <> nvl(p_ELIG_HLTH_CVG_PRTE_id,-1)
363: and eligy_prfl_id = p_eligy_prfl_id
364: and ordr_num = p_ordr_num
365: and business_group_id = p_business_group_id;

Line 737: ben_ELIG_HLTH_CVG_PRTE_f b

733: --
734: cursor csr_leg_code is
735: select a.legislation_code
736: from per_business_groups a,
737: ben_ELIG_HLTH_CVG_PRTE_f b
738: where b.ELIG_HLTH_CVG_PRTE_id = p_ELIG_HLTH_CVG_PRTE_id
739: and a.business_group_id = b.business_group_id;
740: --
741: -- Declare local variables