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_PARTY_API dependencies on IRC_OFFER_STATUS_HISTORY

Line 5673: irc_offer_status_history history

5669: select paf.assignment_id
5670: from per_all_people_f ppf,
5671: per_all_assignments_f paf,
5672: irc_offers iof,
5673: irc_offer_status_history history
5674: where ppf.party_id = p_party_id
5675: and trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date
5676: and paf.person_id = ppf.person_id
5677: and paf.assignment_type = 'O'

Line 5683: FROM irc_offer_status_history iosh1

5679: and iof.LATEST_OFFER = 'Y'
5680: AND history.offer_id = iof.offer_id
5681: and not exists
5682: (SELECT 1
5683: FROM irc_offer_status_history iosh1
5684: WHERE iosh1.offer_id = HISTORY.offer_id
5685: AND iosh1.status_change_date > HISTORY.status_change_date
5686: )
5687: AND HISTORY.offer_status_history_id =

Line 5689: FROM irc_offer_status_history iosh2

5685: AND iosh1.status_change_date > HISTORY.status_change_date
5686: )
5687: AND HISTORY.offer_status_history_id =
5688: (SELECT MAX(iosh2.offer_status_history_id)
5689: FROM irc_offer_status_history iosh2
5690: WHERE iosh2.offer_id = HISTORY.offer_id
5691: AND iosh2.status_change_date = HISTORY.status_change_date
5692: )
5693: and (iof.OFFER_STATUS <> 'CLOSED' OR (iof.OFFER_STATUS = 'CLOSED' AND HISTORY.change_reason ='APL_ACCEPTED'));