APPS.GMO_PREFERENCES_PVT dependencies on GMO_KIOSK_PREFERENCES

Line 31: FROM GMO_KIOSK_PREFERENCES

27: ) IS
28:
29: CURSOR C_GET_PREFERENCE_ID_FOR_SITE IS
30: SELECT *
31: FROM GMO_KIOSK_PREFERENCES
32: WHERE LEVEL_VALUE = 'Y'
33: AND ORGANIZATION_ID = P_ORGANIZATION_ID;
34:
35: CURSOR C_GET_PREFERENCE_ID_FOR_RESP IS

Line 37: FROM GMO_KIOSK_PREFERENCES

33: AND ORGANIZATION_ID = P_ORGANIZATION_ID;
34:
35: CURSOR C_GET_PREFERENCE_ID_FOR_RESP IS
36: SELECT *
37: FROM GMO_KIOSK_PREFERENCES
38: WHERE LEVEL_CODE = 'RESPONSIBILITY'
39: AND ORGANIZATION_ID = P_ORGANIZATION_ID
40: AND LEVEL_VALUE = P_RESPONSIBILITY_ID;
41:

Line 45: FROM GMO_KIOSK_PREFERENCES

41:
42:
43: CURSOR C_GET_PREFERENCE_ID_FOR_USER IS
44: SELECT *
45: FROM GMO_KIOSK_PREFERENCES
46: WHERE LEVEL_CODE = 'USER'
47: AND ORGANIZATION_ID = P_ORGANIZATION_ID
48: AND LEVEL_VALUE = P_USER_ID;
49:

Line 66: l_preference_row GMO_KIOSK_PREFERENCES%ROWTYPE;

62: SELECT *
63: FROM GMO_KIOSK_REV_DISP_PREFERENCES
64: WHERE PREFERENCES_ID = P_PREFERENCE_ID;
65:
66: l_preference_row GMO_KIOSK_PREFERENCES%ROWTYPE;
67: l_dispense_preferences GMO_KIOSK_DISP_PREFERENCES%ROWTYPE;
68: l_owb_preferences GMO_KIOSK_OWB_PREFERENCES%ROWTYPE;
69: l_reverse_dispense_pref GMO_KIOSK_REV_DISP_PREFERENCES%ROWTYPE;
70: l_preferences_id number;