eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FA_MASS_RET_PKG dependencies on GL_CODE_COMBINATIONS

Line 192: l_1st_Segment1 gl_code_combinations.segment1%TYPE;

188: l_Acct_Split VARCHAR2(1);
189: l_Emp_Split VARCHAR2(1);
190: l_Loc_Split VARCHAR2(1);
191:
192: l_1st_Segment1 gl_code_combinations.segment1%TYPE;
193: l_1st_Segment2 gl_code_combinations.segment2%TYPE;
194: l_1st_Segment3 gl_code_combinations.segment3%TYPE;
195: l_1st_Segment4 gl_code_combinations.segment4%TYPE;
196: l_1st_Segment5 gl_code_combinations.segment5%TYPE;

Line 193: l_1st_Segment2 gl_code_combinations.segment2%TYPE;

189: l_Emp_Split VARCHAR2(1);
190: l_Loc_Split VARCHAR2(1);
191:
192: l_1st_Segment1 gl_code_combinations.segment1%TYPE;
193: l_1st_Segment2 gl_code_combinations.segment2%TYPE;
194: l_1st_Segment3 gl_code_combinations.segment3%TYPE;
195: l_1st_Segment4 gl_code_combinations.segment4%TYPE;
196: l_1st_Segment5 gl_code_combinations.segment5%TYPE;
197: l_1st_Segment6 gl_code_combinations.segment6%TYPE;

Line 194: l_1st_Segment3 gl_code_combinations.segment3%TYPE;

190: l_Loc_Split VARCHAR2(1);
191:
192: l_1st_Segment1 gl_code_combinations.segment1%TYPE;
193: l_1st_Segment2 gl_code_combinations.segment2%TYPE;
194: l_1st_Segment3 gl_code_combinations.segment3%TYPE;
195: l_1st_Segment4 gl_code_combinations.segment4%TYPE;
196: l_1st_Segment5 gl_code_combinations.segment5%TYPE;
197: l_1st_Segment6 gl_code_combinations.segment6%TYPE;
198: l_1st_Segment7 gl_code_combinations.segment7%TYPE;

Line 195: l_1st_Segment4 gl_code_combinations.segment4%TYPE;

191:
192: l_1st_Segment1 gl_code_combinations.segment1%TYPE;
193: l_1st_Segment2 gl_code_combinations.segment2%TYPE;
194: l_1st_Segment3 gl_code_combinations.segment3%TYPE;
195: l_1st_Segment4 gl_code_combinations.segment4%TYPE;
196: l_1st_Segment5 gl_code_combinations.segment5%TYPE;
197: l_1st_Segment6 gl_code_combinations.segment6%TYPE;
198: l_1st_Segment7 gl_code_combinations.segment7%TYPE;
199: l_1st_Segment8 gl_code_combinations.segment8%TYPE;

Line 196: l_1st_Segment5 gl_code_combinations.segment5%TYPE;

192: l_1st_Segment1 gl_code_combinations.segment1%TYPE;
193: l_1st_Segment2 gl_code_combinations.segment2%TYPE;
194: l_1st_Segment3 gl_code_combinations.segment3%TYPE;
195: l_1st_Segment4 gl_code_combinations.segment4%TYPE;
196: l_1st_Segment5 gl_code_combinations.segment5%TYPE;
197: l_1st_Segment6 gl_code_combinations.segment6%TYPE;
198: l_1st_Segment7 gl_code_combinations.segment7%TYPE;
199: l_1st_Segment8 gl_code_combinations.segment8%TYPE;
200: l_1st_Segment9 gl_code_combinations.segment9%TYPE;

Line 197: l_1st_Segment6 gl_code_combinations.segment6%TYPE;

193: l_1st_Segment2 gl_code_combinations.segment2%TYPE;
194: l_1st_Segment3 gl_code_combinations.segment3%TYPE;
195: l_1st_Segment4 gl_code_combinations.segment4%TYPE;
196: l_1st_Segment5 gl_code_combinations.segment5%TYPE;
197: l_1st_Segment6 gl_code_combinations.segment6%TYPE;
198: l_1st_Segment7 gl_code_combinations.segment7%TYPE;
199: l_1st_Segment8 gl_code_combinations.segment8%TYPE;
200: l_1st_Segment9 gl_code_combinations.segment9%TYPE;
201: l_1st_Segment10 gl_code_combinations.segment10%TYPE;

Line 198: l_1st_Segment7 gl_code_combinations.segment7%TYPE;

194: l_1st_Segment3 gl_code_combinations.segment3%TYPE;
195: l_1st_Segment4 gl_code_combinations.segment4%TYPE;
196: l_1st_Segment5 gl_code_combinations.segment5%TYPE;
197: l_1st_Segment6 gl_code_combinations.segment6%TYPE;
198: l_1st_Segment7 gl_code_combinations.segment7%TYPE;
199: l_1st_Segment8 gl_code_combinations.segment8%TYPE;
200: l_1st_Segment9 gl_code_combinations.segment9%TYPE;
201: l_1st_Segment10 gl_code_combinations.segment10%TYPE;
202: l_1st_Segment11 gl_code_combinations.segment11%TYPE;

Line 199: l_1st_Segment8 gl_code_combinations.segment8%TYPE;

195: l_1st_Segment4 gl_code_combinations.segment4%TYPE;
196: l_1st_Segment5 gl_code_combinations.segment5%TYPE;
197: l_1st_Segment6 gl_code_combinations.segment6%TYPE;
198: l_1st_Segment7 gl_code_combinations.segment7%TYPE;
199: l_1st_Segment8 gl_code_combinations.segment8%TYPE;
200: l_1st_Segment9 gl_code_combinations.segment9%TYPE;
201: l_1st_Segment10 gl_code_combinations.segment10%TYPE;
202: l_1st_Segment11 gl_code_combinations.segment11%TYPE;
203: l_1st_Segment12 gl_code_combinations.segment12%TYPE;

