APPS.AR_ARXINREV_XMLP_PKG dependencies on AR_RECEIVABLE_APPLICATIONS

Line 235: from ar_receivable_applications app

231: if p_cleared = 'N'
232: then
233: select sum(nvl(app.amount_applied,0) + nvl(app.earned_discount_taken,0) + nvl(app.unearned_discount_taken,0))
234: into receipt
235: from ar_receivable_applications app
236: where app.applied_payment_schedule_id = C_PAY_ID
237: and app.status = 'APP'
238: and app.gl_date <= P_END_DATE
239: and app.application_type='CASH'

Line 249: from ar_receivable_applications app

245: and crh.gl_date <= P_END_DATE);
246: else
247: select sum(nvl(app.amount_applied,0) + nvl(app.earned_discount_taken,0) + nvl(app.unearned_discount_taken,0))
248: into receipt
249: from ar_receivable_applications app
250: where app.applied_payment_schedule_id = C_PAY_ID
251: and app.status = 'APP'
252: and app.gl_date <= P_END_DATE
253: and app.application_type='CASH'

Line 380: from ar_receivable_applications app

376: begin
377: /*srw.reference(C_PAY_ID);*/null;
378: select sum(nvl(app.amount_applied,0))
379: into cm
380: from ar_receivable_applications app
381: where app.gl_date <= P_END_DATE
382: and app.status ='APP'
383: and app.application_type = 'CM'
384: and app.applied_payment_schedule_id = C_PAY_ID ;

Line 474: ' from ar_receivable_applications_all app ' ||

470: --(orig st)lp_cleared_new := 'and ((pay.gl_date_closed > :P_END_DATE) ' ||
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'' ' ||

Line 556: from ar_receivable_applications app

552: begin
553: /*srw.reference(C_PAY_ID);*/null;
554: select sum(nvl(app.amount_applied,0))
555: into cm
556: from ar_receivable_applications app
557: where app.gl_date <= P_END_DATE
558: and app.status ='APP'
559: and app.application_type = 'CM'
560: and app.payment_schedule_id = C_PAY_ID ;