APPS.BEN_CTY_BUS dependencies on BEN_COMPTNCY_RT_F

Line 65: ben_cty_shd.constraint_error('BEN_COMPTNCY_RT_F_PK');

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

Line 75: ben_cty_shd.constraint_error('BEN_COMPTNCY_RT_F_PK');

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

Line 137: from ben_comptncy_rt_f

133: nvl(a.date_to, p_effective_date);
134: --
135: cursor c3 is
136: select null
137: from ben_comptncy_rt_f
138: where competence_id = p_competence_id
139: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
140: -- changed for Bug 5078478 .. change the commented query to the new one
141: -- and vrbl_rt_prfl_id <> nvl(p_comptncy_rt_id,hr_api.g_number)

Line 175: ben_cty_shd.constraint_error('BEN_COMPTNCY_RT_FK2');

171: --
172: -- raise error as FK does not relate to PK in per_jobs
173: -- table.
174: --
175: ben_cty_shd.constraint_error('BEN_COMPTNCY_RT_FK2');
176: --
177: end if;
178: --
179: close c1;

Line 262: from ben_comptncy_rt_f

258: and nvl(b.business_group_id , p_business_group_id) = p_business_group_id;
259: --
260: cursor c3 is
261: select null
262: from ben_comptncy_rt_f
263: where competence_id = p_competence_id
264: and rating_level_id = p_rating_level_id
265: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
266: -- changed for Bug 5078478 .. change the commented query to the new one

Line 301: ben_cty_shd.constraint_error('BEN_COMPTNCY_RT_FK2');

297: --
298: -- raise error as FK does not relate to PK in per_jobs
299: -- table.
300: --
301: ben_cty_shd.constraint_error('BEN_COMPTNCY_RT_FK2');
302: --
303: end if;
304: --
305: close c1;

Line 439: from ben_comptncy_rt_f

435: is
436: l_proc varchar2(72) := g_package||' chk_duplicate_ordr_num ';
437: l_dummy char(1);
438: cursor c1 is select null
439: from ben_comptncy_rt_f
440: where vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
441: -- changed against bug: 5113011
442: and comptncy_rt_id <> nvl(p_comptncy_rt_id,-1)
443: -- and p_competence_id <> nvl(p_p_competence_id ,-1)

Line 482: , ben_comptncy_rt_f cty

478: --
479: cursor csr_sec_grp is
480: select pbg.security_group_id
481: from per_business_groups pbg
482: , ben_comptncy_rt_f cty
483: where cty.comptncy_rt_id = p_comptncy_rt_id
484: and pbg.business_group_id = cty.business_group_id;
485: --
486: -- Declare local variables

Line 546: , ben_comptncy_rt_f cty

542: --
543: cursor csr_leg_code is
544: select pbg.legislation_code
545: from per_business_groups pbg
546: , ben_comptncy_rt_f cty
547: where cty.comptncy_rt_id = p_comptncy_rt_id
548: and pbg.business_group_id = cty.business_group_id;
549: --
550: -- Declare local variables

Line 714: ,p_descflex_name => 'BEN_comptncy_rt_F'

710: -- b) During insert.
711: --
712: hr_dflex_utility.ins_or_upd_descflex_attribs
713: (p_appl_short_name => 'BEN'
714: ,p_descflex_name => 'BEN_comptncy_rt_F'
715: ,p_attribute_category => 'cty_ATTRIBUTE_CATEGORY'
716: ,p_attribute1_name => 'cty_ATTRIBUTE1'
717: ,p_attribute1_value => p_rec.cty_attribute1
718: ,p_attribute2_name => 'cty_ATTRIBUTE2'