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_IPD_BUS dependencies on PER_ALL_VACANCIES

Line 343: -- per_all_vacancies and is valid on creation_date.

339: -- {Start Of Comments}
340: --
341: -- Description:
342: -- This procedure is used to ensure that vacancy_id exists in
343: -- per_all_vacancies and is valid on creation_date.
344: --
345: -- Pre Conditions:
346: -- g_old_rec has been populated with details of the values currently in
347: -- the database.

Line 373: from per_all_vacancies

369: l_num number;
370: --
371: cursor csr_vacancy_id is
372: select 1
373: from per_all_vacancies
374: where vacancy_id = p_vacancy_id
375: and nvl(date_to,hr_api.g_eot) >= p_creation_date
376: and date_from <= p_creation_date;
377: --