APPS.BEN_QTR_BUS dependencies on BEN_QUAL_TITL_RT_F

Line 60: ben_qtr_shd.constraint_error('BEN_qual_titl_rt_F_PK');

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

Line 70: ben_qtr_shd.constraint_error('BEN_qual_titl_rt_F_PK');

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

Line 220: ben_qtr_shd.constraint_error('BEN_qual_titl_rt_F_FK2');

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

Line 275: from ben_qual_titl_rt_f qtr

271: l_dummy varchar2(1);
272: --
273: cursor c1 is
274: select null
275: from ben_qual_titl_rt_f qtr
276: where nvl(qtr.qualification_type_id,-1) = nvl(p_qualification_type_id,-1)
277: and nvl(qtr.title,-1) = nvl(p_title,-1)
278: and qtr.vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
279: and qtr.qual_titl_rt_id <> nvl(p_qual_titl_rt_id,hr_api.g_number)

Line 349: from ben_qual_titl_rt_f

345: is
346: l_proc varchar2(72) := g_package||' chk_duplicate_ordr_num ';
347: l_dummy char(1);
348: cursor c1 is select null
349: from ben_qual_titl_rt_f
350: where vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
351: -- changed against bug: 5113011
352: and qual_titl_rt_id <> nvl(p_qual_titl_rt_id ,-1)
353: -- and qualification_type_id <> nvl(p_qualification_type_id ,-1)

Line 746: ben_qual_titl_rt_f b

742: --
743: cursor csr_leg_code is
744: select a.legislation_code
745: from per_business_groups a,
746: ben_qual_titl_rt_f b
747: where b.qual_titl_rt_id = p_qual_titl_rt_id
748: and a.business_group_id = b.business_group_id;
749: --
750: -- Declare local variables