APPS.CE_JE_CREATION dependencies on CE_STATEMENT_LINES

Line 98: ce_statement_lines sl,

94: -- ba.asset_code_combination_id
95: ba.multi_currency_allowed_flag,
96: jem.trxn_subtype_code_id
97: FROM
98: ce_statement_lines sl,
99: ce_statement_headers sh,
100: -- ap_bank_accounts ba,
101: ce_bank_accounts ba,
102: ce_je_mappings_v jem

Line 627: ce_statement_lines

623: log('>>lock_statement_line');
624: SELECT 1
625: INTO l_dummy
626: FROM
627: ce_statement_lines
628: WHERE rowid = CE_JE_CREATION.csl_rowid
629: FOR UPDATE OF je_status_flag NOWAIT;
630:
631: RETURN true;

Line 654: UPDATE ce_statement_lines

650: PROCEDURE Update_statement_line(p_statement_line_id IN NUMBER,
651: p_cashflow_id IN NUMBER,
652: p_je_status_flag IN VARCHAR2) IS
653: BEGIN
654: UPDATE ce_statement_lines
655: SET cashflow_id = p_cashflow_id,
656: je_status_flag = p_je_status_flag
657: WHERE statement_line_id = p_statement_line_id;
658: END Update_statement_line;

Line 805: l_last_statement_line_id CE_STATEMENT_LINES.statement_line_id%TYPE := -1;

801: p_statement_date_from VARCHAR2,
802: p_statement_date_to VARCHAR2) IS
803: --p_gl_date VARCHAR2,
804: --p_report_mode VARCHAR2) IS
805: l_last_statement_line_id CE_STATEMENT_LINES.statement_line_id%TYPE := -1;
806: l_statement_header_id CE_STATEMENT_HEADERS.statement_header_id%TYPE;
807: l_bank_account_id CE_BANK_ACCOUNTS.bank_account_id%TYPE;
808: l_result VARCHAR2(50);
809: l_req_id NUMBER;