APPS.IRC_NOTIFICATION_DATA_PKG dependencies on PER_ALL_VACANCIES

Line 125: from per_all_vacancies

121: , p_effectiveDate in date) return number as
122: cursor csrManagerId(c_vacancyId in number
123: ,c_effectiveDate in date) is
124: select manager_id
125: from per_all_vacancies
126: where vacancy_id = c_vacancyId
127: and trunc(c_effectiveDate)
128: between trunc(date_from) and nvl(trunc(date_to),to_date('31-12-4712','DD-MM-RRRR'));
129: l_managerId number;

Line 197: from per_all_vacancies pav,

193: || ipc.name
194: || ';IRC_RECRUITING_SITE_ID:'
195: || pra.recruiting_site_id
196: ||';'
197: from per_all_vacancies pav,
198: per_jobs pj,
199: hr_all_positions_f pp,
200: per_recruitment_activities pra,
201: irc_posting_contents_vl ipc