358: ,paf.supervisor_id supervisor_id
359: ,p_effective_date effective_date
360: ,ppf.full_name full_name
361: ,trim(ppf.first_name ||' '||ppf.last_name||' '||ppf.suffix) brief_name
362: ,nvl(ben_cwb_custom_person_pkg.get_custom_name(ppf.person_id
363: ,pil.assignment_id
364: ,bg.org_information9
365: ,pil.group_pl_id
366: ,pil.lf_evt_ocrd_dt
368: ppf.full_name) custom_name
369: ,supv.full_name supervisor_full_name
370: ,trim(supv.first_name||' '||supv.last_name||' '||supv.suffix)
371: supervisor_brief_name
372: ,nvl(ben_cwb_custom_person_pkg.get_custom_name(supv.person_id
373: ,supv_asg.assignment_id
374: ,supv_bg.org_information9
375: ,pil.group_pl_id
376: ,pil.lf_evt_ocrd_dt
429: ,paf.normal_hours normal_hours
430: ,ppf.email_address email_address
431: ,ppb.pay_basis base_salary_frequency
432: ,ppb.rate_basis grade_rate_frequency
433: ,ben_cwb_custom_person_pkg.get_custom_segment1(ppf.person_id
434: ,pil.assignment_id
435: ,bg.org_information9
436: ,pil.group_pl_id
437: ,pil.lf_evt_ocrd_dt
436: ,pil.group_pl_id
437: ,pil.lf_evt_ocrd_dt
438: ,p_effective_date)
439: custom_segment1
440: ,ben_cwb_custom_person_pkg.get_custom_segment2(ppf.person_id
441: ,pil.assignment_id
442: ,bg.org_information9
443: ,pil.group_pl_id
444: ,pil.lf_evt_ocrd_dt
443: ,pil.group_pl_id
444: ,pil.lf_evt_ocrd_dt
445: ,p_effective_date)
446: custom_segment2
447: ,ben_cwb_custom_person_pkg.get_custom_segment3(ppf.person_id
448: ,pil.assignment_id
449: ,bg.org_information9
450: ,pil.group_pl_id
451: ,pil.lf_evt_ocrd_dt
450: ,pil.group_pl_id
451: ,pil.lf_evt_ocrd_dt
452: ,p_effective_date)
453: custom_segment3
454: ,ben_cwb_custom_person_pkg.get_custom_segment4(ppf.person_id
455: ,pil.assignment_id
456: ,bg.org_information9
457: ,pil.group_pl_id
458: ,pil.lf_evt_ocrd_dt
457: ,pil.group_pl_id
458: ,pil.lf_evt_ocrd_dt
459: ,p_effective_date)
460: custom_segment4
461: ,ben_cwb_custom_person_pkg.get_custom_segment5(ppf.person_id
462: ,pil.assignment_id
463: ,bg.org_information9
464: ,pil.group_pl_id
465: ,pil.lf_evt_ocrd_dt
464: ,pil.group_pl_id
465: ,pil.lf_evt_ocrd_dt
466: ,p_effective_date)
467: custom_segment5
468: ,ben_cwb_custom_person_pkg.get_custom_segment6(ppf.person_id
469: ,pil.assignment_id
470: ,bg.org_information9
471: ,pil.group_pl_id
472: ,pil.lf_evt_ocrd_dt
471: ,pil.group_pl_id
472: ,pil.lf_evt_ocrd_dt
473: ,p_effective_date)
474: custom_segment6
475: ,ben_cwb_custom_person_pkg.get_custom_segment7(ppf.person_id
476: ,pil.assignment_id
477: ,bg.org_information9
478: ,pil.group_pl_id
479: ,pil.lf_evt_ocrd_dt
478: ,pil.group_pl_id
479: ,pil.lf_evt_ocrd_dt
480: ,p_effective_date)
481: custom_segment7
482: ,ben_cwb_custom_person_pkg.get_custom_segment8(ppf.person_id
483: ,pil.assignment_id
484: ,bg.org_information9
485: ,pil.group_pl_id
486: ,pil.lf_evt_ocrd_dt
485: ,pil.group_pl_id
486: ,pil.lf_evt_ocrd_dt
487: ,p_effective_date)
488: custom_segment8
489: ,ben_cwb_custom_person_pkg.get_custom_segment9(ppf.person_id
490: ,pil.assignment_id
491: ,bg.org_information9
492: ,pil.group_pl_id
493: ,pil.lf_evt_ocrd_dt
492: ,pil.group_pl_id
493: ,pil.lf_evt_ocrd_dt
494: ,p_effective_date)
495: custom_segment9
496: ,ben_cwb_custom_person_pkg.get_custom_segment10(ppf.person_id
497: ,pil.assignment_id
498: ,bg.org_information9
499: ,pil.group_pl_id
500: ,pil.lf_evt_ocrd_dt
499: ,pil.group_pl_id
500: ,pil.lf_evt_ocrd_dt
501: ,p_effective_date)
502: custom_segment10
503: ,ben_cwb_custom_person_pkg.get_custom_segment11(ppf.person_id
504: ,pil.assignment_id
505: ,bg.org_information9
506: ,pil.group_pl_id
507: ,pil.lf_evt_ocrd_dt
506: ,pil.group_pl_id
507: ,pil.lf_evt_ocrd_dt
508: ,p_effective_date)
509: custom_segment11
510: ,ben_cwb_custom_person_pkg.get_custom_segment12(ppf.person_id
511: ,pil.assignment_id
512: ,bg.org_information9
513: ,pil.group_pl_id
514: ,pil.lf_evt_ocrd_dt
513: ,pil.group_pl_id
514: ,pil.lf_evt_ocrd_dt
515: ,p_effective_date)
516: custom_segment12
517: ,ben_cwb_custom_person_pkg.get_custom_segment13(ppf.person_id
518: ,pil.assignment_id
519: ,bg.org_information9
520: ,pil.group_pl_id
521: ,pil.lf_evt_ocrd_dt
520: ,pil.group_pl_id
521: ,pil.lf_evt_ocrd_dt
522: ,p_effective_date)
523: custom_segment13
524: ,ben_cwb_custom_person_pkg.get_custom_segment14(ppf.person_id
525: ,pil.assignment_id
526: ,bg.org_information9
527: ,pil.group_pl_id
528: ,pil.lf_evt_ocrd_dt
527: ,pil.group_pl_id
528: ,pil.lf_evt_ocrd_dt
529: ,p_effective_date)
530: custom_segment14
531: ,ben_cwb_custom_person_pkg.get_custom_segment15(ppf.person_id
532: ,pil.assignment_id
533: ,bg.org_information9
534: ,pil.group_pl_id
535: ,pil.lf_evt_ocrd_dt
534: ,pil.group_pl_id
535: ,pil.lf_evt_ocrd_dt
536: ,p_effective_date)
537: custom_segment15
538: ,ben_cwb_custom_person_pkg.get_custom_segment16(ppf.person_id
539: ,pil.assignment_id
540: ,bg.org_information9
541: ,pil.group_pl_id
542: ,pil.lf_evt_ocrd_dt
541: ,pil.group_pl_id
542: ,pil.lf_evt_ocrd_dt
543: ,p_effective_date)
544: custom_segment16
545: ,ben_cwb_custom_person_pkg.get_custom_segment17(ppf.person_id
546: ,pil.assignment_id
547: ,bg.org_information9
548: ,pil.group_pl_id
549: ,pil.lf_evt_ocrd_dt
548: ,pil.group_pl_id
549: ,pil.lf_evt_ocrd_dt
550: ,p_effective_date)
551: custom_segment17
552: ,ben_cwb_custom_person_pkg.get_custom_segment18(ppf.person_id
553: ,pil.assignment_id
554: ,bg.org_information9
555: ,pil.group_pl_id
556: ,pil.lf_evt_ocrd_dt
555: ,pil.group_pl_id
556: ,pil.lf_evt_ocrd_dt
557: ,p_effective_date)
558: custom_segment18
559: ,ben_cwb_custom_person_pkg.get_custom_segment19(ppf.person_id
560: ,pil.assignment_id
561: ,bg.org_information9
562: ,pil.group_pl_id
563: ,pil.lf_evt_ocrd_dt
562: ,pil.group_pl_id
563: ,pil.lf_evt_ocrd_dt
564: ,p_effective_date)
565: custom_segment19
566: ,ben_cwb_custom_person_pkg.get_custom_segment20(ppf.person_id
567: ,pil.assignment_id
568: ,bg.org_information9
569: ,pil.group_pl_id
570: ,pil.lf_evt_ocrd_dt