Line 200: l_1st_Segment9 gl_code_combinations.segment9%TYPE;

196: l_1st_Segment5 gl_code_combinations.segment5%TYPE;
197: l_1st_Segment6 gl_code_combinations.segment6%TYPE;
198: l_1st_Segment7 gl_code_combinations.segment7%TYPE;
199: l_1st_Segment8 gl_code_combinations.segment8%TYPE;
200: l_1st_Segment9 gl_code_combinations.segment9%TYPE;
201: l_1st_Segment10 gl_code_combinations.segment10%TYPE;
202: l_1st_Segment11 gl_code_combinations.segment11%TYPE;
203: l_1st_Segment12 gl_code_combinations.segment12%TYPE;
204: l_1st_Segment13 gl_code_combinations.segment13%TYPE;

Line 201: l_1st_Segment10 gl_code_combinations.segment10%TYPE;

197: l_1st_Segment6 gl_code_combinations.segment6%TYPE;
198: l_1st_Segment7 gl_code_combinations.segment7%TYPE;
199: l_1st_Segment8 gl_code_combinations.segment8%TYPE;
200: l_1st_Segment9 gl_code_combinations.segment9%TYPE;
201: l_1st_Segment10 gl_code_combinations.segment10%TYPE;
202: l_1st_Segment11 gl_code_combinations.segment11%TYPE;
203: l_1st_Segment12 gl_code_combinations.segment12%TYPE;
204: l_1st_Segment13 gl_code_combinations.segment13%TYPE;
205: l_1st_Segment14 gl_code_combinations.segment14%TYPE;

Line 202: l_1st_Segment11 gl_code_combinations.segment11%TYPE;

198: l_1st_Segment7 gl_code_combinations.segment7%TYPE;
199: l_1st_Segment8 gl_code_combinations.segment8%TYPE;
200: l_1st_Segment9 gl_code_combinations.segment9%TYPE;
201: l_1st_Segment10 gl_code_combinations.segment10%TYPE;
202: l_1st_Segment11 gl_code_combinations.segment11%TYPE;
203: l_1st_Segment12 gl_code_combinations.segment12%TYPE;
204: l_1st_Segment13 gl_code_combinations.segment13%TYPE;
205: l_1st_Segment14 gl_code_combinations.segment14%TYPE;
206: l_1st_Segment15 gl_code_combinations.segment15%TYPE;

Line 203: l_1st_Segment12 gl_code_combinations.segment12%TYPE;

199: l_1st_Segment8 gl_code_combinations.segment8%TYPE;
200: l_1st_Segment9 gl_code_combinations.segment9%TYPE;
201: l_1st_Segment10 gl_code_combinations.segment10%TYPE;
202: l_1st_Segment11 gl_code_combinations.segment11%TYPE;
203: l_1st_Segment12 gl_code_combinations.segment12%TYPE;
204: l_1st_Segment13 gl_code_combinations.segment13%TYPE;
205: l_1st_Segment14 gl_code_combinations.segment14%TYPE;
206: l_1st_Segment15 gl_code_combinations.segment15%TYPE;
207: l_1st_Segment16 gl_code_combinations.segment16%TYPE;

Line 204: l_1st_Segment13 gl_code_combinations.segment13%TYPE;

200: l_1st_Segment9 gl_code_combinations.segment9%TYPE;
201: l_1st_Segment10 gl_code_combinations.segment10%TYPE;
202: l_1st_Segment11 gl_code_combinations.segment11%TYPE;
203: l_1st_Segment12 gl_code_combinations.segment12%TYPE;
204: l_1st_Segment13 gl_code_combinations.segment13%TYPE;
205: l_1st_Segment14 gl_code_combinations.segment14%TYPE;
206: l_1st_Segment15 gl_code_combinations.segment15%TYPE;
207: l_1st_Segment16 gl_code_combinations.segment16%TYPE;
208: l_1st_Segment17 gl_code_combinations.segment17%TYPE;

Line 205: l_1st_Segment14 gl_code_combinations.segment14%TYPE;

201: l_1st_Segment10 gl_code_combinations.segment10%TYPE;
202: l_1st_Segment11 gl_code_combinations.segment11%TYPE;
203: l_1st_Segment12 gl_code_combinations.segment12%TYPE;
204: l_1st_Segment13 gl_code_combinations.segment13%TYPE;
205: l_1st_Segment14 gl_code_combinations.segment14%TYPE;
206: l_1st_Segment15 gl_code_combinations.segment15%TYPE;
207: l_1st_Segment16 gl_code_combinations.segment16%TYPE;
208: l_1st_Segment17 gl_code_combinations.segment17%TYPE;
209: l_1st_Segment18 gl_code_combinations.segment18%TYPE;

Line 206: l_1st_Segment15 gl_code_combinations.segment15%TYPE;

202: l_1st_Segment11 gl_code_combinations.segment11%TYPE;
203: l_1st_Segment12 gl_code_combinations.segment12%TYPE;
204: l_1st_Segment13 gl_code_combinations.segment13%TYPE;
205: l_1st_Segment14 gl_code_combinations.segment14%TYPE;
206: l_1st_Segment15 gl_code_combinations.segment15%TYPE;
207: l_1st_Segment16 gl_code_combinations.segment16%TYPE;
208: l_1st_Segment17 gl_code_combinations.segment17%TYPE;
209: l_1st_Segment18 gl_code_combinations.segment18%TYPE;
210: l_1st_Segment19 gl_code_combinations.segment19%TYPE;

Line 207: l_1st_Segment16 gl_code_combinations.segment16%TYPE;

