DBA Data[Home] [Help]

APPS.BEN_ELS_BUS dependencies on BEN_LOS_FCTR

Line 133: from ben_los_fctr a

129: --
130: --
131: cursor c1 is
132: select null
133: from ben_los_fctr a
134: where a.los_fctr_id = p_los_fctr_id
135: and a.business_group_id + 0 = p_business_group_id;
136: --
137: Begin

Line 151: -- check if los_fctr_id value exists in ben_los_fctr table

147: and nvl(p_los_fctr_id,hr_api.g_number)
148: <> nvl(ben_els_shd.g_old_rec.los_fctr_id,hr_api.g_number)
149: or not l_api_updating) then
150: --
151: -- check if los_fctr_id value exists in ben_los_fctr table
152: --
153: open c1;
154: --
155: fetch c1 into l_dummy;

Line 160: -- raise error as FK does not relate to PK in ben_los_fctr

156: if c1%notfound then
157: --
158: close c1;
159: --
160: -- raise error as FK does not relate to PK in ben_los_fctr
161: -- table.
162: --
163: ben_els_shd.constraint_error('BEN_ELIG_LOS_PRTE_FK1');
164: --