APPS.IRC_PENDING_DATA_API dependencies on DUAL

Line 1209: select per_people_s.nextval into l_applicant_person_id from dual;

1205: into l_applicant_person_id
1206: ,l_appl_ovn
1207: ,l_emp_number;
1208: if csr_get_person_id_in_vac_bg%notfound then
1209: select per_people_s.nextval into l_applicant_person_id from dual;
1210: -- fix for bug 4018218
1211: -- make this value as NULL because we are in a loop and if in the
1212: -- first loop we have a valid value and in second loop we have to
1213: -- clear it otherwise we send the value in first loop

Line 1224: select per_assignments_s.nextval into l_applicant_assg_id from dual;

1220: after applying the processed flag is changed to 'A' so that if process
1221: run again 'A' rows won't be picked up.
1222: these API calls are present in PerAllPeopleFEOImpl.java */
1223:
1224: select per_assignments_s.nextval into l_applicant_assg_id from dual;
1225:
1226: hr_utility.set_location(l_proc, 80);
1227:
1228: l_per_ovn := null;