APPS.IRC_NOTIFICATION_DATA_PKG dependencies on PER_ALL_VACANCIES

Line 137: from per_all_vacancies

133: , p_effectiveDate in date) return number as
134: cursor csrManagerId(c_vacancyId in number
135: ,c_effectiveDate in date) is
136: select manager_id
137: from per_all_vacancies
138: where vacancy_id = c_vacancyId
139: and trunc(c_effectiveDate)
140: between trunc(date_from) and nvl(trunc(date_to),to_date('31-12-4712','DD-MM-RRRR'));
141: l_managerId number;

Line 209: from per_all_vacancies pav,

205: || ipc.name
206: || ';IRC_RECRUITING_SITE_ID:'
207: || pra.recruiting_site_id
208: ||';'
209: from per_all_vacancies pav,
210: per_jobs pj,
211: hr_all_positions_f pp,
212: per_recruitment_activities pra,
213: irc_posting_contents_vl ipc