APPS.CE_CP_PRIORDAY dependencies on CE_AP_FC_PAYMENTS_V

Line 146: FROM CE_AP_FC_PAYMENTS_V

142:
143: /* Prior Day for APP */
144: SELECT -sum(decode(currency_code, l_currency_code, amount, base_amount))
145: INTO tmp_balance
146: FROM CE_AP_FC_PAYMENTS_V
147: WHERE bank_account_id = l_bank_account_id
148: AND nvl(actual_value_date, nvl(anticipated_value_date,
149: nvl(maturity_date, payment_date))) > l_statement_date
150: AND nvl(actual_value_date, nvl(anticipated_value_date,

Line 415: FROM CE_AP_FC_PAYMENTS_V AP,

411:
412: SELECT -sum(decode(AP.currency_code, l_currency_code,
413: AP.amount, AP.base_amount))
414: INTO tmp_balance
415: FROM CE_AP_FC_PAYMENTS_V AP,
416: CE_CP_WORKSHEET_LINES WSL
417: WHERE WSL.worksheet_header_id = l_ws_id
418: AND WSL.source_type = 'APP'
419: AND WSL.include_flag = 'Y'