APPS.CE_AUTO_BANK_CLEAR1 dependencies on CE_STATEMENT_LINES

Line 118: CURSOR C_STATEMENT_LINE_SEQ IS SELECT ce_statement_lines_s.nextval from sys.dual;

114: AND pgroup_id is null ; -- FOR SEPA ER 6700007
115: --AND a.application_id = 261;
116: --AND NVL(a.reconciled_status_flag, 'N') = 'N';
117:
118: CURSOR C_STATEMENT_LINE_SEQ IS SELECT ce_statement_lines_s.nextval from sys.dual;
119:
120: FUNCTION body_revision RETURN VARCHAR2 IS
121: BEGIN
122:

Line 262: | Inserts records into CE_STATEMENT_LINES . |

258: /* ---------------------------------------------------------------------
259: | PRIVATE PROCEDURE |
260: | create_statement_line |
261: | DESCRIPTION |
262: | Inserts records into CE_STATEMENT_LINES . |
263: --------------------------------------------------------------------- */
264: PROCEDURE create_statement_line IS
265: BEGIN
266: IF l_DEBUG in ('Y', 'C') THEN

Line 911: CE_STATEMENT_LINES l

907: IF (NVL(X_amount,0) <> 0) THEN
908: SELECT h.statement_number || '/' || to_char(l.line_number)
909: INTO X_trx_number
910: FROM CE_STATEMENT_HEADERS h,
911: CE_STATEMENT_LINES l
912: WHERE h.statement_header_id = l.statement_header_id AND
913: l.statement_line_id = X_statement_line_id;
914:
915: IF trx_currency_type = 'FOREIGN' THEN