APPS.AST_INVOICES_PVT SQL Statements

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

Line: 42

    l_select_cl               VARCHAR2(2000) := '';

Line: 119

    l_select_cl := 'SELECT customer_trx_id, '
      || 'trx_number, '
      || 'al_status_meaning, '
      || 'al_class_meaning, '
      || 'status, '
      || 'class, '
      || 'amount_due_remaining, '
      || 'amount_due_original, '
      || 'trx_date, '
      || 'invoice_currency_code, '
      || 'acctd_amount_due_remaining '
      || 'FROM   ar_payment_schedules_v ';

Line: 159

    l_select_cl := l_select_cl || l_where_cl || l_order_by_cl;

Line: 164

    dbms_sql.parse(l_cur_get_inv, l_select_cl, dbms_sql.native);