203: l_1st_Segment12 gl_code_combinations.segment12%TYPE;
204: l_1st_Segment13 gl_code_combinations.segment13%TYPE;
205: l_1st_Segment14 gl_code_combinations.segment14%TYPE;
206: l_1st_Segment15 gl_code_combinations.segment15%TYPE;
207: l_1st_Segment16 gl_code_combinations.segment16%TYPE;
208: l_1st_Segment17 gl_code_combinations.segment17%TYPE;
209: l_1st_Segment18 gl_code_combinations.segment18%TYPE;
210: l_1st_Segment19 gl_code_combinations.segment19%TYPE;
211: l_1st_Segment20 gl_code_combinations.segment20%TYPE;

Line 208: l_1st_Segment17 gl_code_combinations.segment17%TYPE;

204: l_1st_Segment13 gl_code_combinations.segment13%TYPE;
205: l_1st_Segment14 gl_code_combinations.segment14%TYPE;
206: l_1st_Segment15 gl_code_combinations.segment15%TYPE;
207: l_1st_Segment16 gl_code_combinations.segment16%TYPE;
208: l_1st_Segment17 gl_code_combinations.segment17%TYPE;
209: l_1st_Segment18 gl_code_combinations.segment18%TYPE;
210: l_1st_Segment19 gl_code_combinations.segment19%TYPE;
211: l_1st_Segment20 gl_code_combinations.segment20%TYPE;
212: l_1st_Segment21 gl_code_combinations.segment21%TYPE;

Line 209: l_1st_Segment18 gl_code_combinations.segment18%TYPE;

205: l_1st_Segment14 gl_code_combinations.segment14%TYPE;
206: l_1st_Segment15 gl_code_combinations.segment15%TYPE;
207: l_1st_Segment16 gl_code_combinations.segment16%TYPE;
208: l_1st_Segment17 gl_code_combinations.segment17%TYPE;
209: l_1st_Segment18 gl_code_combinations.segment18%TYPE;
210: l_1st_Segment19 gl_code_combinations.segment19%TYPE;
211: l_1st_Segment20 gl_code_combinations.segment20%TYPE;
212: l_1st_Segment21 gl_code_combinations.segment21%TYPE;
213: l_1st_Segment22 gl_code_combinations.segment22%TYPE;

Line 210: l_1st_Segment19 gl_code_combinations.segment19%TYPE;

206: l_1st_Segment15 gl_code_combinations.segment15%TYPE;
207: l_1st_Segment16 gl_code_combinations.segment16%TYPE;
208: l_1st_Segment17 gl_code_combinations.segment17%TYPE;
209: l_1st_Segment18 gl_code_combinations.segment18%TYPE;
210: l_1st_Segment19 gl_code_combinations.segment19%TYPE;
211: l_1st_Segment20 gl_code_combinations.segment20%TYPE;
212: l_1st_Segment21 gl_code_combinations.segment21%TYPE;
213: l_1st_Segment22 gl_code_combinations.segment22%TYPE;
214: l_1st_Segment23 gl_code_combinations.segment23%TYPE;

Line 211: l_1st_Segment20 gl_code_combinations.segment20%TYPE;

207: l_1st_Segment16 gl_code_combinations.segment16%TYPE;
208: l_1st_Segment17 gl_code_combinations.segment17%TYPE;
209: l_1st_Segment18 gl_code_combinations.segment18%TYPE;
210: l_1st_Segment19 gl_code_combinations.segment19%TYPE;
211: l_1st_Segment20 gl_code_combinations.segment20%TYPE;
212: l_1st_Segment21 gl_code_combinations.segment21%TYPE;
213: l_1st_Segment22 gl_code_combinations.segment22%TYPE;
214: l_1st_Segment23 gl_code_combinations.segment23%TYPE;
215: l_1st_Segment24 gl_code_combinations.segment24%TYPE;

Line 212: l_1st_Segment21 gl_code_combinations.segment21%TYPE;

208: l_1st_Segment17 gl_code_combinations.segment17%TYPE;
209: l_1st_Segment18 gl_code_combinations.segment18%TYPE;
210: l_1st_Segment19 gl_code_combinations.segment19%TYPE;
211: l_1st_Segment20 gl_code_combinations.segment20%TYPE;
212: l_1st_Segment21 gl_code_combinations.segment21%TYPE;
213: l_1st_Segment22 gl_code_combinations.segment22%TYPE;
214: l_1st_Segment23 gl_code_combinations.segment23%TYPE;
215: l_1st_Segment24 gl_code_combinations.segment24%TYPE;
216: l_1st_Segment25 gl_code_combinations.segment25%TYPE;

Line 213: l_1st_Segment22 gl_code_combinations.segment22%TYPE;

209: l_1st_Segment18 gl_code_combinations.segment18%TYPE;
210: l_1st_Segment19 gl_code_combinations.segment19%TYPE;
211: l_1st_Segment20 gl_code_combinations.segment20%TYPE;
212: l_1st_Segment21 gl_code_combinations.segment21%TYPE;
213: l_1st_Segment22 gl_code_combinations.segment22%TYPE;
214: l_1st_Segment23 gl_code_combinations.segment23%TYPE;
215: l_1st_Segment24 gl_code_combinations.segment24%TYPE;
216: l_1st_Segment25 gl_code_combinations.segment25%TYPE;
217: l_1st_Segment26 gl_code_combinations.segment26%TYPE;

Line 214: l_1st_Segment23 gl_code_combinations.segment23%TYPE;

