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.HRI_OPL_REC_VAC dependencies on PER_ALL_VACANCIES

Line 480: per_all_vacancies vac

476: ,fnd_global.user_id
477: ,fnd_global.user_id
478: ,sysdate
479: FROM
480: per_all_vacancies vac
481: ,per_requisitions req
482: WHERE vac.last_update_date BETWEEN g_start_date AND g_end_date
483: AND vac.requisition_id = req.requisition_id
484: AND NOT EXISTS (SELECT 'x'

Line 552: per_all_vacancies vac

548: ,fnd_global.user_id
549: ,fnd_global.user_id
550: ,sysdate
551: FROM
552: per_all_vacancies vac
553: ,per_requisitions req
554: WHERE vac.last_update_date BETWEEN g_start_date
555: AND g_end_date
556: AND req.requisition_id = vac.requisition_id

Line 562: FROM per_all_vacancies vac

558: )
559: WHERE (tbl.rvac_vacncy_fk)
560: IN
561: (SELECT vac.vacancy_id
562: FROM per_all_vacancies vac
563: WHERE vac.last_update_date BETWEEN g_start_date
564: AND g_end_date);
565:
566: --

Line 578: FROM per_all_vacancies vac

574: FROM hri_mb_rec_vacancy_ct tbl
575: WHERE tbl.rvac_vacncy_fk > 0
576: AND NOT EXISTS
577: (SELECT 'x'
578: FROM per_all_vacancies vac
579: WHERE vac.vacancy_id = tbl.rvac_vacncy_fk);
580:
581:
582: -- log('Delete >'||TO_CHAR(sql%rowcount));

Line 642: per_all_vacancies vac

638: ,vac.vacancy_category
639: ,sysdate
640: ,fnd_global.user_id
641: FROM
642: per_all_vacancies vac
643: ,per_requisitions req
644: WHERE req.requisition_id = vac.requisition_id;
645:
646: --