134: INTO
135: LP_FACTOR_DESC
136: ,TEMP
137: FROM
138: FND_LOOKUPS
139: WHERE LOOKUP_TYPE = 'XTR_FACTOR'
140: AND LOOKUP_CODE = SUBSTR(P_FACTOR
141: ,1
142: ,1);
147: ,20)
148: INTO
149: LP_FACTOR_DESC
150: FROM
151: FND_LOOKUPS
152: WHERE LOOKUP_TYPE = 'XTR_FACTOR'
153: AND LOOKUP_CODE = 'T';
154: TEMP := 1000;
155: END IF;
180: MEANING
181: INTO
182: P_EXPOSURE_TYPE_DSP
183: FROM
184: FND_LOOKUPS
185: WHERE LOOKUP_TYPE = 'XTR_MISC'
186: AND LOOKUP_CODE = P_EXPOSURE_TYPE;
187: SELECT
188: MEANING
188: MEANING
189: INTO
190: P_FACTOR_DSP
191: FROM
192: FND_LOOKUPS
193: WHERE LOOKUP_TYPE = 'XTR_MISC'
194: AND LOOKUP_CODE = P_FACTOR;
195: SELECT
196: MEANING
196: MEANING
197: INTO
198: P_YES_NO_DSP
199: FROM
200: FND_LOOKUPS
201: WHERE LOOKUP_TYPE = 'YES_NO'
202: AND LOOKUP_CODE = NVL(P_INCLUDE_INTERCOMP
203: ,'N');
204: RETURN (TRUE);