210: l_1st_Segment19 gl_code_combinations.segment19%TYPE;
211: l_1st_Segment20 gl_code_combinations.segment20%TYPE;
212: l_1st_Segment21 gl_code_combinations.segment21%TYPE;
213: l_1st_Segment22 gl_code_combinations.segment22%TYPE;
214: l_1st_Segment23 gl_code_combinations.segment23%TYPE;
215: l_1st_Segment24 gl_code_combinations.segment24%TYPE;
216: l_1st_Segment25 gl_code_combinations.segment25%TYPE;
217: l_1st_Segment26 gl_code_combinations.segment26%TYPE;
218: l_1st_Segment27 gl_code_combinations.segment27%TYPE;

Line 215: l_1st_Segment24 gl_code_combinations.segment24%TYPE;

211: l_1st_Segment20 gl_code_combinations.segment20%TYPE;
212: l_1st_Segment21 gl_code_combinations.segment21%TYPE;
213: l_1st_Segment22 gl_code_combinations.segment22%TYPE;
214: l_1st_Segment23 gl_code_combinations.segment23%TYPE;
215: l_1st_Segment24 gl_code_combinations.segment24%TYPE;
216: l_1st_Segment25 gl_code_combinations.segment25%TYPE;
217: l_1st_Segment26 gl_code_combinations.segment26%TYPE;
218: l_1st_Segment27 gl_code_combinations.segment27%TYPE;
219: l_1st_Segment28 gl_code_combinations.segment28%TYPE;

Line 216: l_1st_Segment25 gl_code_combinations.segment25%TYPE;

212: l_1st_Segment21 gl_code_combinations.segment21%TYPE;
213: l_1st_Segment22 gl_code_combinations.segment22%TYPE;
214: l_1st_Segment23 gl_code_combinations.segment23%TYPE;
215: l_1st_Segment24 gl_code_combinations.segment24%TYPE;
216: l_1st_Segment25 gl_code_combinations.segment25%TYPE;
217: l_1st_Segment26 gl_code_combinations.segment26%TYPE;
218: l_1st_Segment27 gl_code_combinations.segment27%TYPE;
219: l_1st_Segment28 gl_code_combinations.segment28%TYPE;
220: l_1st_Segment29 gl_code_combinations.segment29%TYPE;

Line 217: l_1st_Segment26 gl_code_combinations.segment26%TYPE;

213: l_1st_Segment22 gl_code_combinations.segment22%TYPE;
214: l_1st_Segment23 gl_code_combinations.segment23%TYPE;
215: l_1st_Segment24 gl_code_combinations.segment24%TYPE;
216: l_1st_Segment25 gl_code_combinations.segment25%TYPE;
217: l_1st_Segment26 gl_code_combinations.segment26%TYPE;
218: l_1st_Segment27 gl_code_combinations.segment27%TYPE;
219: l_1st_Segment28 gl_code_combinations.segment28%TYPE;
220: l_1st_Segment29 gl_code_combinations.segment29%TYPE;
221: l_1st_Segment30 gl_code_combinations.segment30%TYPE;

Line 218: l_1st_Segment27 gl_code_combinations.segment27%TYPE;

214: l_1st_Segment23 gl_code_combinations.segment23%TYPE;
215: l_1st_Segment24 gl_code_combinations.segment24%TYPE;
216: l_1st_Segment25 gl_code_combinations.segment25%TYPE;
217: l_1st_Segment26 gl_code_combinations.segment26%TYPE;
218: l_1st_Segment27 gl_code_combinations.segment27%TYPE;
219: l_1st_Segment28 gl_code_combinations.segment28%TYPE;
220: l_1st_Segment29 gl_code_combinations.segment29%TYPE;
221: l_1st_Segment30 gl_code_combinations.segment30%TYPE;
222:

Line 219: l_1st_Segment28 gl_code_combinations.segment28%TYPE;

215: l_1st_Segment24 gl_code_combinations.segment24%TYPE;
216: l_1st_Segment25 gl_code_combinations.segment25%TYPE;
217: l_1st_Segment26 gl_code_combinations.segment26%TYPE;
218: l_1st_Segment27 gl_code_combinations.segment27%TYPE;
219: l_1st_Segment28 gl_code_combinations.segment28%TYPE;
220: l_1st_Segment29 gl_code_combinations.segment29%TYPE;
221: l_1st_Segment30 gl_code_combinations.segment30%TYPE;
222:
223: l_Segment1 gl_code_combinations.segment1%TYPE;

Line 220: l_1st_Segment29 gl_code_combinations.segment29%TYPE;

216: l_1st_Segment25 gl_code_combinations.segment25%TYPE;
217: l_1st_Segment26 gl_code_combinations.segment26%TYPE;
218: l_1st_Segment27 gl_code_combinations.segment27%TYPE;
219: l_1st_Segment28 gl_code_combinations.segment28%TYPE;
220: l_1st_Segment29 gl_code_combinations.segment29%TYPE;
221: l_1st_Segment30 gl_code_combinations.segment30%TYPE;
222:
223: l_Segment1 gl_code_combinations.segment1%TYPE;
224: l_Segment2 gl_code_combinations.segment2%TYPE;

Line 221: l_1st_Segment30 gl_code_combinations.segment30%TYPE;

217: l_1st_Segment26 gl_code_combinations.segment26%TYPE;
218: l_1st_Segment27 gl_code_combinations.segment27%TYPE;
219: l_1st_Segment28 gl_code_combinations.segment28%TYPE;
220: l_1st_Segment29 gl_code_combinations.segment29%TYPE;
221: l_1st_Segment30 gl_code_combinations.segment30%TYPE;
222:
223: l_Segment1 gl_code_combinations.segment1%TYPE;
224: l_Segment2 gl_code_combinations.segment2%TYPE;
225: l_Segment3 gl_code_combinations.segment3%TYPE;

Line 223: l_Segment1 gl_code_combinations.segment1%TYPE;

