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

Line 653: from per_assignments pa, per_all_vacancies pav

649: --
650: cursor app_ass(p_last_vacancy number) is
651: select pav.vacancy_id,pav.name
652: ,pa.assignment_id -- #2381925
653: from per_assignments pa, per_all_vacancies pav
654: , per_assignment_status_types pas
655: where person_id = p_person_id
656: and pav.vacancy_id = pa.vacancy_id
657: and pa.assignment_status_type_id = pas.assignment_status_type_id

Line 683: from per_all_vacancies pav

679: if hr_employee_applicant_api.is_convert(p_table,l_asg_id) then
680:
681: select vacancy_id
682: into l_dummy_id
683: from per_all_vacancies pav
684: where pav.number_of_openings <
685: (select count(distinct assignment_id) + 1
686: from per_all_assignments_f paf
687: where paf.vacancy_id = pav.vacancy_id