DBA Data[Home] [Help]

APPS.GMF_AR_GET_SALESREP_CODE SQL Statements

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

Line: 6

  SELECT SALESREP_ID
  FROM   RA_SALESREPS_ALL
  WHERE  NAME LIKE NVL(SALESREPNAME,'%')
  AND    CREATION_DATE
  BETWEEN NVL(STARTDATE,CREATION_DATE)
          AND
          NVL(ENDDATE,CREATION_DATE);