APPS.JG_ZZ_AERL_DT_PKG dependencies on CE_STATEMENT_LINES

Line 53: lv_sl_trx_type ce_statement_lines.trx_type%type;

49: end cf_batch_name;
50: function get_financial_document_type(pn_trx_id in number,pn_trx_type_id in number, pv_source in varchar2 , pv_entity_code in varchar2) return varchar2 as
51: /* This function will fetch Financial Document type to solve the bug 5550600*/
52: lv_fin_doc_type varchar2(20);
53: lv_sl_trx_type ce_statement_lines.trx_type%type;
54: lv_cr_reversal_category ar_cash_receipts_all.reversal_category%type;
55: begin
56: fnd_file.put_line(fnd_file.log, '**Input Params:** ');
57: fnd_file.put_line(fnd_file.log, '1. Trx_id: '||pn_trx_id);

Line 70: from ar_cash_receipt_history_all crh, ce_statement_reconcils_all sr,ce_statement_lines sl

66: where invoice_id = pn_trx_id;
67: elsif pv_source = 'AR' then
68: if pv_entity_code = 'RECEIPTS' then
69: select sl.trx_type into lv_sl_trx_type
70: from ar_cash_receipt_history_all crh, ce_statement_reconcils_all sr,ce_statement_lines sl
71: where crh.cash_receipt_id = pn_trx_id
72: and crh.cash_receipt_history_id = sr.reference_id
73: and sr.statement_line_id = sl.statement_line_id
74: and crh.org_id = sr.org_id; -- Bug 8364296