APPS.IRC_ASG_STATUS_API dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 168: l_per_system_status per_assignment_status_types.per_system_status%type;

164: l_proc varchar2(72) := g_package||'create_irc_asg_status';
165: l_object_version_number number;
166: l_assignment_status_id irc_assignment_statuses.assignment_id%type;
167: l_status_change_date irc_assignment_statuses.status_change_date%type;
168: l_per_system_status per_assignment_status_types.per_system_status%type;
169: l_status_change_by irc_assignment_statuses.status_change_by%type;
170: l_status_change_reason irc_assignment_statuses.status_change_reason%type;
171:
172: --

Line 175: from per_assignment_status_types

171:
172: --
173: cursor c_status_type is
174: select per_system_status
175: from per_assignment_status_types
176: where assignment_status_type_id = p_assignment_status_type_id;
177: cursor c_max_status_change_date is
178: select max(status_change_date)
179: from irc_assignment_statuses