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_ASG_BUS2 dependencies on PER_VACANCIES

Line 5133: per_vacancies pv

5129: select pa.application_id
5130: from
5131: per_applications pa,
5132: per_all_assignments_f paf,
5133: per_vacancies pv
5134: where
5135: paf.person_id = p_person_id
5136: and paf.vacancy_id = pv.vacancy_id
5137: and paf.vacancy_id = p_vacancy_id

Line 5203: from per_vacancies

5199: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
5200: --
5201: cursor csr_val_vacancy_id is
5202: select business_group_id
5203: from per_vacancies
5204: where vacancy_id = p_vacancy_id
5205: and p_validation_start_date
5206: between date_from
5207: and nvl(date_to, hr_api.g_eot);

Line 5211: from per_vacancies

5207: and nvl(date_to, hr_api.g_eot);
5208: --
5209: cursor csr_val_vacancy_id_offer is
5210: select business_group_id
5211: from per_vacancies
5212: where vacancy_id = p_vacancy_id;
5213: --
5214: begin
5215: hr_utility.set_location('Entering:'|| l_proc, 10);