APPS.AR_IREC_PAYMENTS_W SQL Statements

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

Line: 75

  procedure update_invoice_payment_status(p_payment_schedule_id_list JTF_NUMBER_TABLE
    , p_inv_pay_status  VARCHAR2
    , x_return_status out nocopy  VARCHAR2
    , x_msg_count out nocopy  NUMBER
    , x_msg_data out nocopy  VARCHAR2
  )

  as
    ddp_payment_schedule_id_list ar_irec_payments.inv_list_table_type;

Line: 95

    ar_irec_payments.update_invoice_payment_status(ddp_payment_schedule_id_list,
      p_inv_pay_status,
      x_return_status,
      x_msg_count,
      x_msg_data);