APPS.BEN_EGR_BUS dependencies on BEN_ELIG_GRD_PRTE_F

Line 130: from ben_elig_grd_prte_f

126: --
127: --
128: cursor c3 is
129: select null
130: from ben_elig_grd_prte_f
131: where grade_id = p_grade_id
132: and eligy_prfl_id = p_eligy_prfl_id
133: and elig_grd_prte_id <> nvl(p_elig_grd_prte_id,hr_api.g_number)
134: and business_group_id + 0 = p_business_group_id

Line 165: ben_egr_shd.constraint_error('BEN_ELIG_GRD_PRTE_FK2');

161: --
162: -- raise error as FK does not relate to PK in per_grades
163: -- table.
164: --
165: ben_egr_shd.constraint_error('BEN_ELIG_GRD_PRTE_FK2');
166: --
167: end if;
168: --
169: close c1;

Line 284: from ben_elig_grd_prte_f

280: l_proc varchar2(72) := g_package||'chk_duplicate_ordr_num';
281: l_dummy char(1);
282: cursor c1 is
283: select null
284: from ben_elig_grd_prte_f
285: where elig_grd_prte_id <> nvl(p_elig_grd_prte_id,-1)
286: and eligy_prfl_id = p_eligy_prfl_id
287: and ordr_num = p_ordr_num
288: and business_group_id = p_business_group_id;

Line 653: ben_elig_grd_prte_f b

649: --
650: cursor csr_leg_code is
651: select a.legislation_code
652: from per_business_groups a,
653: ben_elig_grd_prte_f b
654: where b.elig_grd_prte_id = p_elig_grd_prte_id
655: and a.business_group_id = b.business_group_id;
656: --
657: -- Declare local variables