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.HR_NL_UTILITY dependencies on DUAL

Line 161: from dual;

157: || decode (p_per_information1,'','',p_per_information1 || ' ')
158: || decode (l_per_information5,'','',l_per_information5 || ' ')
159: || l_per_information6
160: into l_full_name
161: from dual;
162: elsif p_per_information4 = 'FORMAT1' then
163: select decode (p_per_information1,'','',p_per_information1 || ' ')
164: || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct || ' ')
165: || p_last_name

Line 167: from dual;

163: select decode (p_per_information1,'','',p_per_information1 || ' ')
164: || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct || ' ')
165: || p_last_name
166: into l_full_name
167: from dual;
168: elsif p_per_information4 = 'FORMAT2' then
169: if (p_pre_name_adjunct is not null or p_last_name is not null) then
170: select decode (p_per_information1,'','',p_per_information1 || ' ')
171: || decode (l_per_information5,'','',l_per_information5 || ' ')

Line 177: from dual;

173: || '-'
174: || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct || ' ')
175: || p_last_name
176: into l_full_name
177: from dual;
178: else
179: select decode (p_per_information1,'','',p_per_information1 || ' ')
180: || decode (l_per_information5,'','',l_per_information5 || ' ')
181: || decode (l_per_information6,'','',l_per_information6 || ' ')

Line 185: from dual;

181: || decode (l_per_information6,'','',l_per_information6 || ' ')
182: || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct || ' ')
183: || p_last_name
184: into l_full_name
185: from dual;
186: end if;
187: elsif p_per_information4 = 'FORMAT3' then
188: if (l_per_information5 is not null or l_per_information6 is not null) then
189: select decode (p_per_information1,'','',p_per_information1 || ' ')

Line 196: from dual;

192: || '-'
193: || decode (l_per_information5,'','',l_per_information5 || ' ')
194: || l_per_information6
195: into l_full_name
196: from dual;
197: else
198: select decode (p_per_information1,'','',p_per_information1 || ' ')
199: || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct || ' ')
200: || p_last_name || ' '

Line 204: from dual;

200: || p_last_name || ' '
201: || decode (l_per_information5,'','',l_per_information5 || ' ')
202: || l_per_information6
203: into l_full_name
204: from dual;
205: end if;
206: elsif p_per_information4 = 'FORMAT4' then
207: if (p_per_information1 is not null or l_per_information5 is not null or l_per_information6 is not null) then
208: select p_last_name || ' '

Line 215: from dual;

211: || decode (p_per_information1,'','',p_per_information1 || ' ')
212: || decode (l_per_information5,'','',l_per_information5 || ' ')
213: || l_per_information6
214: into l_full_name
215: from dual;
216: else
217: select p_last_name || ' '
218: || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct || ' ')
219: || decode (p_per_information1,'','',p_per_information1 || ' ')

Line 223: from dual;

219: || decode (p_per_information1,'','',p_per_information1 || ' ')
220: || decode (l_per_information5,'','',l_per_information5 || ' ')
221: || l_per_information6
222: into l_full_name
223: from dual;
224: end if;
225: elsif p_per_information4 = 'FORMAT5' then
226: select decode (p_per_information1,'','',p_per_information1 || ' ')
227: || decode (l_per_information5,'','',l_per_information5 || ' ')

Line 230: from dual;

226: select decode (p_per_information1,'','',p_per_information1 || ' ')
227: || decode (l_per_information5,'','',l_per_information5 || ' ')
228: || l_per_information6
229: into l_full_name
230: from dual;
231: elsif p_per_information4 = 'FORMAT6' then
232: if (p_per_information1 is not null or p_pre_name_adjunct is not null or p_last_name is not null) then
233: select decode (l_per_information6,'','',l_per_information6 || ' ')
234: || decode (l_per_information5,'','',l_per_information5)

Line 240: from dual;

236: || decode (p_per_information1,'','',p_per_information1 || ' ')
237: || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct || ' ')
238: || p_last_name
239: into l_full_name
240: from dual;
241: else
242: select decode (l_per_information6,'','',l_per_information6 || ' ')
243: || decode (l_per_information5,'','',l_per_information5 || ' ')
244: || decode (p_per_information1,'','',p_per_information1 || ' ')

Line 248: from dual;

244: || decode (p_per_information1,'','',p_per_information1 || ' ')
245: || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct || ' ')
246: || p_last_name
247: into l_full_name
248: from dual;
249: end if;
250: elsif p_per_information4 = 'FORMAT7' then
251: select p_last_name || ' '
252: || decode (p_first_name,'','',p_first_name|| ' ')

Line 255: from dual;

251: select p_last_name || ' '
252: || decode (p_first_name,'','',p_first_name|| ' ')
253: || p_pre_name_adjunct
254: into l_full_name
255: from dual;
256: elsif p_per_information4 = 'FORMAT8' then
257: select p_last_name || ' '
258: || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct|| ' ')
259: || p_first_name

Line 261: from dual;

257: select p_last_name || ' '
258: || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct|| ' ')
259: || p_first_name
260: into l_full_name
261: from dual;
262: elsif p_per_information4 = 'FORMAT9' then
263: select decode (p_first_name,'','',p_first_name|| ' ')
264: || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct|| ' ')
265: || p_last_name

Line 267: from dual;

263: select decode (p_first_name,'','',p_first_name|| ' ')
264: || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct|| ' ')
265: || p_last_name
266: into l_full_name
267: from dual;
268: elsif p_per_information4 = 'FORMAT10' then
269: if (p_pre_name_adjunct is not null or p_last_name is not null) then
270: select decode (p_first_name,'','',p_first_name|| ' ')
271: || decode (l_per_information5,'','',l_per_information5 || ' ')

Line 277: from dual;

273: || '-'
274: || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct || ' ')
275: || p_last_name
276: into l_full_name
277: from dual;
278: else
279: select decode (p_first_name,'','',p_first_name|| ' ')
280: || decode (l_per_information5,'','',l_per_information5 || ' ')
281: || decode (l_per_information6,'','',l_per_information6 || ' ')

Line 285: from dual;

281: || decode (l_per_information6,'','',l_per_information6 || ' ')
282: || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct || ' ')
283: || p_last_name
284: into l_full_name
285: from dual;
286: end if;
287: elsif p_per_information4 = 'FORMAT11' then
288: select p_last_name || ' '
289: || decode (l_title,'','',l_title|| ' ')

Line 292: from dual;

288: select p_last_name || ' '
289: || decode (l_title,'','',l_title|| ' ')
290: || p_per_information1
291: into l_full_name
292: from dual;
293: elsif p_per_information4 = 'FORMAT12' then
294: select p_last_name || ' '
295: || decode (l_title,'','',l_title|| ' ')
296: || decode (p_per_information1,'','',p_per_information1 || ' ')

Line 299: from dual;

295: || decode (l_title,'','',l_title|| ' ')
296: || decode (p_per_information1,'','',p_per_information1 || ' ')
297: || p_first_name
298: into l_full_name
299: from dual;
300: elsif p_per_information4 = 'FORMAT13' then
301: select p_last_name || ' '
302: || decode (l_title,'','',l_title|| ' ')
303: || decode (p_per_information1,'','',p_per_information1 || ' ')

Line 306: from dual;

302: || decode (l_title,'','',l_title|| ' ')
303: || decode (p_per_information1,'','',p_per_information1 || ' ')
304: || p_known_as
305: into l_full_name
306: from dual;
307: elsif p_per_information4 = 'FORMAT14' then
308: select p_last_name || ' '
309: || decode (p_per_information1,'','',p_per_information1 || ' ')
310: || p_pre_name_adjunct

Line 312: from dual;

308: select p_last_name || ' '
309: || decode (p_per_information1,'','',p_per_information1 || ' ')
310: || p_pre_name_adjunct
311: into l_full_name
312: from dual;
313: elsif p_per_information4 = 'FORMAT15' then
314: select decode (l_acad_title,'','',l_acad_title|| ' ')
315: || decode (p_per_information1,'','',p_per_information1 || ' ')
316: || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct || ' ')

Line 320: from dual;

316: || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct || ' ')
317: || p_last_name || ' '
318: || decode (l_sub_acad_title,'','',l_sub_acad_title|| ' ')
319: into l_full_name
320: from dual;
321: elsif p_per_information4 = 'FORMAT16' then
322: if (p_pre_name_adjunct is not null or p_last_name is not null or l_sub_acad_title is not null) then
323: select decode (l_acad_title,'','',l_acad_title|| ' ')
324: || decode (p_per_information1,'','',p_per_information1 || ' ')

Line 332: from dual;

328: || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct || ' ')
329: || p_last_name || ' '
330: || decode (l_sub_acad_title,'','',l_sub_acad_title|| ' ')
331: into l_full_name
332: from dual;
333: else
334: select decode (l_acad_title,'','',l_acad_title|| ' ')
335: || decode (p_per_information1,'','',p_per_information1 || ' ')
336: || decode (l_per_information5,'','',l_per_information5 || ' ')

Line 342: from dual;

338: || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct || ' ')
339: || p_last_name || ' '
340: || decode (l_sub_acad_title,'','',l_sub_acad_title|| ' ')
341: into l_full_name
342: from dual;
343: end if;
344: elsif p_per_information4 = 'FORMAT17' then
345: if ((p_pre_name_adjunct is not null or p_last_name is not null) and (p_per_information1 is not null or l_per_information5 is not null)) then
346: select decode (l_per_information6,'','',l_per_information6)

