DBA Data[Home] [Help]

APPS.CE_STAT_HDRS_DML_PKG dependencies on DUAL

Line 99: CURSOR C2 IS SELECT CE_STATEMENT_HEADERS_S.nextval FROM SYS.dual;

95: p_xtr_val boolean;
96: CURSOR C IS SELECT rowid
97: FROM CE_STATEMENT_HEADERS
98: WHERE statement_header_id = X_Statement_Header_Id;
99: CURSOR C2 IS SELECT CE_STATEMENT_HEADERS_S.nextval FROM SYS.dual;
100: CURSOR C3 IS SELECT CE_BANK_ACCT_BALANCES_S.nextval FROM SYS.dual;
101: BEGIN
102: IF (X_statement_header_id IS NULL) THEN
103: OPEN C2;

Line 100: CURSOR C3 IS SELECT CE_BANK_ACCT_BALANCES_S.nextval FROM SYS.dual;

96: CURSOR C IS SELECT rowid
97: FROM CE_STATEMENT_HEADERS
98: WHERE statement_header_id = X_Statement_Header_Id;
99: CURSOR C2 IS SELECT CE_STATEMENT_HEADERS_S.nextval FROM SYS.dual;
100: CURSOR C3 IS SELECT CE_BANK_ACCT_BALANCES_S.nextval FROM SYS.dual;
101: BEGIN
102: IF (X_statement_header_id IS NULL) THEN
103: OPEN C2;
104: FETCH C2 INTO X_statement_header_id;