APPS.CE_CSH_FCST_POP dependencies on CE_AP_FC_PAYMENTS_V

Line 1482: FROM ce_ap_fc_payments_v

1478: -- Calculate Prior-day Cashflow
1479: IF(CE_CASH_FCST.G_rp_exchange_type = 'User') THEN
1480: SELECT SUM(amount*CE_CASH_FCST.G_rp_exchange_rate)
1481: INTO l_app_cflow
1482: FROM ce_ap_fc_payments_v
1483: WHERE bank_account_id = p_bank.bank_account_id
1484: AND payment_date >= l_balance_date
1485: AND payment_date < l_fc_start_date;
1486:

Line 1510: FROM ce_ap_fc_payments_v src,

1506: AND trx_date < l_fc_start_date;
1507: ELSE
1508: SELECT SUM(src.amount*curr.exchange_rate)
1509: INTO l_app_cflow
1510: FROM ce_ap_fc_payments_v src,
1511: ce_currency_rates_temp curr
1512: WHERE src.bank_account_id = p_bank.bank_account_id
1513: AND src.payment_date >= l_balance_date
1514: AND src.payment_date < l_fc_start_date

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

1806: BEGIN
1807:
1808: cep_standard.debug('>>CE_CSH_FCAST_POP.Build_AP_Pay_Query');
1809:
1810: from_clause := Get_From_Clause('ce_ap_fc_payments_v');
1811: cep_standard.debug('Built From Clause');
1812:
1813: where_clause := Get_Where_Clause || Add_Where('PAYMENT_METHOD') || Add_Where('BANK_ACCOUNT_ID');
1814: