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 412: from irc_assignment_statuses ias1

408: --
409: cursor csr_prev_assg_status_type(p_business_group_id number) is
410: select ias1.assignment_status_type_id
411: ,past.per_system_status
412: from irc_assignment_statuses ias1
413: ,per_assignment_status_types past
414: where past.assignment_status_type_id = ias1.assignment_status_type_id
415: and ias1.assignment_id = p_applicant_assignment_id
416: and ias1.creation_date = (select max(ias2.creation_date)

Line 417: from irc_assignment_statuses ias2

413: ,per_assignment_status_types past
414: where past.assignment_status_type_id = ias1.assignment_status_type_id
415: and ias1.assignment_id = p_applicant_assignment_id
416: and ias1.creation_date = (select max(ias2.creation_date)
417: from irc_assignment_statuses ias2
418: where ias2.assignment_id = p_applicant_assignment_id
419: and ias2.assignment_status_type_id not in (5,6)
420: and ias2.assignment_status_type_id not in (select ASSIGNMENT_STATUS_TYPE_ID
421: from PER_ASSIGNMENT_STATUS_TYPES_V