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_VAC_BUS dependencies on PER_ALL_ASSIGNMENTS_F

Line 1269: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE

1265: (p_vacancy_id in per_all_vacancies.vacancy_id%TYPE
1266: ,p_job_id in per_all_vacancies.job_id%TYPE
1267: ,p_grade_id in per_all_vacancies.grade_id%TYPE
1268: ,p_effective_date in date
1269: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
1270: ,p_inv_job_grade_warning out nocopy boolean
1271: )
1272: is
1273: --

Line 2051: from per_all_assignments_f paf,per_all_people_f ppf

2047: l_api_updating boolean;
2048: --
2049: cursor csr_manager is
2050: select null
2051: from per_all_assignments_f paf,per_all_people_f ppf
2052: where paf.vacancy_id = p_vacancy_id
2053: and ppf.person_id = paf.person_id
2054: and trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date
2055: and ppf.party_id = (select ppf.party_id