APPS.PER_IN_PREV_EMPLOYER_LEG_HOOK dependencies on PER_PREVIOUS_EMPLOYERS

Line 567: FROM per_previous_employers

563: ,pem_information27
564: ,pem_information28
565: ,pem_information29
566: ,pem_information30
567: FROM per_previous_employers
568: WHERE previous_employer_id = p_previous_employer_id;
569:
570: l_person_id per_previous_employers.person_id%TYPE;
571: l_business_group_id per_previous_employers.business_group_id%TYPE;

Line 570: l_person_id per_previous_employers.person_id%TYPE;

566: ,pem_information30
567: FROM per_previous_employers
568: WHERE previous_employer_id = p_previous_employer_id;
569:
570: l_person_id per_previous_employers.person_id%TYPE;
571: l_business_group_id per_previous_employers.business_group_id%TYPE;
572: l_start_date per_previous_employers.start_date%TYPE;
573: l_end_date per_previous_employers.end_date%TYPE;
574: l_pem_information_category per_previous_employers.pem_information_category%TYPE;

Line 571: l_business_group_id per_previous_employers.business_group_id%TYPE;

567: FROM per_previous_employers
568: WHERE previous_employer_id = p_previous_employer_id;
569:
570: l_person_id per_previous_employers.person_id%TYPE;
571: l_business_group_id per_previous_employers.business_group_id%TYPE;
572: l_start_date per_previous_employers.start_date%TYPE;
573: l_end_date per_previous_employers.end_date%TYPE;
574: l_pem_information_category per_previous_employers.pem_information_category%TYPE;
575: l_pem_information1 per_previous_employers.pem_information1%TYPE;

Line 572: l_start_date per_previous_employers.start_date%TYPE;

568: WHERE previous_employer_id = p_previous_employer_id;
569:
570: l_person_id per_previous_employers.person_id%TYPE;
571: l_business_group_id per_previous_employers.business_group_id%TYPE;
572: l_start_date per_previous_employers.start_date%TYPE;
573: l_end_date per_previous_employers.end_date%TYPE;
574: l_pem_information_category per_previous_employers.pem_information_category%TYPE;
575: l_pem_information1 per_previous_employers.pem_information1%TYPE;
576: l_pem_information2 per_previous_employers.pem_information2%TYPE;

Line 573: l_end_date per_previous_employers.end_date%TYPE;

569:
570: l_person_id per_previous_employers.person_id%TYPE;
571: l_business_group_id per_previous_employers.business_group_id%TYPE;
572: l_start_date per_previous_employers.start_date%TYPE;
573: l_end_date per_previous_employers.end_date%TYPE;
574: l_pem_information_category per_previous_employers.pem_information_category%TYPE;
575: l_pem_information1 per_previous_employers.pem_information1%TYPE;
576: l_pem_information2 per_previous_employers.pem_information2%TYPE;
577: l_pem_information3 per_previous_employers.pem_information3%TYPE;

Line 574: l_pem_information_category per_previous_employers.pem_information_category%TYPE;

570: l_person_id per_previous_employers.person_id%TYPE;
571: l_business_group_id per_previous_employers.business_group_id%TYPE;
572: l_start_date per_previous_employers.start_date%TYPE;
573: l_end_date per_previous_employers.end_date%TYPE;
574: l_pem_information_category per_previous_employers.pem_information_category%TYPE;
575: l_pem_information1 per_previous_employers.pem_information1%TYPE;
576: l_pem_information2 per_previous_employers.pem_information2%TYPE;
577: l_pem_information3 per_previous_employers.pem_information3%TYPE;
578: l_pem_information4 per_previous_employers.pem_information4%TYPE;

Line 575: l_pem_information1 per_previous_employers.pem_information1%TYPE;

571: l_business_group_id per_previous_employers.business_group_id%TYPE;
572: l_start_date per_previous_employers.start_date%TYPE;
573: l_end_date per_previous_employers.end_date%TYPE;
574: l_pem_information_category per_previous_employers.pem_information_category%TYPE;
575: l_pem_information1 per_previous_employers.pem_information1%TYPE;
576: l_pem_information2 per_previous_employers.pem_information2%TYPE;
577: l_pem_information3 per_previous_employers.pem_information3%TYPE;
578: l_pem_information4 per_previous_employers.pem_information4%TYPE;
579: l_pem_information5 per_previous_employers.pem_information5%TYPE;

