APPS.HR_EMPLOYEE_APPLICANT_API dependencies on DUAL
Line 842: select 1 from dual where exists
838: where asg.vacancy_id=p_vacancy_id
839: and asg.assignment_type='E');
840: --
841: cursor csr_future_per_changes(p_effective_date DATE) is 842: select 1 from dual where exists 843: (select 1
844: from per_all_people_f
845: where person_id = p_person_id
846: and effective_start_date >= p_effective_date);