APPS.PER_PEOPLE12_PKG dependencies on PER_APPLICATIONS_S
Line 992: SELECT per_applications_s.nextval into l_new_application_id FROM sys.dual;
988: fetch chk_apl_exists into l_cur_apl_id, l_current_apl_end_date;
989:
990: -- if application not found create a new application
991: if chk_apl_exists%notfound then 992: SELECT per_applications_s.nextval into l_new_application_id FROM sys.dual; 993: l_cur_apl_id := l_new_application_id;
994: begin
995: INSERT INTO PER_APPLICATIONS(
996: application_id,