APPS.GML_GMLUNALC_XMLP_PKG dependencies on GEM_LOOKUP_VALUES

Line 262: GEM_LOOKUP_VALUES

258: SELECT
259: MEANING
260: INTO CP_SORT_1
261: FROM
262: GEM_LOOKUP_VALUES
263: WHERE LOOKUP_TYPE like 'GEMMS_OP_ORUARPJ'
264: AND LOOKUP_CODE = P_SORT_1;
265: END IF;
266: IF P_SORT_2 IS NOT NULL THEN

Line 271: GEM_LOOKUP_VALUES

267: SELECT
268: MEANING
269: INTO CP_SORT_2
270: FROM
271: GEM_LOOKUP_VALUES
272: WHERE LOOKUP_TYPE like 'GEMMS_OP_ORUARPJ'
273: AND LOOKUP_CODE = P_SORT_2;
274: END IF;
275: IF P_SORT_3 IS NOT NULL THEN

Line 280: GEM_LOOKUP_VALUES

276: SELECT
277: MEANING
278: INTO CP_SORT_3
279: FROM
280: GEM_LOOKUP_VALUES
281: WHERE LOOKUP_TYPE like 'GEMMS_OP_ORUARPJ'
282: AND LOOKUP_CODE = P_SORT_3;
283: END IF;
284: IF P_SORT_4 IS NOT NULL THEN

Line 289: GEM_LOOKUP_VALUES

285: SELECT
286: MEANING
287: INTO CP_SORT_4
288: FROM
289: GEM_LOOKUP_VALUES
290: WHERE LOOKUP_TYPE like 'GEMMS_OP_ORUARPJ'
291: AND LOOKUP_CODE = P_SORT_4;
292: END IF;
293: RETURN NULL;