APPS.GML_ORAUDTR_XMLP_PKG dependencies on GEM_LOOKUP_VALUES

Line 199: GEM_LOOKUP_VALUES

195: SELECT
196: MEANING
197: INTO CP_SORT_1
198: FROM
199: GEM_LOOKUP_VALUES
200: WHERE LOOKUP_TYPE like 'GEMMS_OP_ORAUDTR'
201: AND LOOKUP_CODE = P_SORT1;
202: SELECT
203: MEANING

Line 206: GEM_LOOKUP_VALUES

202: SELECT
203: MEANING
204: INTO CP_SORT_2
205: FROM
206: GEM_LOOKUP_VALUES
207: WHERE LOOKUP_TYPE like 'GEMMS_OP_ORAUDTR'
208: AND LOOKUP_CODE = P_SORT2;
209: IF (P_SORT3 IS NOT NULL) THEN
210: SELECT

Line 214: GEM_LOOKUP_VALUES

210: SELECT
211: MEANING
212: INTO CP_SORT_3
213: FROM
214: GEM_LOOKUP_VALUES
215: WHERE LOOKUP_TYPE like 'GEMMS_OP_ORAUDTR'
216: AND LOOKUP_CODE = P_SORT3;
217: END IF;
218: IF (P_SORT4 IS NOT NULL) THEN

Line 223: GEM_LOOKUP_VALUES

219: SELECT
220: MEANING
221: INTO CP_SORT_4
222: FROM
223: GEM_LOOKUP_VALUES
224: WHERE LOOKUP_TYPE like 'GEMMS_OP_ORAUDTR'
225: AND LOOKUP_CODE = P_SORT4;
226: END IF;
227: RETURN NULL;