APPS.CE_CSH_FCST_POP dependencies on CE_PAY_FC_PAYROLL_V

Line 1572: FROM ce_pay_fc_payroll_v

1568: AND trx_date < l_fc_start_date;
1569:
1570: SELECT SUM(amount)
1571: INTO l_pay_cflow
1572: FROM ce_pay_fc_payroll_v
1573: WHERE bank_account_id = p_bank.bank_account_id
1574: AND trx_date >= l_balance_date
1575: AND trx_date < l_fc_start_date;
1576: ELSE

Line 1612: FROM ce_pay_fc_payroll_v src,

1608: AND curr.currency_code = src.currency_code;
1609:
1610: SELECT SUM(src.amount*curr.exchange_rate)
1611: INTO l_pay_cflow
1612: FROM ce_pay_fc_payroll_v src,
1613: ce_currency_rates_temp curr
1614: WHERE src.bank_account_id = p_bank.bank_account_id
1615: AND src.trx_date >= l_balance_date
1616: AND src.trx_date < l_fc_start_date

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

2811: cep_standard.debug('>>CE_CSH_FCAST_POP.Build_PAY_Exp_Query');
2812: select_clause := Get_Select_Clause;
2813: cep_standard.debug('Built Select Clause');
2814:
2815: from_clause := Get_From_Clause('ce_pay_fc_payroll_v');
2816: cep_standard.debug('Built From Clause');
2817:
2818: where_clause := Get_Where_Clause || '
2819: AND src.effective_date BETWEEN cab.start_date and cab.end_date ' ||