APPS.GMO_PREFERENCES_PVT SQL Statements

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

Line: 30

SELECT *
  FROM GMO_KIOSK_PREFERENCES
 WHERE LEVEL_VALUE = 'Y'
  AND    ORGANIZATION_ID = P_ORGANIZATION_ID;

Line: 36

SELECT *
  FROM GMO_KIOSK_PREFERENCES
 WHERE LEVEL_CODE = 'RESPONSIBILITY'
  AND  ORGANIZATION_ID = P_ORGANIZATION_ID
  AND  LEVEL_VALUE = P_RESPONSIBILITY_ID;

Line: 44

SELECT *
  FROM GMO_KIOSK_PREFERENCES
 WHERE LEVEL_CODE = 'USER'
  AND  ORGANIZATION_ID = P_ORGANIZATION_ID
  AND  LEVEL_VALUE = P_USER_ID;

Line: 52

SELECT *
  FROM GMO_KIOSK_DISP_PREFERENCES
 WHERE PREFERENCES_ID = P_PREFERENCE_ID;

Line: 57

SELECT *
  FROM GMO_KIOSK_OWB_PREFERENCES
 WHERE PREFERENCES_ID = P_PREFERENCE_ID;

Line: 62

SELECT *
  FROM GMO_KIOSK_REV_DISP_PREFERENCES
 WHERE PREFERENCES_ID = P_PREFERENCE_ID;

Line: 74

  /* Identify and select the preferences defined at the most restrictive levels
   * first. Site -> Responsibility -> Organization -> User.
   */

   OPEN C_GET_PREFERENCE_ID_FOR_USER;