21: ,1
22: ,4)
23: INTO L_YES,L_NO
24: FROM
25: MFG_LOOKUPS L1,
26: MFG_LOOKUPS L2
27: WHERE L1.LOOKUP_TYPE = 'SYS_YES_NO'
28: AND L1.LOOKUP_CODE = 1
29: AND L2.LOOKUP_TYPE = 'SYS_YES_NO'
22: ,4)
23: INTO L_YES,L_NO
24: FROM
25: MFG_LOOKUPS L1,
26: MFG_LOOKUPS L2
27: WHERE L1.LOOKUP_TYPE = 'SYS_YES_NO'
28: AND L1.LOOKUP_CODE = 1
29: AND L2.LOOKUP_TYPE = 'SYS_YES_NO'
30: AND L2.LOOKUP_CODE = 2;
44: SELECT
45: MEANING
46: INTO STATUS
47: FROM
48: MFG_LOOKUPS
49: WHERE LOOKUP_CODE = P_STATUS
50: AND LOOKUP_TYPE = 'ECG_ECN_STATUS';
51: P_STATUS_CHAR := STATUS;
52: END IF;