APPS.BEN_QIG_BUS dependencies on BEN_QUA_IN_GR_RT_F

Line 65: ben_qig_shd.constraint_error('BEN_QUA_IN_GR_RT_F_PK');

61: <> ben_qig_shd.g_old_rec.qua_in_gr_rt_id) then
62: --
63: -- raise error as PK has changed
64: --
65: ben_qig_shd.constraint_error('BEN_QUA_IN_GR_RT_F_PK');
66: --
67: elsif not l_api_updating then
68: --
69: -- check if PK is null

Line 75: ben_qig_shd.constraint_error('BEN_QUA_IN_GR_RT_F_PK');

71: if p_qua_in_gr_rt_id is not null then
72: --
73: -- raise error as PK is not null
74: --
75: ben_qig_shd.constraint_error('BEN_QUA_IN_GR_RT_F_PK');
76: --
77: end if;
78: --
79: end if;

Line 138: from ben_qua_in_gr_rt_f

134: and h1.enabled_flag = 'Y';
135: --
136: cursor c3 is
137: select null
138: from ben_qua_in_gr_rt_f
139: where quar_in_grade_cd = p_quar_in_grade_cd
140: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
141: and qua_in_gr_rt_id <> nvl(p_qua_in_gr_rt_id,hr_api.g_number)
142: and business_group_id + 0 = p_business_group_id

Line 173: ben_qig_shd.constraint_error('BEN_QUA_IN_GR_RT_FK2');

169: --
170: -- raise error as FK does not relate to PK
171: -- table.
172: --
173: ben_qig_shd.constraint_error('BEN_QUA_IN_GR_RT_FK2');
174: --
175: end if;
176: --
177: close c1;

Line 284: , ben_qua_in_gr_rt_f qig

280: --
281: cursor csr_sec_grp is
282: select pbg.security_group_id
283: from per_business_groups pbg
284: , ben_qua_in_gr_rt_f qig
285: where qig.qua_in_gr_rt_id = p_qua_in_gr_rt_id
286: and pbg.business_group_id = qig.business_group_id;
287: --
288: -- Declare local variables

Line 348: , ben_qua_in_gr_rt_f qig

344: --
345: cursor csr_leg_code is
346: select pbg.legislation_code
347: from per_business_groups pbg
348: , ben_qua_in_gr_rt_f qig
349: where qig.qua_in_gr_rt_id = p_qua_in_gr_rt_id
350: and pbg.business_group_id = qig.business_group_id;
351: --
352: -- Declare local variables

Line 516: ,p_descflex_name => 'BEN_QUA_IN_GR_RT_F'

512: -- b) During insert.
513: --
514: hr_dflex_utility.ins_or_upd_descflex_attribs
515: (p_appl_short_name => 'BEN'
516: ,p_descflex_name => 'BEN_QUA_IN_GR_RT_F'
517: ,p_attribute_category => 'QIG_ATTRIBUTE_CATEGORY'
518: ,p_attribute1_name => 'QIG_ATTRIBUTE1'
519: ,p_attribute1_value => p_rec.qig_attribute1
520: ,p_attribute2_name => 'QIG_ATTRIBUTE2'

Line 678: from ben_qua_in_gr_rt_f

674: is
675: l_proc varchar2(72) := g_package||' chk_duplicate_ordr_num ';
676: l_dummy char(1);
677: cursor c1 is select null
678: from ben_qua_in_gr_rt_f
679: where vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
680: -- changed against bug: 5113011
681: and qua_in_gr_rt_id <> nvl(p_qua_in_gr_rt_id ,-1)
682: -- and quar_in_grade_cd <> nvl(p_quar_in_grade_cd ,-1)