DBA Data[Home] [Help]

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);