APPS.IRC_IAS_BUS dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 300: -- in table per_assignment_status_types.

296: -- {Start Of Comments}
297: --
298: -- Description:
299: -- This procedure is used to ensure that assignment status type Id exists
300: -- in table per_assignment_status_types.
301: --
302: -- Pre Conditions:
303: -- assignment status Id should exist in the table.
304: --

Line 327: from PER_ASSIGNMENT_STATUS_TYPES

323: l_asg_status_type_id irc_assignment_statuses.assignment_status_type_id%type;
324: --
325: cursor csr_exists is
326: select 1
327: from PER_ASSIGNMENT_STATUS_TYPES
328: where ASSIGNMENT_STATUS_TYPE_ID = P_ASG_STATUS_TYPE_ID;
329: --
330: begin
331: hr_utility.set_location('Entering:'|| l_proc, 10);