219: l_1st_Segment28 gl_code_combinations.segment28%TYPE;
220: l_1st_Segment29 gl_code_combinations.segment29%TYPE;
221: l_1st_Segment30 gl_code_combinations.segment30%TYPE;
222:
223: l_Segment1 gl_code_combinations.segment1%TYPE;
224: l_Segment2 gl_code_combinations.segment2%TYPE;
225: l_Segment3 gl_code_combinations.segment3%TYPE;
226: l_Segment4 gl_code_combinations.segment4%TYPE;
227: l_Segment5 gl_code_combinations.segment5%TYPE;

Line 224: l_Segment2 gl_code_combinations.segment2%TYPE;

220: l_1st_Segment29 gl_code_combinations.segment29%TYPE;
221: l_1st_Segment30 gl_code_combinations.segment30%TYPE;
222:
223: l_Segment1 gl_code_combinations.segment1%TYPE;
224: l_Segment2 gl_code_combinations.segment2%TYPE;
225: l_Segment3 gl_code_combinations.segment3%TYPE;
226: l_Segment4 gl_code_combinations.segment4%TYPE;
227: l_Segment5 gl_code_combinations.segment5%TYPE;
228: l_Segment6 gl_code_combinations.segment6%TYPE;

Line 225: l_Segment3 gl_code_combinations.segment3%TYPE;

221: l_1st_Segment30 gl_code_combinations.segment30%TYPE;
222:
223: l_Segment1 gl_code_combinations.segment1%TYPE;
224: l_Segment2 gl_code_combinations.segment2%TYPE;
225: l_Segment3 gl_code_combinations.segment3%TYPE;
226: l_Segment4 gl_code_combinations.segment4%TYPE;
227: l_Segment5 gl_code_combinations.segment5%TYPE;
228: l_Segment6 gl_code_combinations.segment6%TYPE;
229: l_Segment7 gl_code_combinations.segment7%TYPE;

Line 226: l_Segment4 gl_code_combinations.segment4%TYPE;

222:
223: l_Segment1 gl_code_combinations.segment1%TYPE;
224: l_Segment2 gl_code_combinations.segment2%TYPE;
225: l_Segment3 gl_code_combinations.segment3%TYPE;
226: l_Segment4 gl_code_combinations.segment4%TYPE;
227: l_Segment5 gl_code_combinations.segment5%TYPE;
228: l_Segment6 gl_code_combinations.segment6%TYPE;
229: l_Segment7 gl_code_combinations.segment7%TYPE;
230: l_Segment8 gl_code_combinations.segment8%TYPE;

Line 227: l_Segment5 gl_code_combinations.segment5%TYPE;

223: l_Segment1 gl_code_combinations.segment1%TYPE;
224: l_Segment2 gl_code_combinations.segment2%TYPE;
225: l_Segment3 gl_code_combinations.segment3%TYPE;
226: l_Segment4 gl_code_combinations.segment4%TYPE;
227: l_Segment5 gl_code_combinations.segment5%TYPE;
228: l_Segment6 gl_code_combinations.segment6%TYPE;
229: l_Segment7 gl_code_combinations.segment7%TYPE;
230: l_Segment8 gl_code_combinations.segment8%TYPE;
231: l_Segment9 gl_code_combinations.segment9%TYPE;

Line 228: l_Segment6 gl_code_combinations.segment6%TYPE;

224: l_Segment2 gl_code_combinations.segment2%TYPE;
225: l_Segment3 gl_code_combinations.segment3%TYPE;
226: l_Segment4 gl_code_combinations.segment4%TYPE;
227: l_Segment5 gl_code_combinations.segment5%TYPE;
228: l_Segment6 gl_code_combinations.segment6%TYPE;
229: l_Segment7 gl_code_combinations.segment7%TYPE;
230: l_Segment8 gl_code_combinations.segment8%TYPE;
231: l_Segment9 gl_code_combinations.segment9%TYPE;
232: l_Segment10 gl_code_combinations.segment10%TYPE;

Line 229: l_Segment7 gl_code_combinations.segment7%TYPE;

225: l_Segment3 gl_code_combinations.segment3%TYPE;
226: l_Segment4 gl_code_combinations.segment4%TYPE;
227: l_Segment5 gl_code_combinations.segment5%TYPE;
228: l_Segment6 gl_code_combinations.segment6%TYPE;
229: l_Segment7 gl_code_combinations.segment7%TYPE;
230: l_Segment8 gl_code_combinations.segment8%TYPE;
231: l_Segment9 gl_code_combinations.segment9%TYPE;
232: l_Segment10 gl_code_combinations.segment10%TYPE;
233: l_Segment11 gl_code_combinations.segment11%TYPE;

Line 230: l_Segment8 gl_code_combinations.segment8%TYPE;

226: l_Segment4 gl_code_combinations.segment4%TYPE;
227: l_Segment5 gl_code_combinations.segment5%TYPE;
228: l_Segment6 gl_code_combinations.segment6%TYPE;
229: l_Segment7 gl_code_combinations.segment7%TYPE;
230: l_Segment8 gl_code_combinations.segment8%TYPE;
231: l_Segment9 gl_code_combinations.segment9%TYPE;
232: l_Segment10 gl_code_combinations.segment10%TYPE;
233: l_Segment11 gl_code_combinations.segment11%TYPE;
234: l_Segment12 gl_code_combinations.segment12%TYPE;

Line 231: l_Segment9 gl_code_combinations.segment9%TYPE;

227: l_Segment5 gl_code_combinations.segment5%TYPE;
228: l_Segment6 gl_code_combinations.segment6%TYPE;
229: l_Segment7 gl_code_combinations.segment7%TYPE;
230: l_Segment8 gl_code_combinations.segment8%TYPE;
231: l_Segment9 gl_code_combinations.segment9%TYPE;
232: l_Segment10 gl_code_combinations.segment10%TYPE;
233: l_Segment11 gl_code_combinations.segment11%TYPE;
234: l_Segment12 gl_code_combinations.segment12%TYPE;
235: l_Segment13 gl_code_combinations.segment13%TYPE;

