APPS.IRC_IAS_BUS dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 346: -- in table per_assignment_status_types.

342: -- {Start Of Comments}
343: --
344: -- Description:
345: -- This procedure is used to ensure that assignment status type Id exists
346: -- in table per_assignment_status_types.
347: --
348: -- Pre Conditions:
349: -- assignment status Id should exist in the table.
350: --

Line 373: from PER_ASSIGNMENT_STATUS_TYPES

369: l_asg_status_type_id irc_assignment_statuses.assignment_status_type_id%type;
370: --
371: cursor csr_exists is
372: select 1
373: from PER_ASSIGNMENT_STATUS_TYPES
374: where ASSIGNMENT_STATUS_TYPE_ID = P_ASG_STATUS_TYPE_ID;
375: --
376: begin
377: hr_utility.set_location('Entering:'|| l_proc, 10);