APPS.EDR_MSCA_UTIL SQL Statements

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

Line: 55

    select MEANING, LOOKUP_CODE
    FROM FND_LOOKUP_VALUES_VL
    WHERE LOOKUP_TYPE = p_lookup_type
      AND UPPER(MEANING) LIKE  UPPER(p_meaning)||'%';

Line: 73

    select MEANING, LOOKUP_CODE
    FROM FND_LOOKUP_VALUES_VL
    WHERE LOOKUP_TYPE = p_lookup_type
    AND LOOKUP_CODE <> p_exclude_lookup_code
    AND UPPER(MEANING) LIKE   UPPER(p_meaning)||'%';

Line: 92

    Select EDR_UTILITIES.GETUSERDISPLAYNAME(ESIG.USER_NAME) USER_DISPLAY_NAME,
           ESIG.SIGNATURE_SEQUENCE,
           ESIG.USER_NAME
    FROM EDR_ESIGNATURES ESIG,EDR_ERECORDS EREC
      where EREC.EVENT_ID=ESIG.EVENT_ID
      and ESIG.EVENT_ID = p_eventkey
      and ESIG.SIGNATURE_STATUS = 'PENDING'
      and UPPER(EDR_UTILITIES.GETUSERDISPLAYNAME(ESIG.USER_NAME)) like UPPER(p_approverName) || '%'
      order by SIGNATURE_SEQUENCE;

Line: 113

    SELECT TEST_SCENARIO,
           TEST_SCENARIO_INSTANCE,
           TEST_SCENARIO_ID

    FROM   EDR_INTER_EVENT_TEST_SCENARIOS
    WHERE  TEST_SCENARIO_TYPE is null or TEST_SCENARIO_TYPE = 'F'
    ORDER BY TEST_SCENARIO_ID DESC;