APPS.GML_ORUARPJ_XMLP_PKG dependencies on GEM_LOOKUP_VALUES

Line 261: GEM_LOOKUP_VALUES

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

Line 270: GEM_LOOKUP_VALUES

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

Line 279: GEM_LOOKUP_VALUES

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

Line 288: GEM_LOOKUP_VALUES

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