APPS.AMS_LISTHEADER_PVT dependencies on AMS_LIST_HEADERS_ALL_S

Line 879: SELECT ams_list_headers_all_s.nextval

875: WHERE LIST_HEADER_ID = p_list_header_id;
876:
877: -- list header sequence #
878: CURSOR listheader_seq IS
879: SELECT ams_list_headers_all_s.nextval
880: FROM DUAL;
881:
882: BEGIN
883:

Line 1209: SELECT ams_list_headers_all_s.NEXTVAL

1205: l_list_count NUMBER;
1206: l_main_gen_time DATE := null;
1207:
1208: CURSOR c_list_seq IS
1209: SELECT ams_list_headers_all_s.NEXTVAL
1210: FROM DUAL;
1211:
1212: CURSOR c_list_count(p_list_header_id IN NUMBER) IS
1213: SELECT COUNT(*)