DBA Data[Home] [Help]

APPS.BEN_BTR_BUS dependencies on BEN_COMP_LVL_FCTR

Line 116: from ben_comp_lvl_fctr a

112: l_dummy varchar2(1);
113: --
114: cursor c1 is
115: select null
116: from ben_comp_lvl_fctr a
117: where a.comp_lvl_fctr_id = p_comp_lvl_fctr_id;
118: --
119: Begin
120: --

Line 133: -- check if comp_lvl_fctr_id value exists in ben_comp_lvl_fctr table

129: and nvl(p_comp_lvl_fctr_id,hr_api.g_number)
130: <> nvl(ben_btr_shd.g_old_rec.comp_lvl_fctr_id,hr_api.g_number)
131: or not l_api_updating) then
132: --
133: -- check if comp_lvl_fctr_id value exists in ben_comp_lvl_fctr table
134: --
135: open c1;
136: --
137: fetch c1 into l_dummy;

Line 142: -- raise error as FK does not relate to PK in ben_comp_lvl_fctr

138: if c1%notfound then
139: --
140: close c1;
141: --
142: -- raise error as FK does not relate to PK in ben_comp_lvl_fctr
143: -- table.
144: --
145: ben_btr_shd.constraint_error('BEN_COMP_LVL_ACTY_RT_FK2');
146: --