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 549: from per_assignments pa, per_all_vacancies pav

545: --
546: cursor app_ass(p_last_vacancy number) is
547: select pav.vacancy_id,pav.name
548: ,pa.assignment_id -- #2381925
549: from per_assignments pa, per_all_vacancies pav
550: , per_assignment_status_types pas
551: where person_id = p_person_id
552: and pav.vacancy_id = pa.vacancy_id
553: and pa.assignment_status_type_id = pas.assignment_status_type_id

Line 579: from per_all_vacancies pav

575: if hr_employee_applicant_api.is_convert(p_table,l_asg_id) then
576:
577: select vacancy_id
578: into l_dummy_id
579: from per_all_vacancies pav
580: where pav.number_of_openings <
581: (select count(distinct assignment_id) + 1
582: from per_all_assignments_f paf
583: where paf.vacancy_id = pav.vacancy_id