The following lines contain the word 'select', 'insert', 'update' or 'delete':
select MEANING, LOOKUP_CODE
FROM FND_LOOKUP_VALUES_VL
WHERE LOOKUP_TYPE = p_lookup_type
AND UPPER(MEANING) LIKE UPPER(p_meaning)||'%';
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)||'%';
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;
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;