DBA Data[Home] [Help]

APPS.CE_STAT_LINES_DML_PKG dependencies on DUAL

Line 86: CURSOR C1 IS SELECT ce_statement_lines_s.nextval from sys.dual;

82: X_global_attribute20 VARCHAR2
83: ) IS
84: CURSOR C IS SELECT rowid FROM CE_STATEMENT_LINES
85: WHERE statement_line_id = X_Statement_line_Id;
86: CURSOR C1 IS SELECT ce_statement_lines_s.nextval from sys.dual;
87: CURSOR C2 IS SELECT NVL(MAX(line_number),0) + 10 FROM CE_STATEMENT_LINES
88: WHERE statement_header_id = X_statement_header_Id;
89: CURSOR C3 IS SELECT ce_statement_headers_s.nextval FROM sys.dual;
90: sl_number NUMBER;

Line 89: CURSOR C3 IS SELECT ce_statement_headers_s.nextval FROM sys.dual;

85: WHERE statement_line_id = X_Statement_line_Id;
86: CURSOR C1 IS SELECT ce_statement_lines_s.nextval from sys.dual;
87: CURSOR C2 IS SELECT NVL(MAX(line_number),0) + 10 FROM CE_STATEMENT_LINES
88: WHERE statement_header_id = X_statement_header_Id;
89: CURSOR C3 IS SELECT ce_statement_headers_s.nextval FROM sys.dual;
90: sl_number NUMBER;
91: line_type VARCHAR2(20);
92: line_amount NUMBER;
93: p_float_days DATE;