Line 576: l_pem_information2 per_previous_employers.pem_information2%TYPE;

572: l_start_date per_previous_employers.start_date%TYPE;
573: l_end_date per_previous_employers.end_date%TYPE;
574: l_pem_information_category per_previous_employers.pem_information_category%TYPE;
575: l_pem_information1 per_previous_employers.pem_information1%TYPE;
576: l_pem_information2 per_previous_employers.pem_information2%TYPE;
577: l_pem_information3 per_previous_employers.pem_information3%TYPE;
578: l_pem_information4 per_previous_employers.pem_information4%TYPE;
579: l_pem_information5 per_previous_employers.pem_information5%TYPE;
580: l_pem_information6 per_previous_employers.pem_information6%TYPE;

Line 577: l_pem_information3 per_previous_employers.pem_information3%TYPE;

573: l_end_date per_previous_employers.end_date%TYPE;
574: l_pem_information_category per_previous_employers.pem_information_category%TYPE;
575: l_pem_information1 per_previous_employers.pem_information1%TYPE;
576: l_pem_information2 per_previous_employers.pem_information2%TYPE;
577: l_pem_information3 per_previous_employers.pem_information3%TYPE;
578: l_pem_information4 per_previous_employers.pem_information4%TYPE;
579: l_pem_information5 per_previous_employers.pem_information5%TYPE;
580: l_pem_information6 per_previous_employers.pem_information6%TYPE;
581: l_pem_information7 per_previous_employers.pem_information7%TYPE;

Line 578: l_pem_information4 per_previous_employers.pem_information4%TYPE;

574: l_pem_information_category per_previous_employers.pem_information_category%TYPE;
575: l_pem_information1 per_previous_employers.pem_information1%TYPE;
576: l_pem_information2 per_previous_employers.pem_information2%TYPE;
577: l_pem_information3 per_previous_employers.pem_information3%TYPE;
578: l_pem_information4 per_previous_employers.pem_information4%TYPE;
579: l_pem_information5 per_previous_employers.pem_information5%TYPE;
580: l_pem_information6 per_previous_employers.pem_information6%TYPE;
581: l_pem_information7 per_previous_employers.pem_information7%TYPE;
582: l_pem_information8 per_previous_employers.pem_information8%TYPE;

Line 579: l_pem_information5 per_previous_employers.pem_information5%TYPE;

575: l_pem_information1 per_previous_employers.pem_information1%TYPE;
576: l_pem_information2 per_previous_employers.pem_information2%TYPE;
577: l_pem_information3 per_previous_employers.pem_information3%TYPE;
578: l_pem_information4 per_previous_employers.pem_information4%TYPE;
579: l_pem_information5 per_previous_employers.pem_information5%TYPE;
580: l_pem_information6 per_previous_employers.pem_information6%TYPE;
581: l_pem_information7 per_previous_employers.pem_information7%TYPE;
582: l_pem_information8 per_previous_employers.pem_information8%TYPE;
583: l_pem_information9 per_previous_employers.pem_information9%TYPE;

Line 580: l_pem_information6 per_previous_employers.pem_information6%TYPE;

576: l_pem_information2 per_previous_employers.pem_information2%TYPE;
577: l_pem_information3 per_previous_employers.pem_information3%TYPE;
578: l_pem_information4 per_previous_employers.pem_information4%TYPE;
579: l_pem_information5 per_previous_employers.pem_information5%TYPE;
580: l_pem_information6 per_previous_employers.pem_information6%TYPE;
581: l_pem_information7 per_previous_employers.pem_information7%TYPE;
582: l_pem_information8 per_previous_employers.pem_information8%TYPE;
583: l_pem_information9 per_previous_employers.pem_information9%TYPE;
584: l_pem_information10 per_previous_employers.pem_information10%TYPE;

Line 581: l_pem_information7 per_previous_employers.pem_information7%TYPE;

577: l_pem_information3 per_previous_employers.pem_information3%TYPE;
578: l_pem_information4 per_previous_employers.pem_information4%TYPE;
579: l_pem_information5 per_previous_employers.pem_information5%TYPE;
580: l_pem_information6 per_previous_employers.pem_information6%TYPE;
581: l_pem_information7 per_previous_employers.pem_information7%TYPE;
582: l_pem_information8 per_previous_employers.pem_information8%TYPE;
583: l_pem_information9 per_previous_employers.pem_information9%TYPE;
584: l_pem_information10 per_previous_employers.pem_information10%TYPE;
585: l_pem_information11 per_previous_employers.pem_information11%TYPE;

