APPS.BEN_EES_BUS dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 126: from per_assignment_status_types a

122: --
123: --
124: cursor c1 is
125: select per_system_status
126: from per_assignment_status_types a
127: where a.assignment_status_type_id = p_assignment_status_type_id;
128: --
129: -- additional check for business_group_id should be made against
130: -- per_ass_status_type_amends

Line 192: -- check if assignment_status_type_id value exists in per_assignment_status_types table

188: and p_assignment_status_type_id
189: <> nvl(ben_ees_shd.g_old_rec.assignment_status_type_id,hr_api.g_number)
190: or not l_api_updating) then
191: --
192: -- check if assignment_status_type_id value exists in per_assignment_status_types table
193: --
194: open c1;
195: --
196: fetch c1 into l_per_system_status;

Line 201: -- raise error as FK does not relate to PK in per_assignment_status_types

197: if c1%notfound then
198: --
199: close c1;
200: --
201: -- raise error as FK does not relate to PK in per_assignment_status_types
202: -- table.
203: --
204: ben_ees_shd.constraint_error('BEN_ELIG_EE_STAT_FK2');
205: --