428: -- l_numrows integer := NULL;
429: --
430: cursor c_pos_seg1 (pos_id number) is
431: select pdf.segment1
432: from hr_all_positions_f pos, per_position_definitions pdf
433: where pos.position_definition_id = pdf.position_definition_id
434: and pos.position_id = pos_id
435: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
436: --
435: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
436: --
437: cursor c_pos_seg2 (pos_id number) is
438: select pdf.segment2
439: from hr_all_positions_f pos, per_position_definitions pdf
440: where pos.position_definition_id = pdf.position_definition_id
441: and pos.position_id = pos_id
442: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
443: --
442: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
443: --
444: cursor c_pos_seg3 (pos_id number) is
445: select pdf.segment3
446: from hr_all_positions_f pos, per_position_definitions pdf
447: where pos.position_definition_id = pdf.position_definition_id
448: and pos.position_id = pos_id
449: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
450: --
449: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
450: --
451: cursor c_pos_seg4 (pos_id number) is
452: select pdf.segment4
453: from hr_all_positions_f pos, per_position_definitions pdf
454: where pos.position_definition_id = pdf.position_definition_id
455: and pos.position_id = pos_id
456: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
457: --
456: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
457: --
458: cursor c_pos_seg5 (pos_id number) is
459: select pdf.segment5
460: from hr_all_positions_f pos, per_position_definitions pdf
461: where pos.position_definition_id = pdf.position_definition_id
462: and pos.position_id = pos_id
463: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
464: --
463: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
464: --
465: cursor c_pos_seg6 (pos_id number) is
466: select pdf.segment6
467: from hr_all_positions_f pos, per_position_definitions pdf
468: where pos.position_definition_id = pdf.position_definition_id
469: and pos.position_id = pos_id
470: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
471: --
470: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
471: --
472: cursor c_pos_seg7 (pos_id number) is
473: select pdf.segment7
474: from hr_all_positions_f pos, per_position_definitions pdf
475: where pos.position_definition_id = pdf.position_definition_id
476: and pos.position_id = pos_id
477: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
478: --
477: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
478: --
479: cursor c_pos_seg8 (pos_id number) is
480: select pdf.segment8
481: from hr_all_positions_f pos, per_position_definitions pdf
482: where pos.position_definition_id = pdf.position_definition_id
483: and pos.position_id = pos_id
484: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
485: --
484: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
485: --
486: cursor c_pos_seg9 (pos_id number) is
487: select pdf.segment9
488: from hr_all_positions_f pos, per_position_definitions pdf
489: where pos.position_definition_id = pdf.position_definition_id
490: and pos.position_id = pos_id
491: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
492: --
491: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
492: --
493: cursor c_pos_seg10 (pos_id number) is
494: select pdf.segment10
495: from hr_all_positions_f pos, per_position_definitions pdf
496: where pos.position_definition_id = pdf.position_definition_id
497: and pos.position_id = pos_id
498: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
499: --
498: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
499: --
500: cursor c_pos_seg11 (pos_id number) is
501: select pdf.segment11
502: from hr_all_positions_f pos, per_position_definitions pdf
503: where pos.position_definition_id = pdf.position_definition_id
504: and pos.position_id = pos_id
505: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
506: --
505: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
506: --
507: cursor c_pos_seg12 (pos_id number) is
508: select pdf.segment12
509: from hr_all_positions_f pos, per_position_definitions pdf
510: where pos.position_definition_id = pdf.position_definition_id
511: and pos.position_id = pos_id
512: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
513: --
512: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
513: --
514: cursor c_pos_seg13 (pos_id number) is
515: select pdf.segment13
516: from hr_all_positions_f pos, per_position_definitions pdf
517: where pos.position_definition_id = pdf.position_definition_id
518: and pos.position_id = pos_id
519: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
520: --
519: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
520: --
521: cursor c_pos_seg14 (pos_id number) is
522: select pdf.segment14
523: from hr_all_positions_f pos, per_position_definitions pdf
524: where pos.position_definition_id = pdf.position_definition_id
525: and pos.position_id = pos_id
526: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
527: --
526: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
527: --
528: cursor c_pos_seg15 (pos_id number) is
529: select pdf.segment15
530: from hr_all_positions_f pos, per_position_definitions pdf
531: where pos.position_definition_id = pdf.position_definition_id
532: and pos.position_id = pos_id
533: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
534: --
533: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
534: --
535: cursor c_pos_seg16 (pos_id number) is
536: select pdf.segment16
537: from hr_all_positions_f pos, per_position_definitions pdf
538: where pos.position_definition_id = pdf.position_definition_id
539: and pos.position_id = pos_id
540: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
541: --
540: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
541: --
542: cursor c_pos_seg17 (pos_id number) is
543: select pdf.segment17
544: from hr_all_positions_f pos, per_position_definitions pdf
545: where pos.position_definition_id = pdf.position_definition_id
546: and pos.position_id = pos_id
547: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
548: --
547: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
548: --
549: cursor c_pos_seg18 (pos_id number) is
550: select pdf.segment18
551: from hr_all_positions_f pos, per_position_definitions pdf
552: where pos.position_definition_id = pdf.position_definition_id
553: and pos.position_id = pos_id
554: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
555: --
554: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
555: --
556: cursor c_pos_seg19 (pos_id number) is
557: select pdf.segment19
558: from hr_all_positions_f pos, per_position_definitions pdf
559: where pos.position_definition_id = pdf.position_definition_id
560: and pos.position_id = pos_id
561: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
562: --
561: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
562: --
563: cursor c_pos_seg20 (pos_id number) is
564: select pdf.segment20
565: from hr_all_positions_f pos, per_position_definitions pdf
566: where pos.position_definition_id = pdf.position_definition_id
567: and pos.position_id = pos_id
568: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
569: --
568: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
569: --
570: cursor c_pos_seg21 (pos_id number) is
571: select pdf.segment21
572: from hr_all_positions_f pos, per_position_definitions pdf
573: where pos.position_definition_id = pdf.position_definition_id
574: and pos.position_id = pos_id
575: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
576: --
575: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
576: --
577: cursor c_pos_seg22 (pos_id number) is
578: select pdf.segment22
579: from hr_all_positions_f pos, per_position_definitions pdf
580: where pos.position_definition_id = pdf.position_definition_id
581: and pos.position_id = pos_id
582: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
583: --
582: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
583: --
584: cursor c_pos_seg23 (pos_id number) is
585: select pdf.segment23
586: from hr_all_positions_f pos, per_position_definitions pdf
587: where pos.position_definition_id = pdf.position_definition_id
588: and pos.position_id = pos_id
589: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
590: --
589: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
590: --
591: cursor c_pos_seg24 (pos_id number) is
592: select pdf.segment24
593: from hr_all_positions_f pos, per_position_definitions pdf
594: where pos.position_definition_id = pdf.position_definition_id
595: and pos.position_id = pos_id
596: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
597: --
596: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
597: --
598: cursor c_pos_seg25 (pos_id number) is
599: select pdf.segment25
600: from hr_all_positions_f pos, per_position_definitions pdf
601: where pos.position_definition_id = pdf.position_definition_id
602: and pos.position_id = pos_id
603: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
604: --
603: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
604: --
605: cursor c_pos_seg26 (pos_id number) is
606: select pdf.segment26
607: from hr_all_positions_f pos, per_position_definitions pdf
608: where pos.position_definition_id = pdf.position_definition_id
609: and pos.position_id = pos_id
610: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
611: --
610: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
611: --
612: cursor c_pos_seg27 (pos_id number) is
613: select pdf.segment27
614: from hr_all_positions_f pos, per_position_definitions pdf
615: where pos.position_definition_id = pdf.position_definition_id
616: and pos.position_id = pos_id
617: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
618: --
617: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
618: --
619: cursor c_pos_seg28 (pos_id number) is
620: select pdf.segment28
621: from hr_all_positions_f pos, per_position_definitions pdf
622: where pos.position_definition_id = pdf.position_definition_id
623: and pos.position_id = pos_id
624: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
625: --
624: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
625: --
626: cursor c_pos_seg29 (pos_id number) is
627: select pdf.segment29
628: from hr_all_positions_f pos, per_position_definitions pdf
629: where pos.position_definition_id = pdf.position_definition_id
630: and pos.position_id = pos_id
631: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
632: --
631: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
632: --
633: cursor c_pos_seg30 (pos_id number) is
634: select pdf.segment30
635: from hr_all_positions_f pos, per_position_definitions pdf
636: where pos.position_definition_id = pdf.position_definition_id
637: and pos.position_id = pos_id
638: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
639: --