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.

[Home] [Help]

APPS.HR_EMPLOYEE_APPLICANT_API dependencies on PER_ALL_VACANCIES

Line 884: from per_all_vacancies vac

880: l_dummy number;
881: --
882: cursor csr_vacs(p_vacancy_id number) is
883: select 1
884: from per_all_vacancies vac
885: where vac.vacancy_id=p_vacancy_id
886: and vac.number_of_openings <
887: (select count(distinct assignment_id)
888: from per_all_assignments_f asg

Line 1932: from per_all_vacancies vac

1928: l_primary_cag_rec per_cagr_grades_def%rowtype;
1929: --
1930: cursor csr_vacs(p_vacancy_id number) is
1931: select 1
1932: from per_all_vacancies vac
1933: where vac.vacancy_id=p_vacancy_id
1934: and vac.number_of_openings <
1935: (select count(distinct assignment_id)
1936: from per_all_assignments_f asg

Line 4413: from per_all_vacancies vac

4409: l_primary_cag_rec per_cagr_grades_def%rowtype;
4410: --
4411: cursor csr_vacs(p_vacancy_id number) is
4412: select 1
4413: from per_all_vacancies vac
4414: where vac.vacancy_id=p_vacancy_id
4415: and vac.number_of_openings <
4416: (select count(distinct assignment_id)
4417: from per_all_assignments_f asg