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_SEEKER_VAC_MATCHING_PKG dependencies on IRC_NOTIFICATION_PREFERENCES

Line 20: FROM irc_notification_preferences inp

16: IS
17: SELECT inp.person_id
18: , per.party_id
19: , to_number(inp.matching_job_freq) show_jobs_since
20: FROM irc_notification_preferences inp
21: , per_all_people_f per
22: WHERE inp.matching_jobs='Y'
23: and per.person_id=inp.person_id
24: and trunc(sysdate) between per.effective_start_date and per.effective_end_date

Line 243: FROM irc_notification_preferences inp

239: per.person_id
240: , per.email_address
241: , per.first_name
242: , per.last_name
243: FROM irc_notification_preferences inp
244: , per_all_people_f per
245: WHERE inp.person_id = per.person_id
246: and inp.receive_info_mail ='Y'
247: and trunc(sysdate) between per.effective_start_date and per.effective_end_date;

Line 1400: , irc_notification_preferences inp

1396: irc_search_criteria icrit
1397: , per_all_people_f ppf
1398: , irc_posting_contents_tl ipc_tl
1399: , hr_locations_all loc
1400: , irc_notification_preferences inp
1401: WHERE icrit.object_type =''WPREF''
1402: AND icrit.object_id = ppf.person_id
1403: AND ipc_tl.posting_content_id = :posting_content_id
1404: AND ipc_tl.language=userenv(''LANG'')