DBA Data[Home] [Help]

APPS.FA_STANDARD_DDL_PKG dependencies on ALL_SEQUENCES

Line 35: from all_sequences

31: raise schema_err;
32: end if;
33:
34: select count(*) into L_count
35: from all_sequences
36: where sequence_name = X_name
37: and sequence_owner = l_schema;
38:
39: if L_count > 0 then

Line 61: from all_sequences

57: to_char(X_max_num) ||
58: ' ORDER',X_name);
59:
60: select last_number into L_chkLastNumber
61: from all_sequences
62: where sequence_name = X_name
63: and sequence_owner = l_schema;
64:
65: if (L_chkLastNumber <> X_start_num) then