APPS.CE_CSH_FCST_POP dependencies on CE_AP_FC_PAYMENTS_V

Line 1551: FROM ce_ap_fc_payments_v

1547: -- Calculate Prior-day Cashflow
1548: IF(CE_CASH_FCST.G_rp_exchange_type = 'User') THEN
1549: SELECT SUM(amount*CE_CASH_FCST.G_rp_exchange_rate)
1550: INTO l_app_cflow
1551: FROM ce_ap_fc_payments_v
1552: WHERE bank_account_id = p_bank.bank_account_id
1553: AND payment_date >= l_balance_date
1554: AND payment_date < l_fc_start_date;
1555:

Line 1579: FROM ce_ap_fc_payments_v src,

1575: AND trx_date < l_fc_start_date;
1576: ELSE
1577: SELECT SUM(src.amount*curr.exchange_rate)
1578: INTO l_app_cflow
1579: FROM ce_ap_fc_payments_v src,
1580: ce_currency_rates_temp curr
1581: WHERE src.bank_account_id = p_bank.bank_account_id
1582: AND src.payment_date >= l_balance_date
1583: AND src.payment_date < l_fc_start_date

Line 1879: from_clause := Get_From_Clause('ce_ap_fc_payments_v');

1875: BEGIN
1876:
1877: cep_standard.debug('>>CE_CSH_FCAST_POP.Build_AP_Pay_Query');
1878:
1879: from_clause := Get_From_Clause('ce_ap_fc_payments_v');
1880: cep_standard.debug('Built From Clause');
1881:
1882: where_clause := Get_Where_Clause || Add_Where('PAYMENT_METHOD') || Add_Where('BANK_ACCOUNT_ID');
1883: