DBA Data[Home] [Help]

APPS.HR_APPLICANT_API dependencies on DUAL

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

2875: fetch chk_apl_exists into l_cur_apl_id, l_current_apl_end_date;
2876: if chk_apl_exists%notfound then
2877:
2878: -- creating APLN since not found
2879: SELECT per_applications_s.nextval into l_new_application_id FROM sys.dual;
2880: l_cur_apl_id := l_new_application_id;
2881: begin
2882: INSERT INTO PER_APPLICATIONS(
2883: application_id,