APPS.CE_CSH_FCST_POP dependencies on CE_XTR_CASHFLOWS_V

Line 1565: FROM ce_xtr_cashflows_v

1561: AND cash_activity_date < l_fc_start_date;
1562:
1563: SELECT SUM(amount*CE_CASH_FCST.G_rp_exchange_rate)
1564: INTO l_xtr_cflow
1565: FROM ce_xtr_cashflows_v
1566: WHERE bank_account_id = p_bank.bank_account_id
1567: AND trx_date >= l_balance_date
1568: AND trx_date < l_fc_start_date;
1569:

Line 1601: FROM ce_xtr_cashflows_v src,

1597: AND curr.currency_code = src.currency_code;
1598:
1599: SELECT SUM(src.amount*curr.exchange_rate)
1600: INTO l_xtr_cflow
1601: FROM ce_xtr_cashflows_v src,
1602: ce_currency_rates_temp curr
1603: WHERE src.bank_account_id = p_bank.bank_account_id
1604: AND src.trx_date >= l_balance_date
1605: AND src.trx_date < l_fc_start_date

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

5294: round(nvl(src.amount,0)*curr.exchange_rate'
5295: ||','||CE_CASH_FCST.G_precision||'),
5296: src.amount';
5297: END IF;
5298: from_clause := Get_From_Clause('ce_xtr_cashflows_v');
5299: where_clause := Get_Where_Clause || '
5300: AND src.trx_date BETWEEN cab.start_date and cab.end_date '||
5301: Add_Where('XTR_TYPE') || Add_Where('XTR_BANK_ACCOUNT') || Add_Where('EXCLUDE_INDIC_EXP');
5302: