APPS.HR_EMPLOYEE_APPLICANT_API dependencies on DUAL

Line 893: select 1 from dual where exists

889: where asg.vacancy_id=p_vacancy_id
890: and asg.assignment_type='E');
891: --
892: cursor csr_future_per_changes(p_effective_date DATE) is
893: select 1 from dual where exists
894: (select 1
895: from per_all_people_f
896: where person_id = p_person_id
897: and effective_start_date >= p_effective_date);

Line 3729: SELECT per_applications_s.nextval into l_new_application_id FROM sys.dual;

3725: fetch chk_apl_exists into l_cur_apl_id, l_current_apl_end_date;
3726: if chk_apl_exists%notfound then
3727:
3728: -- creating APLN since not found
3729: SELECT per_applications_s.nextval into l_new_application_id FROM sys.dual;
3730: l_cur_apl_id := l_new_application_id;
3731: begin
3732: INSERT INTO PER_APPLICATIONS(
3733: application_id,

Line 4478: select 'X' from dual where exists

4474: --- SSHR Enhancement (Bug # 8536819)---
4475: ---Cursor to find if there are any other applications other than the one
4476: ---into which we are hiring.
4477: cursor csr_get_all_appl_asgs is
4478: select 'X' from dual where exists
4479: ( select *
4480: from per_assignments_f asg,
4481: per_assignment_status_types pas
4482: where asg.assignment_status_type_id = pas.assignment_status_type_id

Line 6574: SELECT per_applications_s.nextval into l_new_application_id FROM sys.dual;

6570: fetch chk_apl_exists into l_cur_apl_id, l_current_apl_end_date;
6571: if chk_apl_exists%notfound then
6572:
6573: -- creating APLN since not found
6574: SELECT per_applications_s.nextval into l_new_application_id FROM sys.dual;
6575: l_cur_apl_id := l_new_application_id;
6576: begin
6577: INSERT INTO PER_APPLICATIONS(
6578: application_id,