APPS.CE_CSH_FCST_POP dependencies on CE_PAY_FC_PAYROLL_V

Line 1503: FROM ce_pay_fc_payroll_v

1499: AND trx_date < l_fc_start_date;
1500:
1501: SELECT SUM(amount)
1502: INTO l_pay_cflow
1503: FROM ce_pay_fc_payroll_v
1504: WHERE bank_account_id = p_bank.bank_account_id
1505: AND trx_date >= l_balance_date
1506: AND trx_date < l_fc_start_date;
1507: ELSE

Line 1543: FROM ce_pay_fc_payroll_v src,

1539: AND curr.currency_code = src.currency_code;
1540:
1541: SELECT SUM(src.amount*curr.exchange_rate)
1542: INTO l_pay_cflow
1543: FROM ce_pay_fc_payroll_v src,
1544: ce_currency_rates_temp curr
1545: WHERE src.bank_account_id = p_bank.bank_account_id
1546: AND src.trx_date >= l_balance_date
1547: AND src.trx_date < l_fc_start_date

Line 2739: from_clause := Get_From_Clause('ce_pay_fc_payroll_v');

2735: cep_standard.debug('>>CE_CSH_FCAST_POP.Build_PAY_Exp_Query');
2736: select_clause := Get_Select_Clause;
2737: cep_standard.debug('Built Select Clause');
2738:
2739: from_clause := Get_From_Clause('ce_pay_fc_payroll_v');
2740: cep_standard.debug('Built From Clause');
2741:
2742: where_clause := Get_Where_Clause || '
2743: AND src.effective_date BETWEEN cab.start_date and cab.end_date ' ||