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 1212: SELECT ams_list_headers_all_s.NEXTVAL

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