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_PENDING_DATA_API dependencies on IRC_ASSIGNMENT_STATUSES

Line 931: irc_assignment_statuses ias,

927: select 1
928: from per_all_assignments_f asg,
929: per_assignment_status_types_v ast,
930: per_all_people_f ppf,
931: irc_assignment_statuses ias,
932: per_all_people_f linkppf,
933: per_assignment_status_types_v ast1
934: where asg.vacancy_id = p_vacancy_id
935: and asg.effective_start_date=(select max(effective_start_date)

Line 945: from irc_assignment_statuses inn

941: and linkppf.person_id = p_person_id
942: and asg.assignment_id = ias.assignment_id
943: and asg.assignment_status_type_id = ast1.assignment_status_type_id
944: and (ias.assignment_status_id = (select max(inn.assignment_status_id)
945: from irc_assignment_statuses inn
946: where inn.assignment_id = asg.assignment_id)
947: or ias.assignment_status_id is null)
948: and ias.assignment_status_type_id = ast.assignment_status_type_id
949: and ppf.party_id = linkppf.party_id