211: SELECT
212: MEANING
213: INTO V_VALUE
214: FROM
215: FND_LOOKUPS FND
216: WHERE FND.LOOKUP_TYPE = 'RLM_DETAIL_SUBTYPE_CODE'
217: AND DEMAND_BUCKET_TYPE_CODE = FND.LOOKUP_CODE;
218: RETURN (V_VALUE);
219: EXCEPTION
311: SELECT
312: MEANING
313: INTO V_VALUE
314: FROM
315: FND_LOOKUPS FND
316: WHERE FND.LOOKUP_TYPE = 'RLM_DETAIL_SUBTYPE_CODE'
317: AND DEMAND_BUCKET_TYPE_CODE1 = FND.LOOKUP_CODE;
318: RETURN (V_VALUE);
319: EXCEPTION
377: SELECT
378: MEANING
379: INTO X_SCHEDULE_TYPE
380: FROM
381: FND_LOOKUPS
382: WHERE LOOKUP_TYPE = 'RLM_SCHEDULE_TYPE'
383: AND LOOKUP_CODE = SCHEDULE_TYPE;
384: RETURN X_SCHEDULE_TYPE;
385: END IF;
401: SELECT
402: MEANING
403: INTO X_SCHEDULE_TYPE
404: FROM
405: FND_LOOKUPS
406: WHERE LOOKUP_TYPE = 'RLM_SCHEDULE_TYPE'
407: AND LOOKUP_CODE = SCHEDULE_TYPE2;
408: RETURN X_SCHEDULE_TYPE;
409: END IF;