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 932: CE_STATEMENT_LINES l

928: IF (NVL(X_amount,0) <> 0) THEN
929: SELECT h.statement_number || '/' || to_char(l.line_number)
930: INTO X_trx_number
931: FROM CE_STATEMENT_HEADERS h,
932: CE_STATEMENT_LINES l
933: WHERE h.statement_header_id = l.statement_header_id AND
934: l.statement_line_id = X_statement_line_id;
935:
936: IF trx_currency_type = 'FOREIGN' THEN