Line 232: l_Segment10 gl_code_combinations.segment10%TYPE;

228: l_Segment6 gl_code_combinations.segment6%TYPE;
229: l_Segment7 gl_code_combinations.segment7%TYPE;
230: l_Segment8 gl_code_combinations.segment8%TYPE;
231: l_Segment9 gl_code_combinations.segment9%TYPE;
232: l_Segment10 gl_code_combinations.segment10%TYPE;
233: l_Segment11 gl_code_combinations.segment11%TYPE;
234: l_Segment12 gl_code_combinations.segment12%TYPE;
235: l_Segment13 gl_code_combinations.segment13%TYPE;
236: l_Segment14 gl_code_combinations.segment14%TYPE;

Line 233: l_Segment11 gl_code_combinations.segment11%TYPE;

229: l_Segment7 gl_code_combinations.segment7%TYPE;
230: l_Segment8 gl_code_combinations.segment8%TYPE;
231: l_Segment9 gl_code_combinations.segment9%TYPE;
232: l_Segment10 gl_code_combinations.segment10%TYPE;
233: l_Segment11 gl_code_combinations.segment11%TYPE;
234: l_Segment12 gl_code_combinations.segment12%TYPE;
235: l_Segment13 gl_code_combinations.segment13%TYPE;
236: l_Segment14 gl_code_combinations.segment14%TYPE;
237: l_Segment15 gl_code_combinations.segment15%TYPE;

Line 234: l_Segment12 gl_code_combinations.segment12%TYPE;

230: l_Segment8 gl_code_combinations.segment8%TYPE;
231: l_Segment9 gl_code_combinations.segment9%TYPE;
232: l_Segment10 gl_code_combinations.segment10%TYPE;
233: l_Segment11 gl_code_combinations.segment11%TYPE;
234: l_Segment12 gl_code_combinations.segment12%TYPE;
235: l_Segment13 gl_code_combinations.segment13%TYPE;
236: l_Segment14 gl_code_combinations.segment14%TYPE;
237: l_Segment15 gl_code_combinations.segment15%TYPE;
238: l_Segment16 gl_code_combinations.segment16%TYPE;

Line 235: l_Segment13 gl_code_combinations.segment13%TYPE;

231: l_Segment9 gl_code_combinations.segment9%TYPE;
232: l_Segment10 gl_code_combinations.segment10%TYPE;
233: l_Segment11 gl_code_combinations.segment11%TYPE;
234: l_Segment12 gl_code_combinations.segment12%TYPE;
235: l_Segment13 gl_code_combinations.segment13%TYPE;
236: l_Segment14 gl_code_combinations.segment14%TYPE;
237: l_Segment15 gl_code_combinations.segment15%TYPE;
238: l_Segment16 gl_code_combinations.segment16%TYPE;
239: l_Segment17 gl_code_combinations.segment17%TYPE;

Line 236: l_Segment14 gl_code_combinations.segment14%TYPE;

232: l_Segment10 gl_code_combinations.segment10%TYPE;
233: l_Segment11 gl_code_combinations.segment11%TYPE;
234: l_Segment12 gl_code_combinations.segment12%TYPE;
235: l_Segment13 gl_code_combinations.segment13%TYPE;
236: l_Segment14 gl_code_combinations.segment14%TYPE;
237: l_Segment15 gl_code_combinations.segment15%TYPE;
238: l_Segment16 gl_code_combinations.segment16%TYPE;
239: l_Segment17 gl_code_combinations.segment17%TYPE;
240: l_Segment18 gl_code_combinations.segment18%TYPE;

Line 237: l_Segment15 gl_code_combinations.segment15%TYPE;

233: l_Segment11 gl_code_combinations.segment11%TYPE;
234: l_Segment12 gl_code_combinations.segment12%TYPE;
235: l_Segment13 gl_code_combinations.segment13%TYPE;
236: l_Segment14 gl_code_combinations.segment14%TYPE;
237: l_Segment15 gl_code_combinations.segment15%TYPE;
238: l_Segment16 gl_code_combinations.segment16%TYPE;
239: l_Segment17 gl_code_combinations.segment17%TYPE;
240: l_Segment18 gl_code_combinations.segment18%TYPE;
241: l_Segment19 gl_code_combinations.segment19%TYPE;

Line 238: l_Segment16 gl_code_combinations.segment16%TYPE;

234: l_Segment12 gl_code_combinations.segment12%TYPE;
235: l_Segment13 gl_code_combinations.segment13%TYPE;
236: l_Segment14 gl_code_combinations.segment14%TYPE;
237: l_Segment15 gl_code_combinations.segment15%TYPE;
238: l_Segment16 gl_code_combinations.segment16%TYPE;
239: l_Segment17 gl_code_combinations.segment17%TYPE;
240: l_Segment18 gl_code_combinations.segment18%TYPE;
241: l_Segment19 gl_code_combinations.segment19%TYPE;
242: l_Segment20 gl_code_combinations.segment20%TYPE;

Line 239: l_Segment17 gl_code_combinations.segment17%TYPE;

235: l_Segment13 gl_code_combinations.segment13%TYPE;
236: l_Segment14 gl_code_combinations.segment14%TYPE;
237: l_Segment15 gl_code_combinations.segment15%TYPE;
238: l_Segment16 gl_code_combinations.segment16%TYPE;
239: l_Segment17 gl_code_combinations.segment17%TYPE;
240: l_Segment18 gl_code_combinations.segment18%TYPE;
241: l_Segment19 gl_code_combinations.segment19%TYPE;
242: l_Segment20 gl_code_combinations.segment20%TYPE;
243: l_Segment21 gl_code_combinations.segment21%TYPE;

