APPS.IRC_VACANCY_APPROVALS dependencies on PER_ALL_VACANCIES

Line 219: from per_all_vacancies

215: --
216: l_retval varchar2(30);
217: cursor get_old_id(p_vacancy_id number) is
218: select organization_id
219: from per_all_vacancies
220: where vacancy_id=p_vacancy_id;
221: begin
222: --
223: irc_vacancy_approvals.show('Entering get_vac_organization_changed');

Line 264: from per_all_vacancies

260: --
261: l_retval varchar2(30);
262: cursor get_old_id(p_vacancy_id number) is
263: select job_id
264: from per_all_vacancies
265: where vacancy_id=p_vacancy_id;
266: begin
267: --
268: irc_vacancy_approvals.show('Entering get_vac_job_changed');

Line 307: from per_all_vacancies

303: --
304: l_retval varchar2(30);
305: cursor get_old_id(p_vacancy_id number) is
306: select grade_id
307: from per_all_vacancies
308: where vacancy_id=p_vacancy_id;
309: begin
310: --
311: irc_vacancy_approvals.show('Entering get_vac_grade_changed');

Line 353: from per_all_vacancies

349: --
350: l_retval varchar2(30);
351: cursor get_old_id(p_vacancy_id number) is
352: select position_id
353: from per_all_vacancies
354: where vacancy_id=p_vacancy_id;
355: begin
356: --
357: irc_vacancy_approvals.show('Entering get_vac_position_changed');

Line 399: from per_all_vacancies

395: --
396: l_retval varchar2(30);
397: cursor get_old_id(p_vacancy_id number) is
398: select fnd_number.number_to_canonical(budget_measurement_value)
399: from per_all_vacancies
400: where vacancy_id=p_vacancy_id;
401: begin
402: --
403: irc_vacancy_approvals.show('Entering get_vac_budget_value_changed');

Line 445: from per_all_vacancies

441: --
442: l_retval varchar2(30);
443: cursor get_old_value(p_vacancy_id number) is
444: select budget_measurement_type
445: from per_all_vacancies
446: where vacancy_id=p_vacancy_id;
447: begin
448: --
449: irc_vacancy_approvals.show('Entering get_vac_budget_type_changed');

Line 491: from per_all_vacancies

487: --
488: l_retval varchar2(30);
489: cursor get_old_value(p_vacancy_id number) is
490: select status
491: from per_all_vacancies
492: where vacancy_id=p_vacancy_id;
493: begin
494: --
495: irc_vacancy_approvals.show('Entering get_vac_status_changed');