APPS.GML_ORUARPJ_XMLP_PKG dependencies on GEM_LOOKUPS

Line 215: GEM_LOOKUPS

211: SELECT
212: MEANING
213: INTO CP_SORT_1
214: FROM
215: GEM_LOOKUPS
216: WHERE LOOKUP_TYPE like 'GEMMS_OP_ORUARPJ'
217: AND LOOKUP_CODE = P_SORT_1;
218: END IF;
219: IF P_SORT_2 IS NOT NULL THEN

Line 224: GEM_LOOKUPS

220: SELECT
221: MEANING
222: INTO CP_SORT_2
223: FROM
224: GEM_LOOKUPS
225: WHERE LOOKUP_TYPE like 'GEMMS_OP_ORUARPJ'
226: AND LOOKUP_CODE = P_SORT_2;
227: END IF;
228: IF P_SORT_3 IS NOT NULL THEN

Line 233: GEM_LOOKUPS

229: SELECT
230: MEANING
231: INTO CP_SORT_3
232: FROM
233: GEM_LOOKUPS
234: WHERE LOOKUP_TYPE like 'GEMMS_OP_ORUARPJ'
235: AND LOOKUP_CODE = P_SORT_3;
236: END IF;
237: IF P_SORT_4 IS NOT NULL THEN

Line 242: GEM_LOOKUPS

238: SELECT
239: MEANING
240: INTO CP_SORT_4
241: FROM
242: GEM_LOOKUPS
243: WHERE LOOKUP_TYPE like 'GEMMS_OP_ORUARPJ'
244: AND LOOKUP_CODE = P_SORT_4;
245: END IF;
246: RETURN (TRUE);