248: SELECT
249: MEANING
250: INTO CP_SORT_BY_COV
251: FROM
252: MFG_LOOKUPS
253: WHERE LOOKUP_TYPE = 'CST_SRS_PAC_BOM_CSTRPMDD_XMLP_PKG_SORT'
254: AND LOOKUP_CODE = P_SORT_ID;
255: SELECT
256: MEANING
255: SELECT
256: MEANING
257: INTO CP_TYPE_OPTION_COV
258: FROM
259: MFG_LOOKUPS
260: WHERE LOOKUP_TYPE = 'INV_SRS_DST_TYPE'
261: AND LOOKUP_CODE = P_TYPE_OPTION
262: AND ENABLED_FLAG = 'Y';
263: EXCEPTION