APPS.CE_CSH_FCST_POP dependencies on CE_XTR_CASHFLOWS_V

Line 1496: FROM ce_xtr_cashflows_v

1492: AND cash_activity_date < l_fc_start_date;
1493:
1494: SELECT SUM(amount*CE_CASH_FCST.G_rp_exchange_rate)
1495: INTO l_xtr_cflow
1496: FROM ce_xtr_cashflows_v
1497: WHERE bank_account_id = p_bank.bank_account_id
1498: AND trx_date >= l_balance_date
1499: AND trx_date < l_fc_start_date;
1500:

Line 1532: FROM ce_xtr_cashflows_v src,

1528: AND curr.currency_code = src.currency_code;
1529:
1530: SELECT SUM(src.amount*curr.exchange_rate)
1531: INTO l_xtr_cflow
1532: FROM ce_xtr_cashflows_v src,
1533: ce_currency_rates_temp curr
1534: WHERE src.bank_account_id = p_bank.bank_account_id
1535: AND src.trx_date >= l_balance_date
1536: AND src.trx_date < l_fc_start_date

Line 5147: from_clause := Get_From_Clause('ce_xtr_cashflows_v');

5143: round(nvl(src.amount,0)*curr.exchange_rate'
5144: ||','||CE_CASH_FCST.G_precision||'),
5145: src.amount';
5146: END IF;
5147: from_clause := Get_From_Clause('ce_xtr_cashflows_v');
5148: where_clause := Get_Where_Clause || '
5149: AND src.trx_date BETWEEN cab.start_date and cab.end_date '||
5150: Add_Where('XTR_TYPE') || Add_Where('XTR_BANK_ACCOUNT') || Add_Where('EXCLUDE_INDIC_EXP');
5151: