[Home] [Help]
APPS.CE_CP_PRIORDAY dependencies on CE_PAY_FC_PAYROLL_V
Line 263: FROM CE_PAY_FC_PAYROLL_V
259:
260: /* Prior Day for PAY */
261: SELECT -sum(decode(currency_code, l_currency_code, amount, base_amount))
262: INTO tmp_balance
263: FROM CE_PAY_FC_PAYROLL_V
264: WHERE bank_account_id = l_bank_account_id
265: AND trx_date > l_statement_date
266: AND trx_date < CE_CP_PRIORDAY.G_as_of_date;
267: