APPS.AR_ARXINREV_XMLP_PKG dependencies on AR_CASH_RECEIPT_HISTORY_ALL

Line 256: from ar_cash_receipt_history_all crh

252: and app.gl_date <= P_END_DATE
253: and app.application_type='CASH'
254: and exists
255: ( select 'Cleared Receipt'
256: from ar_cash_receipt_history_all crh
257: where crh.cash_receipt_id = app.cash_receipt_id
258: and crh.status = 'CLEARED'
259: and crh.gl_date <= P_END_DATE
260: and nvl(crh.reversal_gl_date,P_END_DATE+1) > P_END_DATE) ;

Line 475: ' ,ar_cash_receipt_history_all crh ' ||

471: lp_cleared_new := 'and ((pay.gl_date_closed > :LP_END_DATE) ' ||
472: ' or exists ' ||
473: ' ( select ''receipt clear after p_end_date'' ' ||
474: ' from ar_receivable_applications_all app ' ||
475: ' ,ar_cash_receipt_history_all crh ' ||
476: ' where trx.customer_trx_id = app.applied_customer_Trx_id ' ||
477: ' and app.cash_receipt_id = crh.cash_receipt_id' ||
478: ' and crh.status <> ''CLEARED'' ' ||
479: --(orig st)' and crh.gl_date <= :P_END_DATE' ||