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 674: ce_statement_lines

670: log('>>lock_statement_line');
671: SELECT 1
672: INTO l_dummy
673: FROM
674: ce_statement_lines
675: WHERE rowid = CE_JE_CREATION.csl_rowid
676: FOR UPDATE OF je_status_flag NOWAIT;
677:
678: RETURN true;

Line 701: UPDATE ce_statement_lines

697: PROCEDURE Update_statement_line(p_statement_line_id IN NUMBER,
698: p_cashflow_id IN NUMBER,
699: p_je_status_flag IN VARCHAR2) IS
700: BEGIN
701: UPDATE ce_statement_lines
702: SET cashflow_id = p_cashflow_id,
703: je_status_flag = p_je_status_flag
704: WHERE statement_line_id = p_statement_line_id;
705: END Update_statement_line;

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

848: p_statement_date_from VARCHAR2,
849: p_statement_date_to VARCHAR2) IS
850: --p_gl_date VARCHAR2,
851: --p_report_mode VARCHAR2) IS
852: l_last_statement_line_id CE_STATEMENT_LINES.statement_line_id%TYPE := -1;
853: l_statement_header_id CE_STATEMENT_HEADERS.statement_header_id%TYPE;
854: l_bank_account_id CE_BANK_ACCOUNTS.bank_account_id%TYPE;
855: l_result VARCHAR2(50);
856: l_req_id NUMBER;