APPS.CSD_REPAIR_TYPES_PVT SQL Statements

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

Line: 42

 SELECT  RT_B.START_FLOW_STATUS_ID,
     	   FS_B.FLOW_STATUS_CODE START_FLOW_STATUS_CODE,
	   FS_LKUP.MEANING START_FLOW_STATUS_MEANING,
	   FS_B.STATUS_CODE STATUS_CODE
 FROM    CSD_REPAIR_TYPES_B RT_B,
         CSD_FLOW_STATUSES_B FS_B,
         FND_LOOKUPS FS_LKUP
 WHERE   RT_B.REPAIR_TYPE_ID = p_repair_type_id AND
         FS_B.FLOW_STATUS_ID = RT_B.START_FLOW_STATUS_ID AND
         FS_LKUP.lookup_type = lc_FLOW_STATUS_LOOKUP_TYPE   AND
         FS_LKUP.enabled_flag = 'Y' AND
         TRUNC(SYSDATE) BETWEEN
         TRUNC(NVL(FS_LKUP.start_date_active, SYSDATE)) AND
         TRUNC(NVL(FS_LKUP.end_date_active, SYSDATE)) AND
         FS_LKUP.lookup_code = FS_B.FLOW_STATUS_CODE;