DBA Data[Home] [Help]

APPS.CE_CP_PRIORDAY dependencies on CE_XTR_CASHFLOWS_V

Line 225: FROM CE_XTR_CASHFLOWS_V

221:
222: /* Prior Day for XTR */
223: SELECT sum(amount)
224: INTO tmp_balance
225: FROM CE_XTR_CASHFLOWS_V
226: WHERE bank_account_id = l_bank_account_id
227: AND trx_date > l_statement_date
228: AND trx_date < CE_CP_PRIORDAY.G_as_of_date;
229:

Line 512: CE_XTR_CASHFLOWS_V XTR

508:
509: SELECT sum(XTR.amount)
510: INTO tmp_balance
511: FROM CE_CP_WORKSHEET_LINES WSL,
512: CE_XTR_CASHFLOWS_V XTR
513: WHERE WSL.worksheet_header_id = l_ws_id
514: AND WSL.source_type = 'XTI'
515: AND WSL.include_flag = 'Y'
516: AND WSL.cut_off_days is not null

Line 559: CE_XTR_CASHFLOWS_V XTR

555:
556: SELECT sum(XTR.amount)
557: INTO tmp_balance
558: FROM CE_CP_WORKSHEET_LINES WSL,
559: CE_XTR_CASHFLOWS_V XTR
560: WHERE WSL.worksheet_header_id = l_ws_id
561: AND WSL.source_type = 'XTO'
562: AND WSL.include_flag = 'Y'
563: AND WSL.cut_off_days is not null