314: SELECT
315: MEANING
316: INTO STYPE
317: FROM
318: FND_LOOKUP_VALUES_VL
319: WHERE LOOKUP_TYPE = 'RLM_SCHEDULE_TYPE'
320: AND LOOKUP_CODE = P_SCHEDULE_TYPE;
321: CP_SCHEDULE_TYPE := STYPE;
322: ELSE
326: SELECT
327: MEANING
328: INTO SPURPOSE
329: FROM
330: FND_LOOKUP_VALUES_VL
331: WHERE LOOKUP_TYPE = 'RLM_SCHEDULE_PURPOSE'
332: AND LOOKUP_CODE = P_SCHEDULE_PURPOSE;
333: CP_SCHEDULE_PURPOSE := SPURPOSE;
334: ELSE
338: SELECT
339: MEANING
340: INTO PSTATUS
341: FROM
342: FND_LOOKUP_VALUES_VL FLV
343: WHERE FLV.LOOKUP_TYPE = 'RLM_PROCESS_STATUS'
344: AND FLV.LOOKUP_CODE = P_PROCESS_STATUS;
345: CP_PROCESS_STATUS := PSTATUS;
346: ELSE
557: SELECT
558: MEANING
559: INTO SSOURCE
560: FROM
561: FND_LOOKUP_VALUES_VL
562: WHERE LOOKUP_TYPE = 'RLM_SCHEDULE_SOURCE'
563: AND LOOKUP_CODE = 'MANUAL';
564: ELSE
565: SSOURCE := SCHEDULE_SOURCE;