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 5257: ,per_vacancies pv

5253: cursor csr_dup_apl_vac_with_eot is
5254: select paf.assignment_id
5255: from per_all_assignments_f paf
5256: ,per_applications pa
5257: ,per_vacancies pv
5258: where paf.application_id = pa.application_id
5259: and pa.date_end is null
5260: and paf.vacancy_id = pv.vacancy_id
5261: and paf.person_id = p_person_id

Line 5276: ,per_vacancies pv

5272: cursor csr_dup_apl_vac_without_eot is
5273: select paf.assignment_id
5274: from per_all_assignments_f paf
5275: ,per_applications pa
5276: ,per_vacancies pv
5277: where paf.application_id = pa.application_id
5278: and pa.date_end is null
5279: and paf.vacancy_id = pv.vacancy_id
5280: and paf.person_id = p_person_id

Line 5294: per_vacancies pv

5290: select pa.application_id
5291: from
5292: per_applications pa,
5293: per_all_assignments_f paf,
5294: per_vacancies pv
5295: where
5296: paf.person_id = p_person_id
5297: and paf.vacancy_id = pv.vacancy_id
5298: and paf.vacancy_id = p_vacancy_id

Line 5408: from per_vacancies

5404: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
5405: --
5406: cursor csr_val_vacancy_id is
5407: select business_group_id
5408: from per_vacancies
5409: where vacancy_id = p_vacancy_id
5410: and p_validation_start_date
5411: between date_from
5412: and nvl(date_to, hr_api.g_eot);

Line 5416: from per_vacancies

5412: and nvl(date_to, hr_api.g_eot);
5413: --
5414: cursor csr_val_vacancy_id_offer is
5415: select business_group_id
5416: from per_vacancies
5417: where vacancy_id = p_vacancy_id;
5418: --
5419: begin
5420: hr_utility.set_location('Entering:'|| l_proc, 10);