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_NOTIFICATION_WORKFLOW_PKG dependencies on PER_ALL_PEOPLE_F

Line 351: from per_all_people_f

347: from irc_documents
348: where type = 'RESUME'
349: and party_id =
350: (select party_id
351: from per_all_people_f
352: where person_id = c_person_id
353: and trunc(sysdate) between effective_start_date and effective_end_Date)
354: and end_date is null;
355: cursor getDocIdList(c_personIdIn in number,c_doc_type in varchar2) is

Line 361: from per_all_people_f

357: from irc_documents
358: where type = c_doc_type
359: and party_id =
360: (select party_id
361: from per_all_people_f
362: where person_id = c_personIdIn
363: and trunc(sysdate) between effective_start_date and effective_end_Date)
364: and end_Date is null;
365: cursor getInterViewStatus(c_interviewId in number) is