APPS.AR_VIEW_TERM_GRP SQL Statements

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

Line: 90

  SELECT NVL(base_amount,100),
         first_installment_code
  FROM   ra_terms
  WHERE  term_id = p_term_id;

Line: 96

  SELECT NVL(SUM(tl.relative_amount),0),
         NVL(SUM(DECODE(tl.sequence_num,1,1,0)),0)
  FROM   ra_terms_lines tl
  WHERE  tl.term_id = p_term_id
  AND    tl.due_days = 0;