DBA Data[Home] [Help]

APPS.IRC_SEEKER_VAC_MATCHING_PKG dependencies on FND_USER

Line 23: , fnd_user usr

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
26: AND trunc(sysdate) between per.effective_start_date and per.effective_end_date
27: AND (mod (trunc(sysdate) - trunc(inp.last_update_date)