eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IRC_OFFERS_API dependencies on IRC_ASSIGNMENT_STATUSES

Line 393: from irc_assignment_statuses ias1

389: --
390: cursor csr_prev_assg_status_type is
391: select ias1.assignment_status_type_id
392: ,past.per_system_status
393: from irc_assignment_statuses ias1
394: ,per_assignment_status_types past
395: where past.assignment_status_type_id = ias1.assignment_status_type_id
396: and ias1.assignment_id = p_applicant_assignment_id
397: and ias1.creation_date = (select max(ias2.creation_date)

Line 398: from irc_assignment_statuses ias2

394: ,per_assignment_status_types past
395: where past.assignment_status_type_id = ias1.assignment_status_type_id
396: and ias1.assignment_id = p_applicant_assignment_id
397: and ias1.creation_date = (select max(ias2.creation_date)
398: from irc_assignment_statuses ias2
399: where ias2.assignment_id = p_applicant_assignment_id
400: and ias2.assignment_status_type_id not in (5,6));
401: --
402: Begin