Line 353: from dual;

349: || p_last_name || ', '
350: || decode (p_per_information1,'','',p_per_information1 || ' ')
351: || decode (l_per_information5,'','',l_per_information5 || ' ')
352: into l_full_name
353: from dual;
354: elsif ((p_pre_name_adjunct is not null or p_last_name is not null) and (p_per_information1 is null and l_per_information5 is null)) then
355: select decode (l_per_information6,'','',l_per_information6)
356: || '-'
357: || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct || ' ')

Line 362: from dual;

358: || p_last_name || ''
359: || decode (p_per_information1,'','',p_per_information1 || ' ')
360: || decode (l_per_information5,'','',l_per_information5 || ' ')
361: into l_full_name
362: from dual;
363: elsif ((p_pre_name_adjunct is null and p_last_name is null) and (p_per_information1 is not null or l_per_information5 is not null)) then
364: select decode (l_per_information6,'','',l_per_information6)
365: || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct)
366: || decode (p_last_name, '','',p_last_name)

Line 371: from dual;

367: || ', '
368: || decode (p_per_information1,'','', ', ' || p_per_information1 || ' ')
369: || decode (l_per_information5,'','',l_per_information5 || ' ')
370: into l_full_name
371: from dual;
372: elsif (p_pre_name_adjunct is null and p_last_name is null and p_per_information1 is null and l_per_information5 is null) then
373: select decode (l_per_information6,'','',l_per_information6)
374: || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct || ' ')
375: || decode (p_last_name, '','',p_last_name || ', ')

Line 379: from dual;

375: || decode (p_last_name, '','',p_last_name || ', ')
376: || decode (p_per_information1,'','',p_per_information1 || ' ')
377: || decode (l_per_information5,'','',l_per_information5 || ' ')
378: into l_full_name
379: from dual;
380: end if;
381: elsif p_per_information4 = 'FORMAT18' then
382: if ((l_per_information5 is not null or l_per_information6 is not null) and (p_per_information1 is not null or p_pre_name_adjunct is not null)) then
383: select p_last_name || '-'

Line 390: from dual;

386: || ', '
387: || decode (p_per_information1,'','',p_per_information1 || ' ')
388: || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct || ' ')
389: into l_full_name
390: from dual;
391: elsif((l_per_information5 is not null or l_per_information6 is not null) and (p_per_information1 is null and p_pre_name_adjunct is null)) then
392: select p_last_name || '-'
393: || decode (l_per_information5,'','',l_per_information5 || ' ')
394: || decode (l_per_information6,'','',l_per_information6 || ' ')

Line 398: from dual;

394: || decode (l_per_information6,'','',l_per_information6 || ' ')
395: || decode (p_per_information1,'','',p_per_information1 || ' ')
396: || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct || ' ')
397: into l_full_name
398: from dual;
399: elsif((l_per_information5 is null and l_per_information6 is null) and (p_per_information1 is not null or p_pre_name_adjunct is not null)) then
400: select p_last_name || ''
401: || decode (l_per_information5,'','',l_per_information5 || ' ')
402: || decode (l_per_information6,'','',l_per_information6)

Line 407: from dual;

403: || ', '
404: || decode (p_per_information1,'','',p_per_information1 || ' ')
405: || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct || ' ')
406: into l_full_name
407: from dual;
408: elsif(l_per_information5 is null and l_per_information6 is null and p_per_information1 is null and p_pre_name_adjunct is null) then
409: select p_last_name || ''
410: || decode (l_per_information5,'','',l_per_information5 || ' ')
411: || decode (l_per_information6,'','',l_per_information6 || ', ')

Line 415: from dual;

411: || decode (l_per_information6,'','',l_per_information6 || ', ')
412: || decode (p_per_information1,'','',p_per_information1 || ' ')
413: || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct || ' ')
414: into l_full_name
415: from dual;
416: end if;
417: elsif p_per_information4 = 'FORMAT19' then
418: if (p_per_information1 is not null or l_per_information5 is not null) then
419: select decode (l_per_information6,'','',l_per_information6)

Line 424: from dual;

420: || ', '
421: || decode (p_per_information1,'','',p_per_information1 || ' ')
422: || decode (l_per_information5,'','',l_per_information5 || ' ')
423: into l_full_name
424: from dual;
425: else
426: select decode (l_per_information6,'','',l_per_information6|| ' ')
427: || decode (p_per_information1,'','',p_per_information1 || ' ')
428: || decode (l_per_information5,'','',l_per_information5 || ' ')

Line 430: from dual;