Line 240: l_Segment18 gl_code_combinations.segment18%TYPE;

236: l_Segment14 gl_code_combinations.segment14%TYPE;
237: l_Segment15 gl_code_combinations.segment15%TYPE;
238: l_Segment16 gl_code_combinations.segment16%TYPE;
239: l_Segment17 gl_code_combinations.segment17%TYPE;
240: l_Segment18 gl_code_combinations.segment18%TYPE;
241: l_Segment19 gl_code_combinations.segment19%TYPE;
242: l_Segment20 gl_code_combinations.segment20%TYPE;
243: l_Segment21 gl_code_combinations.segment21%TYPE;
244: l_Segment22 gl_code_combinations.segment22%TYPE;

Line 241: l_Segment19 gl_code_combinations.segment19%TYPE;

237: l_Segment15 gl_code_combinations.segment15%TYPE;
238: l_Segment16 gl_code_combinations.segment16%TYPE;
239: l_Segment17 gl_code_combinations.segment17%TYPE;
240: l_Segment18 gl_code_combinations.segment18%TYPE;
241: l_Segment19 gl_code_combinations.segment19%TYPE;
242: l_Segment20 gl_code_combinations.segment20%TYPE;
243: l_Segment21 gl_code_combinations.segment21%TYPE;
244: l_Segment22 gl_code_combinations.segment22%TYPE;
245: l_Segment23 gl_code_combinations.segment23%TYPE;

Line 242: l_Segment20 gl_code_combinations.segment20%TYPE;

238: l_Segment16 gl_code_combinations.segment16%TYPE;
239: l_Segment17 gl_code_combinations.segment17%TYPE;
240: l_Segment18 gl_code_combinations.segment18%TYPE;
241: l_Segment19 gl_code_combinations.segment19%TYPE;
242: l_Segment20 gl_code_combinations.segment20%TYPE;
243: l_Segment21 gl_code_combinations.segment21%TYPE;
244: l_Segment22 gl_code_combinations.segment22%TYPE;
245: l_Segment23 gl_code_combinations.segment23%TYPE;
246: l_Segment24 gl_code_combinations.segment24%TYPE;

Line 243: l_Segment21 gl_code_combinations.segment21%TYPE;

239: l_Segment17 gl_code_combinations.segment17%TYPE;
240: l_Segment18 gl_code_combinations.segment18%TYPE;
241: l_Segment19 gl_code_combinations.segment19%TYPE;
242: l_Segment20 gl_code_combinations.segment20%TYPE;
243: l_Segment21 gl_code_combinations.segment21%TYPE;
244: l_Segment22 gl_code_combinations.segment22%TYPE;
245: l_Segment23 gl_code_combinations.segment23%TYPE;
246: l_Segment24 gl_code_combinations.segment24%TYPE;
247: l_Segment25 gl_code_combinations.segment25%TYPE;

Line 244: l_Segment22 gl_code_combinations.segment22%TYPE;

240: l_Segment18 gl_code_combinations.segment18%TYPE;
241: l_Segment19 gl_code_combinations.segment19%TYPE;
242: l_Segment20 gl_code_combinations.segment20%TYPE;
243: l_Segment21 gl_code_combinations.segment21%TYPE;
244: l_Segment22 gl_code_combinations.segment22%TYPE;
245: l_Segment23 gl_code_combinations.segment23%TYPE;
246: l_Segment24 gl_code_combinations.segment24%TYPE;
247: l_Segment25 gl_code_combinations.segment25%TYPE;
248: l_Segment26 gl_code_combinations.segment26%TYPE;

Line 245: l_Segment23 gl_code_combinations.segment23%TYPE;

241: l_Segment19 gl_code_combinations.segment19%TYPE;
242: l_Segment20 gl_code_combinations.segment20%TYPE;
243: l_Segment21 gl_code_combinations.segment21%TYPE;
244: l_Segment22 gl_code_combinations.segment22%TYPE;
245: l_Segment23 gl_code_combinations.segment23%TYPE;
246: l_Segment24 gl_code_combinations.segment24%TYPE;
247: l_Segment25 gl_code_combinations.segment25%TYPE;
248: l_Segment26 gl_code_combinations.segment26%TYPE;
249: l_Segment27 gl_code_combinations.segment27%TYPE;

Line 246: l_Segment24 gl_code_combinations.segment24%TYPE;

242: l_Segment20 gl_code_combinations.segment20%TYPE;
243: l_Segment21 gl_code_combinations.segment21%TYPE;
244: l_Segment22 gl_code_combinations.segment22%TYPE;
245: l_Segment23 gl_code_combinations.segment23%TYPE;
246: l_Segment24 gl_code_combinations.segment24%TYPE;
247: l_Segment25 gl_code_combinations.segment25%TYPE;
248: l_Segment26 gl_code_combinations.segment26%TYPE;
249: l_Segment27 gl_code_combinations.segment27%TYPE;
250: l_Segment28 gl_code_combinations.segment28%TYPE;

Line 247: l_Segment25 gl_code_combinations.segment25%TYPE;

243: l_Segment21 gl_code_combinations.segment21%TYPE;
244: l_Segment22 gl_code_combinations.segment22%TYPE;
245: l_Segment23 gl_code_combinations.segment23%TYPE;
246: l_Segment24 gl_code_combinations.segment24%TYPE;
247: l_Segment25 gl_code_combinations.segment25%TYPE;
248: l_Segment26 gl_code_combinations.segment26%TYPE;
249: l_Segment27 gl_code_combinations.segment27%TYPE;
250: l_Segment28 gl_code_combinations.segment28%TYPE;
251: l_Segment29 gl_code_combinations.segment29%TYPE;

