DBA Data[Home] [Help]

APPS.OEONUM dependencies on ALL_SEQUENCES

Line 37: SELECT 'X' into dummy FROM ALL_SEQUENCES

33: BEGIN
34:
35: BEGIN
36:
37: SELECT 'X' into dummy FROM ALL_SEQUENCES
38: WHERE SEQUENCE_NAME = sequence_name and rownum=1;
39:
40:
41: EXCEPTION

Line 331: SELECT LAST_NUMBER into sequence_number FROM ALL_SEQUENCES

327:
328: BEGIN
329: l_sequence_name := sequence_name;
330:
331: SELECT LAST_NUMBER into sequence_number FROM ALL_SEQUENCES
332: WHERE SEQUENCE_NAME = l_sequence_name and rownum=1;
333:
334: returned_sequence := sequence_number;
335: