APPS.BEN_EQT_BUS dependencies on BEN_ELIG_QUAL_TITL_PRTE_F

Line 60: ben_eqt_shd.constraint_error('BEN_ELIG_QUAL_TITL_PRTE_F_PK');

56: <> ben_eqt_shd.g_old_rec.elig_qual_titl_prte_id) then
57: --
58: -- raise error as PK has changed
59: --
60: ben_eqt_shd.constraint_error('BEN_ELIG_QUAL_TITL_PRTE_F_PK');
61: --
62: elsif not l_api_updating then
63: --
64: -- check if PK is null

Line 70: ben_eqt_shd.constraint_error('BEN_ELIG_QUAL_TITL_PRTE_F_PK');

66: if p_elig_qual_titl_prte_id is not null then
67: --
68: -- raise error as PK is not null
69: --
70: ben_eqt_shd.constraint_error('BEN_ELIG_QUAL_TITL_PRTE_F_PK');
71: --
72: end if;
73: --
74: end if;

Line 220: ben_eqt_shd.constraint_error('BEN_ELIG_QUAL_TITL_PRTE_F_FK2');

216: --
217: -- raise error as FK does not relate to PK in
218: -- per_absence_attendance_types table.
219: --
220: ben_eqt_shd.constraint_error('BEN_ELIG_QUAL_TITL_PRTE_F_FK2');
221: --
222: end if;
223: --
224: close c1;

Line 275: from ben_elig_qual_titl_prte_f eqt

271: l_dummy varchar2(1);
272: --
273: cursor c1 is
274: select null
275: from ben_elig_qual_titl_prte_f eqt
276: where nvl(eqt.qualification_type_id,-1) = nvl(p_qualification_type_id,-1)
277: and nvl(eqt.title,-1) = nvl(p_title,-1)
278: and eqt.eligy_prfl_id = p_eligy_prfl_id
279: and eqt.elig_qual_titl_prte_id <> nvl(p_elig_qual_titl_prte_id,hr_api.g_number)

Line 345: from ben_elig_qual_titl_prte_f

341: l_proc varchar2(72) := g_package||'chk_duplicate_ordr_num';
342: l_dummy char(1);
343: cursor c1 is
344: select null
345: from ben_elig_qual_titl_prte_f
346: where elig_qual_titl_prte_id <> nvl(p_elig_qual_titl_prte_id,-1)
347: and eligy_prfl_id = p_eligy_prfl_id
348: and ordr_num = p_ordr_num
349: and business_group_id = p_business_group_id;

Line 729: ben_elig_qual_titl_prte_f b

725: --
726: cursor csr_leg_code is
727: select a.legislation_code
728: from per_business_groups a,
729: ben_elig_qual_titl_prte_f b
730: where b.elig_qual_titl_prte_id = p_elig_qual_titl_prte_id
731: and a.business_group_id = b.business_group_id;
732: --
733: -- Declare local variables