Line 248: l_Segment26 gl_code_combinations.segment26%TYPE;

244: l_Segment22 gl_code_combinations.segment22%TYPE;
245: l_Segment23 gl_code_combinations.segment23%TYPE;
246: l_Segment24 gl_code_combinations.segment24%TYPE;
247: l_Segment25 gl_code_combinations.segment25%TYPE;
248: l_Segment26 gl_code_combinations.segment26%TYPE;
249: l_Segment27 gl_code_combinations.segment27%TYPE;
250: l_Segment28 gl_code_combinations.segment28%TYPE;
251: l_Segment29 gl_code_combinations.segment29%TYPE;
252: l_Segment30 gl_code_combinations.segment30%TYPE;

Line 249: l_Segment27 gl_code_combinations.segment27%TYPE;

245: l_Segment23 gl_code_combinations.segment23%TYPE;
246: l_Segment24 gl_code_combinations.segment24%TYPE;
247: l_Segment25 gl_code_combinations.segment25%TYPE;
248: l_Segment26 gl_code_combinations.segment26%TYPE;
249: l_Segment27 gl_code_combinations.segment27%TYPE;
250: l_Segment28 gl_code_combinations.segment28%TYPE;
251: l_Segment29 gl_code_combinations.segment29%TYPE;
252: l_Segment30 gl_code_combinations.segment30%TYPE;
253:

Line 250: l_Segment28 gl_code_combinations.segment28%TYPE;

246: l_Segment24 gl_code_combinations.segment24%TYPE;
247: l_Segment25 gl_code_combinations.segment25%TYPE;
248: l_Segment26 gl_code_combinations.segment26%TYPE;
249: l_Segment27 gl_code_combinations.segment27%TYPE;
250: l_Segment28 gl_code_combinations.segment28%TYPE;
251: l_Segment29 gl_code_combinations.segment29%TYPE;
252: l_Segment30 gl_code_combinations.segment30%TYPE;
253:
254: CURSOR multiple_distributions IS

Line 251: l_Segment29 gl_code_combinations.segment29%TYPE;

247: l_Segment25 gl_code_combinations.segment25%TYPE;
248: l_Segment26 gl_code_combinations.segment26%TYPE;
249: l_Segment27 gl_code_combinations.segment27%TYPE;
250: l_Segment28 gl_code_combinations.segment28%TYPE;
251: l_Segment29 gl_code_combinations.segment29%TYPE;
252: l_Segment30 gl_code_combinations.segment30%TYPE;
253:
254: CURSOR multiple_distributions IS
255: SELECT fdh.assigned_to,

Line 252: l_Segment30 gl_code_combinations.segment30%TYPE;

248: l_Segment26 gl_code_combinations.segment26%TYPE;
249: l_Segment27 gl_code_combinations.segment27%TYPE;
250: l_Segment28 gl_code_combinations.segment28%TYPE;
251: l_Segment29 gl_code_combinations.segment29%TYPE;
252: l_Segment30 gl_code_combinations.segment30%TYPE;
253:
254: CURSOR multiple_distributions IS
255: SELECT fdh.assigned_to,
256: fdh.location_id,

Line 273: gl_code_combinations gcc

269: gcc.segment25, gcc.segment26,
270: gcc.segment27, gcc.segment28,
271: gcc.segment29, gcc.segment30
272: FROM fa_distribution_history fdh,
273: gl_code_combinations gcc
274: WHERE fdh.asset_id = X_Asset_Id
275: AND fdh.code_combination_id = gcc.code_combination_id
276: AND fdh.date_ineffective IS NULL;
277:

Line 499: gl_code_combinations gcc

495: fad.location_id,
496: fad.assigned_to,
497: fad.units_assigned
498: FROM fa_distribution_history fad,
499: gl_code_combinations gcc
500: WHERE fad.asset_id = x_asset_id
501: AND fad.date_ineffective IS NULL
502: AND fad.code_combination_id = gcc.code_combination_id
503: AND (fad.assigned_to = G_Employee_Id

Line 1195: gl_code_combinations gcc

1191: AND fab.book_type_code = fbc.book_type_code
1192: AND fbc.date_ineffective is null
1193: AND EXISTS (SELECT null
1194: FROM fa_distribution_history fad,
1195: gl_code_combinations gcc
1196: WHERE fad.asset_id = faa.asset_id
1197: AND fad.code_combination_id = gcc.code_combination_id
1198: AND (fad.assigned_to = G_Employee_Id
1199: OR G_Employee_Id IS NULL)

Line 3207: gl_code_combinations gcc

3203: AND fab.book_type_code = fbc.book_type_code
3204: AND fbc.date_ineffective is null
3205: AND EXISTS (SELECT null
3206: FROM fa_distribution_history fad,
3207: gl_code_combinations gcc
3208: WHERE fad.asset_id = faa.asset_id
3209: AND fad.code_combination_id = gcc.code_combination_id
3210: AND (fad.assigned_to = G_Employee_Id
3211: OR G_Employee_Id IS NULL)

Line 3363: gl_code_combinations gcc,

3359: AND (fth.transaction_date_entered > G_Retirement_Date and
3360: fth.transaction_type_code not in ('FULL RETIREMENT','REINSTATEMENT')))
3361: AND faa.asset_id in (SELECT faa2.asset_id
3362: FROM fa_additions_b faa2,
3363: gl_code_combinations gcc,
3364: fa_distribution_history fad
3365: WHERE fad.asset_id = faa2.asset_id
3366: AND fad.code_combination_id = gcc.code_combination_id
3367: AND (fad.assigned_to = G_Employee_Id