59: INTO
60: LP_FACTOR_DESC
61: ,TEMP
62: FROM
63: FND_LOOKUPS
64: WHERE LOOKUP_TYPE = 'XTR_FACTOR'
65: AND LOOKUP_CODE = SUBSTR(P_FACTOR
66: ,1
67: ,1);
72: ,20)
73: INTO
74: LP_FACTOR_DESC
75: FROM
76: FND_LOOKUPS
77: WHERE LOOKUP_TYPE = 'XTR_FACTOR'
78: AND LOOKUP_CODE = 'T';
79: TEMP := 1000;
80: END IF;
165: MEANING
166: INTO
167: P_ISSUED_DSP
168: FROM
169: FND_LOOKUPS
170: WHERE LOOKUP_TYPE = 'XTR_MISC'
171: AND LOOKUP_CODE = ISS_PURCH2;
172: SELECT
173: MEANING
173: MEANING
174: INTO
175: P_FACTOR_DSP
176: FROM
177: FND_LOOKUPS
178: WHERE LOOKUP_TYPE = 'XTR_MISC'
179: AND LOOKUP_CODE = P_FACTOR;
180: SELECT
181: CP.USER_CONCURRENT_PROGRAM_NAME