DBA Data[Home] [Help]

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,