DBA Data[Home] [Help]

APPS.CE_CSH_FCST_POP dependencies on CE_AR_FC_RECEIPTS_V

Line 1558: FROM ce_ar_fc_receipts_v

1554: AND payment_date < l_fc_start_date;
1555:
1556: SELECT SUM(amount*CE_CASH_FCST.G_rp_exchange_rate)
1557: INTO l_arr_cflow
1558: FROM ce_ar_fc_receipts_v
1559: WHERE bank_account_id = p_bank.bank_account_id
1560: AND cash_activity_date >= l_balance_date
1561: AND cash_activity_date < l_fc_start_date;
1562:

Line 1590: FROM ce_ar_fc_receipts_v src,

1586: AND curr.currency_code = src.currency_code;
1587:
1588: SELECT SUM(src.amount*curr.exchange_rate)
1589: INTO l_arr_cflow
1590: FROM ce_ar_fc_receipts_v src,
1591: ce_currency_rates_temp curr
1592: WHERE src.bank_account_id = p_bank.bank_account_id
1593: AND src.cash_activity_date >= l_balance_date
1594: AND src.cash_activity_date < l_fc_start_date

Line 2476: from_clause := Get_From_Clause ('ce_ar_fc_receipts_v');

2472:
2473: BEGIN
2474: cep_standard.debug('>>Build_AR_Receipt_Query');
2475:
2476: from_clause := Get_From_Clause ('ce_ar_fc_receipts_v');
2477: cep_standard.debug('Built From Clause');
2478:
2479: where_clause := Get_Where_Clause || Add_Where('BANK_ACCOUNT_ID') || Add_Where('RECEIPT_METHOD_ID');
2480: