DBA Data[Home] [Help]

APPS.GML_GMLUNALC_XMLP_PKG dependencies on GEM_LOOKUPS

Line 320: GEM_LOOKUPS

316: SELECT
317: MEANING
318: INTO CP_SORT_1
319: FROM
320: GEM_LOOKUPS
321: WHERE LOOKUP_TYPE like 'GEMMS_OP_ORUARPJ'
322: AND LOOKUP_CODE = P_SORT_1;
323: END IF;
324: IF P_SORT_2 IS NOT NULL THEN

Line 329: GEM_LOOKUPS

325: SELECT
326: MEANING
327: INTO CP_SORT_2
328: FROM
329: GEM_LOOKUPS
330: WHERE LOOKUP_TYPE like 'GEMMS_OP_ORUARPJ'
331: AND LOOKUP_CODE = P_SORT_2;
332: END IF;
333: IF P_SORT_3 IS NOT NULL THEN

Line 338: GEM_LOOKUPS

334: SELECT
335: MEANING
336: INTO CP_SORT_3
337: FROM
338: GEM_LOOKUPS
339: WHERE LOOKUP_TYPE like 'GEMMS_OP_ORUARPJ'
340: AND LOOKUP_CODE = P_SORT_3;
341: END IF;
342: IF P_SORT_4 IS NOT NULL THEN

Line 347: GEM_LOOKUPS

343: SELECT
344: MEANING
345: INTO CP_SORT_4
346: FROM
347: GEM_LOOKUPS
348: WHERE LOOKUP_TYPE like 'GEMMS_OP_ORUARPJ'
349: AND LOOKUP_CODE = P_SORT_4;
350: END IF;
351: RETURN (TRUE);