DBA Data[Home] [Help]

APPS.FA_STANDARD_DDL_PKG dependencies on ALL_SEQUENCES

Line 34: from all_sequences

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

Line 60: from all_sequences

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