Line 582: l_pem_information8 per_previous_employers.pem_information8%TYPE;

578: l_pem_information4 per_previous_employers.pem_information4%TYPE;
579: l_pem_information5 per_previous_employers.pem_information5%TYPE;
580: l_pem_information6 per_previous_employers.pem_information6%TYPE;
581: l_pem_information7 per_previous_employers.pem_information7%TYPE;
582: l_pem_information8 per_previous_employers.pem_information8%TYPE;
583: l_pem_information9 per_previous_employers.pem_information9%TYPE;
584: l_pem_information10 per_previous_employers.pem_information10%TYPE;
585: l_pem_information11 per_previous_employers.pem_information11%TYPE;
586: l_pem_information12 per_previous_employers.pem_information12%TYPE;

Line 583: l_pem_information9 per_previous_employers.pem_information9%TYPE;

579: l_pem_information5 per_previous_employers.pem_information5%TYPE;
580: l_pem_information6 per_previous_employers.pem_information6%TYPE;
581: l_pem_information7 per_previous_employers.pem_information7%TYPE;
582: l_pem_information8 per_previous_employers.pem_information8%TYPE;
583: l_pem_information9 per_previous_employers.pem_information9%TYPE;
584: l_pem_information10 per_previous_employers.pem_information10%TYPE;
585: l_pem_information11 per_previous_employers.pem_information11%TYPE;
586: l_pem_information12 per_previous_employers.pem_information12%TYPE;
587: l_pem_information13 per_previous_employers.pem_information13%TYPE;

Line 584: l_pem_information10 per_previous_employers.pem_information10%TYPE;

580: l_pem_information6 per_previous_employers.pem_information6%TYPE;
581: l_pem_information7 per_previous_employers.pem_information7%TYPE;
582: l_pem_information8 per_previous_employers.pem_information8%TYPE;
583: l_pem_information9 per_previous_employers.pem_information9%TYPE;
584: l_pem_information10 per_previous_employers.pem_information10%TYPE;
585: l_pem_information11 per_previous_employers.pem_information11%TYPE;
586: l_pem_information12 per_previous_employers.pem_information12%TYPE;
587: l_pem_information13 per_previous_employers.pem_information13%TYPE;
588: l_pem_information14 per_previous_employers.pem_information14%TYPE;

Line 585: l_pem_information11 per_previous_employers.pem_information11%TYPE;

581: l_pem_information7 per_previous_employers.pem_information7%TYPE;
582: l_pem_information8 per_previous_employers.pem_information8%TYPE;
583: l_pem_information9 per_previous_employers.pem_information9%TYPE;
584: l_pem_information10 per_previous_employers.pem_information10%TYPE;
585: l_pem_information11 per_previous_employers.pem_information11%TYPE;
586: l_pem_information12 per_previous_employers.pem_information12%TYPE;
587: l_pem_information13 per_previous_employers.pem_information13%TYPE;
588: l_pem_information14 per_previous_employers.pem_information14%TYPE;
589: l_pem_information15 per_previous_employers.pem_information15%TYPE;

Line 586: l_pem_information12 per_previous_employers.pem_information12%TYPE;

582: l_pem_information8 per_previous_employers.pem_information8%TYPE;
583: l_pem_information9 per_previous_employers.pem_information9%TYPE;
584: l_pem_information10 per_previous_employers.pem_information10%TYPE;
585: l_pem_information11 per_previous_employers.pem_information11%TYPE;
586: l_pem_information12 per_previous_employers.pem_information12%TYPE;
587: l_pem_information13 per_previous_employers.pem_information13%TYPE;
588: l_pem_information14 per_previous_employers.pem_information14%TYPE;
589: l_pem_information15 per_previous_employers.pem_information15%TYPE;
590: l_pem_information16 per_previous_employers.pem_information16%TYPE;

Line 587: l_pem_information13 per_previous_employers.pem_information13%TYPE;

