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_REQUISITIONS

Line 481: ,per_requisitions req

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'
485: FROM hri_mb_rec_vacancy_ct tbl

Line 553: ,per_requisitions req

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
557: AND vac.vacancy_id = tbl.rvac_vacncy_fk

Line 643: ,per_requisitions req

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: --
647: -- @@Code specific to this view/table below ENDS