APPS.IRC_SEEKER_VAC_MATCHING_PKG dependencies on IRC_NOTIFICATION_PREFERENCES

Line 21: FROM irc_notification_preferences inp

17: SELECT inp.person_id
18: , per.party_id
19: , to_number(inp.matching_job_freq) show_jobs_since
20: , FND_PROFILE.value_specific('ICX_LANGUAGE',usr.user_id) lang_pref
21: FROM irc_notification_preferences inp
22: , per_all_people_f per
23: , fnd_user usr
24: WHERE inp.matching_jobs = 'Y'
25: AND per.person_id = inp.person_id

Line 246: FROM irc_notification_preferences inp

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

Line 1580: , irc_notification_preferences inp

1576: FROM irc_search_criteria icrit
1577: , per_all_people_f ppf
1578: , irc_posting_contents_tl ipc_tl
1579: --, hr_locations_all loc
1580: , irc_notification_preferences inp
1581: WHERE icrit.object_type = ''WPREF''
1582: AND icrit.object_id = ppf.person_id
1583: AND ipc_tl.posting_content_id = :posting_content_id
1584: AND ipc_tl.language = userenv(''LANG'')