583: l_pem_information9 per_previous_employers.pem_information9%TYPE;
584: l_pem_information10 per_previous_employers.pem_information10%TYPE;
585: l_pem_information11 per_previous_employers.pem_information11%TYPE;
586: l_pem_information12 per_previous_employers.pem_information12%TYPE;
587: l_pem_information13 per_previous_employers.pem_information13%TYPE;
588: l_pem_information14 per_previous_employers.pem_information14%TYPE;
589: l_pem_information15 per_previous_employers.pem_information15%TYPE;
590: l_pem_information16 per_previous_employers.pem_information16%TYPE;
591: l_pem_information17 per_previous_employers.pem_information17%TYPE;

Line 588: l_pem_information14 per_previous_employers.pem_information14%TYPE;

584: l_pem_information10 per_previous_employers.pem_information10%TYPE;
585: l_pem_information11 per_previous_employers.pem_information11%TYPE;
586: l_pem_information12 per_previous_employers.pem_information12%TYPE;
587: l_pem_information13 per_previous_employers.pem_information13%TYPE;
588: l_pem_information14 per_previous_employers.pem_information14%TYPE;
589: l_pem_information15 per_previous_employers.pem_information15%TYPE;
590: l_pem_information16 per_previous_employers.pem_information16%TYPE;
591: l_pem_information17 per_previous_employers.pem_information17%TYPE;
592: l_pem_information18 per_previous_employers.pem_information18%TYPE;

Line 589: l_pem_information15 per_previous_employers.pem_information15%TYPE;

585: l_pem_information11 per_previous_employers.pem_information11%TYPE;
586: l_pem_information12 per_previous_employers.pem_information12%TYPE;
587: l_pem_information13 per_previous_employers.pem_information13%TYPE;
588: l_pem_information14 per_previous_employers.pem_information14%TYPE;
589: l_pem_information15 per_previous_employers.pem_information15%TYPE;
590: l_pem_information16 per_previous_employers.pem_information16%TYPE;
591: l_pem_information17 per_previous_employers.pem_information17%TYPE;
592: l_pem_information18 per_previous_employers.pem_information18%TYPE;
593: l_pem_information19 per_previous_employers.pem_information19%TYPE;

Line 590: l_pem_information16 per_previous_employers.pem_information16%TYPE;

586: l_pem_information12 per_previous_employers.pem_information12%TYPE;
587: l_pem_information13 per_previous_employers.pem_information13%TYPE;
588: l_pem_information14 per_previous_employers.pem_information14%TYPE;
589: l_pem_information15 per_previous_employers.pem_information15%TYPE;
590: l_pem_information16 per_previous_employers.pem_information16%TYPE;
591: l_pem_information17 per_previous_employers.pem_information17%TYPE;
592: l_pem_information18 per_previous_employers.pem_information18%TYPE;
593: l_pem_information19 per_previous_employers.pem_information19%TYPE;
594: l_pem_information20 per_previous_employers.pem_information20%TYPE;

Line 591: l_pem_information17 per_previous_employers.pem_information17%TYPE;

587: l_pem_information13 per_previous_employers.pem_information13%TYPE;
588: l_pem_information14 per_previous_employers.pem_information14%TYPE;
589: l_pem_information15 per_previous_employers.pem_information15%TYPE;
590: l_pem_information16 per_previous_employers.pem_information16%TYPE;
591: l_pem_information17 per_previous_employers.pem_information17%TYPE;
592: l_pem_information18 per_previous_employers.pem_information18%TYPE;
593: l_pem_information19 per_previous_employers.pem_information19%TYPE;
594: l_pem_information20 per_previous_employers.pem_information20%TYPE;
595: l_pem_information21 per_previous_employers.pem_information21%TYPE;

Line 592: l_pem_information18 per_previous_employers.pem_information18%TYPE;

588: l_pem_information14 per_previous_employers.pem_information14%TYPE;
589: l_pem_information15 per_previous_employers.pem_information15%TYPE;
590: l_pem_information16 per_previous_employers.pem_information16%TYPE;
591: l_pem_information17 per_previous_employers.pem_information17%TYPE;
592: l_pem_information18 per_previous_employers.pem_information18%TYPE;
593: l_pem_information19 per_previous_employers.pem_information19%TYPE;
594: l_pem_information20 per_previous_employers.pem_information20%TYPE;
595: l_pem_information21 per_previous_employers.pem_information21%TYPE;
596: l_pem_information22 per_previous_employers.pem_information22%TYPE;

