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 536: from per_all_people_f

532: from irc_documents
533: where type = 'RESUME'
534: and party_id =
535: (select party_id
536: from per_all_people_f
537: where person_id = c_person_id
538: and trunc(sysdate) between effective_start_date and effective_end_Date)
539: and end_date is null;
540: cursor getDocIdList(c_personIdIn in number,c_doc_type in varchar2) is

Line 546: from per_all_people_f

542: from irc_documents
543: where type = c_doc_type
544: and party_id =
545: (select party_id
546: from per_all_people_f
547: where person_id = c_personIdIn
548: and trunc(sysdate) between effective_start_date and effective_end_Date)
549: and end_Date is null;
550: cursor getInterViewStatus(c_interviewId in number) is