APPS.PA_AR_ADV_RECEIPT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 15

 select app.amount_applied,
        app.receivable_application_id
   from ar_receivable_applications app
  where app.cash_receipt_id = p_receipt_id
    and app.STATUS ='ACC'
    and app.display='Y';

Line: 56

    select ar_receivable_applications_s1.nextval into l_payment_set_id  from dual;

Line: 127

 select app.amount_applied,
        app.receivable_application_id,
        app.cash_receipt_id
   from ar_receivable_applications app
  where app.cash_receipt_id = p_receipt_id
    and app.STATUS ='OTHER ACC'
    and app.display='Y';

Line: 137

 select app.amount_applied,
        app.receivable_application_id,
	app.cash_receipt_id
   from ar_receivable_applications app
  where app.STATUS ='OTHER ACC'
    and app.display='Y'
    and app.payment_set_id = p_payment_set_id;