Line 593: l_pem_information19 per_previous_employers.pem_information19%TYPE;

589: l_pem_information15 per_previous_employers.pem_information15%TYPE;
590: l_pem_information16 per_previous_employers.pem_information16%TYPE;
591: l_pem_information17 per_previous_employers.pem_information17%TYPE;
592: l_pem_information18 per_previous_employers.pem_information18%TYPE;
593: l_pem_information19 per_previous_employers.pem_information19%TYPE;
594: l_pem_information20 per_previous_employers.pem_information20%TYPE;
595: l_pem_information21 per_previous_employers.pem_information21%TYPE;
596: l_pem_information22 per_previous_employers.pem_information22%TYPE;
597: l_pem_information23 per_previous_employers.pem_information23%TYPE;

Line 594: l_pem_information20 per_previous_employers.pem_information20%TYPE;

590: l_pem_information16 per_previous_employers.pem_information16%TYPE;
591: l_pem_information17 per_previous_employers.pem_information17%TYPE;
592: l_pem_information18 per_previous_employers.pem_information18%TYPE;
593: l_pem_information19 per_previous_employers.pem_information19%TYPE;
594: l_pem_information20 per_previous_employers.pem_information20%TYPE;
595: l_pem_information21 per_previous_employers.pem_information21%TYPE;
596: l_pem_information22 per_previous_employers.pem_information22%TYPE;
597: l_pem_information23 per_previous_employers.pem_information23%TYPE;
598: l_pem_information24 per_previous_employers.pem_information24%TYPE;

Line 595: l_pem_information21 per_previous_employers.pem_information21%TYPE;

591: l_pem_information17 per_previous_employers.pem_information17%TYPE;
592: l_pem_information18 per_previous_employers.pem_information18%TYPE;
593: l_pem_information19 per_previous_employers.pem_information19%TYPE;
594: l_pem_information20 per_previous_employers.pem_information20%TYPE;
595: l_pem_information21 per_previous_employers.pem_information21%TYPE;
596: l_pem_information22 per_previous_employers.pem_information22%TYPE;
597: l_pem_information23 per_previous_employers.pem_information23%TYPE;
598: l_pem_information24 per_previous_employers.pem_information24%TYPE;
599: l_pem_information25 per_previous_employers.pem_information25%TYPE;

Line 596: l_pem_information22 per_previous_employers.pem_information22%TYPE;

592: l_pem_information18 per_previous_employers.pem_information18%TYPE;
593: l_pem_information19 per_previous_employers.pem_information19%TYPE;
594: l_pem_information20 per_previous_employers.pem_information20%TYPE;
595: l_pem_information21 per_previous_employers.pem_information21%TYPE;
596: l_pem_information22 per_previous_employers.pem_information22%TYPE;
597: l_pem_information23 per_previous_employers.pem_information23%TYPE;
598: l_pem_information24 per_previous_employers.pem_information24%TYPE;
599: l_pem_information25 per_previous_employers.pem_information25%TYPE;
600: l_pem_information26 per_previous_employers.pem_information26%TYPE;

Line 597: l_pem_information23 per_previous_employers.pem_information23%TYPE;

593: l_pem_information19 per_previous_employers.pem_information19%TYPE;
594: l_pem_information20 per_previous_employers.pem_information20%TYPE;
595: l_pem_information21 per_previous_employers.pem_information21%TYPE;
596: l_pem_information22 per_previous_employers.pem_information22%TYPE;
597: l_pem_information23 per_previous_employers.pem_information23%TYPE;
598: l_pem_information24 per_previous_employers.pem_information24%TYPE;
599: l_pem_information25 per_previous_employers.pem_information25%TYPE;
600: l_pem_information26 per_previous_employers.pem_information26%TYPE;
601: l_pem_information27 per_previous_employers.pem_information27%TYPE;

Line 598: l_pem_information24 per_previous_employers.pem_information24%TYPE;

594: l_pem_information20 per_previous_employers.pem_information20%TYPE;
595: l_pem_information21 per_previous_employers.pem_information21%TYPE;
596: l_pem_information22 per_previous_employers.pem_information22%TYPE;
597: l_pem_information23 per_previous_employers.pem_information23%TYPE;
598: l_pem_information24 per_previous_employers.pem_information24%TYPE;
599: l_pem_information25 per_previous_employers.pem_information25%TYPE;
600: l_pem_information26 per_previous_employers.pem_information26%TYPE;
601: l_pem_information27 per_previous_employers.pem_information27%TYPE;
602: l_pem_information28 per_previous_employers.pem_information28%TYPE;

