APPS.CE_CP_PRIORDAY dependencies on CE_CE_CASHFLOWS_V

Line 299: FROM CE_CE_CASHFLOWS_V

295:
296: /* Prior Day for CEI */
297: SELECT sum(decode(currency_code, l_currency_code, cashflow_amount, base_amount))
298: INTO tmp_balance
299: FROM CE_CE_CASHFLOWS_V
300: WHERE cash_activity_date > l_statement_date
301: AND cash_activity_date < CE_CP_PRIORDAY.G_as_of_date
302: AND source_trxn_type <> 'STMT'
303: AND cashflow_direction = 'RECEIPT';

Line 338: FROM CE_CE_CASHFLOWS_V

334:
335: /* Prior Day for CEO */
336: SELECT sum(decode(currency_code, l_currency_code, cashflow_amount, base_amount))
337: INTO tmp_balance
338: FROM CE_CE_CASHFLOWS_V
339: WHERE cash_activity_date > l_statement_date
340: AND cash_activity_date < CE_CP_PRIORDAY.G_as_of_date
341: AND source_trxn_type <> 'STMT'
342: AND cashflow_direction = 'PAYMENT';

Line 608: FROM CE_CE_CASHFLOWS_V CEI,

604:
605: SELECT -sum(decode(CEI.currency_code, l_currency_code,
606: CEI.cashflow_amount, CEI.base_amount))
607: INTO tmp_balance
608: FROM CE_CE_CASHFLOWS_V CEI,
609: CE_CP_WORKSHEET_LINES WSL
610: WHERE WSL.worksheet_header_id = l_ws_id
611: AND WSL.source_type = 'CEI'
612: AND WSL.include_flag = 'Y'

Line 664: FROM CE_CE_CASHFLOWS_V CEO,

660:
661: SELECT -sum(decode(CEO.currency_code, l_currency_code,
662: CEO.cashflow_amount, CEO.base_amount))
663: INTO tmp_balance
664: FROM CE_CE_CASHFLOWS_V CEO,
665: CE_CP_WORKSHEET_LINES WSL
666: WHERE WSL.worksheet_header_id = l_ws_id
667: AND WSL.source_type = 'CEO'
668: AND WSL.include_flag = 'Y'