DBA Data[Home] [Help]

APPS.BEN_EAN_BUS dependencies on HR_ASSIGNMENT_SETS

Line 121: from hr_assignment_sets a

117: l_exists varchar2(1);
118: --
119: cursor c1 is
120: select null
121: from hr_assignment_sets a
122: where a.assignment_set_id = p_assignment_set_id
123: and a.business_group_id + 0 = p_business_group_id;
124: --
125: --

Line 152: -- check if assignment_set_id value exists in hr_assignment_sets table

148: and nvl(p_assignment_set_id,hr_api.g_number)
149: <> nvl(ben_ean_shd.g_old_rec.assignment_set_id,hr_api.g_number)
150: or not l_api_updating) then
151: --
152: -- check if assignment_set_id value exists in hr_assignment_sets table
153: --
154: open c1;
155: --
156: fetch c1 into l_dummy;

Line 161: -- raise error as FK does not relate to PK in hr_assignment_sets

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