Line 599: l_pem_information25 per_previous_employers.pem_information25%TYPE;

595: l_pem_information21 per_previous_employers.pem_information21%TYPE;
596: l_pem_information22 per_previous_employers.pem_information22%TYPE;
597: l_pem_information23 per_previous_employers.pem_information23%TYPE;
598: l_pem_information24 per_previous_employers.pem_information24%TYPE;
599: l_pem_information25 per_previous_employers.pem_information25%TYPE;
600: l_pem_information26 per_previous_employers.pem_information26%TYPE;
601: l_pem_information27 per_previous_employers.pem_information27%TYPE;
602: l_pem_information28 per_previous_employers.pem_information28%TYPE;
603: l_pem_information29 per_previous_employers.pem_information29%TYPE;

Line 600: l_pem_information26 per_previous_employers.pem_information26%TYPE;

596: l_pem_information22 per_previous_employers.pem_information22%TYPE;
597: l_pem_information23 per_previous_employers.pem_information23%TYPE;
598: l_pem_information24 per_previous_employers.pem_information24%TYPE;
599: l_pem_information25 per_previous_employers.pem_information25%TYPE;
600: l_pem_information26 per_previous_employers.pem_information26%TYPE;
601: l_pem_information27 per_previous_employers.pem_information27%TYPE;
602: l_pem_information28 per_previous_employers.pem_information28%TYPE;
603: l_pem_information29 per_previous_employers.pem_information29%TYPE;
604: l_pem_information30 per_previous_employers.pem_information30%TYPE;

Line 601: l_pem_information27 per_previous_employers.pem_information27%TYPE;

597: l_pem_information23 per_previous_employers.pem_information23%TYPE;
598: l_pem_information24 per_previous_employers.pem_information24%TYPE;
599: l_pem_information25 per_previous_employers.pem_information25%TYPE;
600: l_pem_information26 per_previous_employers.pem_information26%TYPE;
601: l_pem_information27 per_previous_employers.pem_information27%TYPE;
602: l_pem_information28 per_previous_employers.pem_information28%TYPE;
603: l_pem_information29 per_previous_employers.pem_information29%TYPE;
604: l_pem_information30 per_previous_employers.pem_information30%TYPE;
605:

Line 602: l_pem_information28 per_previous_employers.pem_information28%TYPE;

598: l_pem_information24 per_previous_employers.pem_information24%TYPE;
599: l_pem_information25 per_previous_employers.pem_information25%TYPE;
600: l_pem_information26 per_previous_employers.pem_information26%TYPE;
601: l_pem_information27 per_previous_employers.pem_information27%TYPE;
602: l_pem_information28 per_previous_employers.pem_information28%TYPE;
603: l_pem_information29 per_previous_employers.pem_information29%TYPE;
604: l_pem_information30 per_previous_employers.pem_information30%TYPE;
605:
606: l_procedure VARCHAR2(100);

Line 603: l_pem_information29 per_previous_employers.pem_information29%TYPE;

599: l_pem_information25 per_previous_employers.pem_information25%TYPE;
600: l_pem_information26 per_previous_employers.pem_information26%TYPE;
601: l_pem_information27 per_previous_employers.pem_information27%TYPE;
602: l_pem_information28 per_previous_employers.pem_information28%TYPE;
603: l_pem_information29 per_previous_employers.pem_information29%TYPE;
604: l_pem_information30 per_previous_employers.pem_information30%TYPE;
605:
606: l_procedure VARCHAR2(100);
607: l_message VARCHAR2(250);

Line 604: l_pem_information30 per_previous_employers.pem_information30%TYPE;

600: l_pem_information26 per_previous_employers.pem_information26%TYPE;
601: l_pem_information27 per_previous_employers.pem_information27%TYPE;
602: l_pem_information28 per_previous_employers.pem_information28%TYPE;
603: l_pem_information29 per_previous_employers.pem_information29%TYPE;
604: l_pem_information30 per_previous_employers.pem_information30%TYPE;
605:
606: l_procedure VARCHAR2(100);
607: l_message VARCHAR2(250);
608: