DBA Data[Home] [Help]

APPS.PER_VACANCY_API dependencies on PER_ALL_VACANCIES

Line 431: per_all_vacancies pav

427: l_temp_ovn number := P_OBJECT_VERSION_NUMBER;
428: cursor csr_asg is
429: select assignment_id,paf.object_version_number
430: from per_all_assignments_f paf,
431: per_all_vacancies pav
432: where paf.vacancy_id = p_vacancy_id
433: and paf.vacancy_id = pav.vacancy_id
434: and paf.assignment_type = 'A';
435: begin