APPS.IRC_PENDING_DATA_API dependencies on PER_PEOPLE_S

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