DBA Data[Home] [Help]

APPS.RG_ROW_ORDERS_PKG dependencies on DUAL

Line 10: FROM dual;

6: new_sequence_number NUMBER;
7: BEGIN
8: SELECT rg_row_orders_s.nextval
9: INTO new_sequence_number
10: FROM dual;
11:
12: RETURN(new_sequence_number);
13: END new_row_order_id;
14:

Line 50: SELECT 1 INTO dummy FROM sys.dual

46:
47: PROCEDURE check_references(X_row_order_id NUMBER) IS
48: dummy NUMBER;
49: BEGIN
50: SELECT 1 INTO dummy FROM sys.dual
51: WHERE NOT EXISTS
52: (SELECT 1
53: FROM rg_reports
54: WHERE row_order_id = X_row_order_id);