APPS.CE_CP_PRIORDAY dependencies on CE_AR_FC_RECEIPTS_V

Line 187: FROM CE_AR_FC_RECEIPTS_V

183:
184: /* Prior Day for ARR */
185: SELECT sum(decode(currency_code, l_currency_code, amount, base_amount))
186: INTO tmp_balance
187: FROM CE_AR_FC_RECEIPTS_V
188: WHERE bank_account_id = l_bank_account_id
189: AND cash_activity_date > l_statement_date
190: AND cash_Activity_date < CE_CP_PRIORDAY.G_as_of_date;
191:

Line 465: FROM CE_AR_FC_RECEIPTS_V ARR,

461:
462: SELECT sum(decode(ARR.currency_code, l_currency_code,
463: ARR.amount, ARR.base_amount))
464: INTO tmp_balance
465: FROM CE_AR_FC_RECEIPTS_V ARR,
466: CE_CP_WORKSHEET_LINES WSL
467: WHERE WSL.worksheet_header_id = l_ws_id
468: AND WSL.source_type = 'ARR'
469: AND WSL.include_flag = 'Y'