The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT *
FROM GMO_KIOSK_PREFERENCES
WHERE LEVEL_VALUE = 'Y'
AND ORGANIZATION_ID = P_ORGANIZATION_ID;
SELECT *
FROM GMO_KIOSK_PREFERENCES
WHERE LEVEL_CODE = 'RESPONSIBILITY'
AND ORGANIZATION_ID = P_ORGANIZATION_ID
AND LEVEL_VALUE = P_RESPONSIBILITY_ID;
SELECT *
FROM GMO_KIOSK_PREFERENCES
WHERE LEVEL_CODE = 'USER'
AND ORGANIZATION_ID = P_ORGANIZATION_ID
AND LEVEL_VALUE = P_USER_ID;
SELECT *
FROM GMO_KIOSK_DISP_PREFERENCES
WHERE PREFERENCES_ID = P_PREFERENCE_ID;
SELECT *
FROM GMO_KIOSK_OWB_PREFERENCES
WHERE PREFERENCES_ID = P_PREFERENCE_ID;
SELECT *
FROM GMO_KIOSK_REV_DISP_PREFERENCES
WHERE PREFERENCES_ID = P_PREFERENCE_ID;
/* Identify and select the preferences defined at the most restrictive levels
* first. Site -> Responsibility -> Organization -> User.
*/
OPEN C_GET_PREFERENCE_ID_FOR_USER;