426: select decode (l_per_information6,'','',l_per_information6|| ' ')
427: || decode (p_per_information1,'','',p_per_information1 || ' ')
428: || decode (l_per_information5,'','',l_per_information5 || ' ')
429: into l_full_name
430: from dual;
431: end if;
432: elsif p_per_information4 = 'FORMAT20' then
433: select decode (l_acad_title,'','',l_acad_title|| ' ')
434: || decode (l_title,'','',l_title|| ' ')

Line 440: from dual;

436: || decode (l_per_information5,'','',l_per_information5 || ' ')
437: || decode (l_per_information6,'','',l_per_information6 || ' ')
438: || decode (l_sub_acad_title,'','',l_sub_acad_title || ' ')
439: into l_full_name
440: from dual;
441: elsif p_per_information4 = 'FORMAT21' then
442: select decode (l_acad_title,'','',l_acad_title|| ' ')
443: || decode (l_title,'','',l_title|| ' ')
444: || decode (p_per_information1,'','',p_per_information1 || ' ')

Line 449: from dual;

445: || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct || ' ')
446: || p_last_name || ' '
447: || decode (l_sub_acad_title,'','',l_sub_acad_title || ' ')
448: into l_full_name
449: from dual;
450: elsif p_per_information4 = 'FORMAT22' then
451: if (p_pre_name_adjunct is not null or p_last_name is not null or l_sub_acad_title is not null) then
452: select decode (l_acad_title,'','',l_acad_title|| ' ')
453: || decode (l_title,'','',l_title|| ' ')

Line 462: from dual;

458: || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct || ' ')
459: || p_last_name || ' '
460: || decode (l_sub_acad_title,'','',l_sub_acad_title || ' ')
461: into l_full_name
462: from dual;
463: else
464: select decode (l_acad_title,'','',l_acad_title|| ' ')
465: || decode (l_title,'','',l_title|| ' ')
466: || decode (p_per_information1,'','',p_per_information1 || ' ')

Line 473: from dual;

469: || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct || ' ')
470: || p_last_name || ' '
471: || decode (l_sub_acad_title,'','',l_sub_acad_title || ' ')
472: into l_full_name
473: from dual;
474: end if;
475: elsif p_per_information4 = 'FORMAT23' then
476: select decode (l_acad_title,'','',l_acad_title|| ' ')
477: || decode (l_title,'','',l_title|| ' ')

Line 483: from dual;

479: || decode (l_per_information5,'','',l_per_information5 || ' ')
480: || decode (l_per_information6,'','',l_per_information6 || ' ')
481: || decode (l_sub_acad_title,'','',l_sub_acad_title || ' ')
482: into l_full_name
483: from dual;
484: elsif p_per_information4 = 'FORMAT24' then
485: select decode (l_acad_title,'','',l_acad_title|| ' ')
486: || decode (l_title,'','',l_title|| ' ')
487: || decode (p_first_name,'','',p_first_name|| ' ')

Line 492: from dual;

488: || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct || ' ')
489: || p_last_name || ' '
490: || decode (l_sub_acad_title,'','',l_sub_acad_title || ' ')
491: into l_full_name
492: from dual;
493: elsif p_per_information4 = 'FORMAT25' then
494: if (p_pre_name_adjunct is not null or p_last_name is not null or l_sub_acad_title is not null) then
495: select decode (l_acad_title,'','',l_acad_title|| ' ')
496: || decode (l_title,'','',l_title|| ' ')

Line 505: from dual;

501: || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct || ' ')
502: || p_last_name || ' '
503: || decode (l_sub_acad_title,'','',l_sub_acad_title || ' ')
504: into l_full_name
505: from dual;
506: else
507: select decode (l_acad_title,'','',l_acad_title|| ' ')
508: || decode (l_title,'','',l_title|| ' ')
509: || decode (p_first_name,'','',p_first_name|| ' ')

Line 516: from dual;

512: || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct || ' ')
513: || p_last_name || ' '
514: || decode (l_sub_acad_title,'','',l_sub_acad_title || ' ')
515: into l_full_name
516: from dual;
517: end if;
518: elsif p_per_information4 = 'FORMAT26' then
519: select p_last_name ||','|| ' ' /* 9346754QA */
520: || decode (p_per_information1,'','',p_per_information1 || ' ')

Line 523: from dual;

519: select p_last_name ||','|| ' ' /* 9346754QA */
520: || decode (p_per_information1,'','',p_per_information1 || ' ')
521: || p_pre_name_adjunct
522: into l_full_name
523: from dual;
524: else
525: select p_last_name || ' '
526: || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct || ' ')
527: || decode (p_per_information1,'','',p_per_information1 || ' ')

Line 531: from dual;

527: || decode (p_per_information1,'','',p_per_information1 || ' ')
528: || decode (l_per_information5,'','',l_per_information5 || ' ')
529: || l_per_information6
530: into l_full_name
531: from dual;
532: end if;
533: return rtrim(l_full_name);
534: END;
535: --