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_PERSON_NAME dependencies on PER_ALL_PEOPLE_F

Line 10: g_business_group_id_cached per_all_people_f.business_group_id%TYPE := null;

6: g_format_name_cached hr_name_formats.format_name%TYPE := null;
7: g_format_mask_cached hr_name_formats.format_mask%TYPE := null;
8: g_user_format_choice_cached hr_name_formats.user_format_choice%TYPE := null;
9: g_legislation_code_cached hr_name_formats.legislation_code%TYPE := null;
10: g_business_group_id_cached per_all_people_f.business_group_id%TYPE := null;
11: --
12: --
13: -- ----------------------------------------------------------------------------
14: -- |------------------------< get_token_position >----------------------------|

Line 329: from per_all_people_f

325: ,ORDER_NAME
326: ,LOCAL_NAME
327: ,GLOBAL_NAME
328: ,BUSINESS_GROUP_ID
329: from per_all_people_f
330: where rowid = p_rowid;
331: --
332: begin
333: --

Line 395: from per_all_people_f

391: --
392: cursor csr_get_person_details is
393: select rowid, business_group_id, full_name, order_name
394: ,local_name, global_name
395: from per_all_people_f
396: where person_id = p_person_id
397: and p_effective_date between effective_start_date and effective_end_date;
398:
399: l_person_rec csr_get_person_details%ROWTYPE;

Line 521: from per_all_people_f peo

517: l_legislation varchar2(30);
518: --
519: cursor csr_get_leg is
520: select bg.legislation_code
521: from per_all_people_f peo
522: ,per_business_groups_perf bg
523: where peo.person_id = p_person_id
524: and p_effective_date between peo.effective_start_date and peo.effective_end_date
525: and peo.business_group_id = bg.business_group_id;

Line 569: -- from per_all_people_f

565: -- , suffix
566: -- , hr_general.decode_lookup('TITLE',title) title
567: -- , full_name
568: -- , known_as
569: -- from per_all_people_f
570: -- where person_id = p_person_id
571: -- and trunc(nvl(p_effective_date,sysdate)) between effective_start_date
572: -- and effective_end_date;
573: --

Line 835: p_business_group_id per_all_people_f.business_group_id%TYPE,

831: -- ----------------------------------------------------------------------------
832: --
833: procedure derive_person_names
834: (p_format_name hr_name_formats.format_name%TYPE,
835: p_business_group_id per_all_people_f.business_group_id%TYPE,
836: p_person_id per_all_people_f.person_id%TYPE,
837: p_first_name per_all_people_f.first_name%TYPE,
838: p_middle_names per_all_people_f.middle_names%TYPE,
839: p_last_name per_all_people_f.last_name%TYPE,

Line 836: p_person_id per_all_people_f.person_id%TYPE,

832: --
833: procedure derive_person_names
834: (p_format_name hr_name_formats.format_name%TYPE,
835: p_business_group_id per_all_people_f.business_group_id%TYPE,
836: p_person_id per_all_people_f.person_id%TYPE,
837: p_first_name per_all_people_f.first_name%TYPE,
838: p_middle_names per_all_people_f.middle_names%TYPE,
839: p_last_name per_all_people_f.last_name%TYPE,
840: p_known_as per_all_people_f.known_as%TYPE,

Line 837: p_first_name per_all_people_f.first_name%TYPE,

833: procedure derive_person_names
834: (p_format_name hr_name_formats.format_name%TYPE,
835: p_business_group_id per_all_people_f.business_group_id%TYPE,
836: p_person_id per_all_people_f.person_id%TYPE,
837: p_first_name per_all_people_f.first_name%TYPE,
838: p_middle_names per_all_people_f.middle_names%TYPE,
839: p_last_name per_all_people_f.last_name%TYPE,
840: p_known_as per_all_people_f.known_as%TYPE,
841: p_title per_all_people_f.title%TYPE,

Line 838: p_middle_names per_all_people_f.middle_names%TYPE,

834: (p_format_name hr_name_formats.format_name%TYPE,
835: p_business_group_id per_all_people_f.business_group_id%TYPE,
836: p_person_id per_all_people_f.person_id%TYPE,
837: p_first_name per_all_people_f.first_name%TYPE,
838: p_middle_names per_all_people_f.middle_names%TYPE,
839: p_last_name per_all_people_f.last_name%TYPE,
840: p_known_as per_all_people_f.known_as%TYPE,
841: p_title per_all_people_f.title%TYPE,
842: p_suffix per_all_people_f.suffix%TYPE,

Line 839: p_last_name per_all_people_f.last_name%TYPE,

835: p_business_group_id per_all_people_f.business_group_id%TYPE,
836: p_person_id per_all_people_f.person_id%TYPE,
837: p_first_name per_all_people_f.first_name%TYPE,
838: p_middle_names per_all_people_f.middle_names%TYPE,
839: p_last_name per_all_people_f.last_name%TYPE,
840: p_known_as per_all_people_f.known_as%TYPE,
841: p_title per_all_people_f.title%TYPE,
842: p_suffix per_all_people_f.suffix%TYPE,
843: p_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE,

Line 840: p_known_as per_all_people_f.known_as%TYPE,

836: p_person_id per_all_people_f.person_id%TYPE,
837: p_first_name per_all_people_f.first_name%TYPE,
838: p_middle_names per_all_people_f.middle_names%TYPE,
839: p_last_name per_all_people_f.last_name%TYPE,
840: p_known_as per_all_people_f.known_as%TYPE,
841: p_title per_all_people_f.title%TYPE,
842: p_suffix per_all_people_f.suffix%TYPE,
843: p_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE,
844: p_date_of_birth per_all_people_f.date_of_birth%TYPE,

Line 841: p_title per_all_people_f.title%TYPE,

837: p_first_name per_all_people_f.first_name%TYPE,
838: p_middle_names per_all_people_f.middle_names%TYPE,
839: p_last_name per_all_people_f.last_name%TYPE,
840: p_known_as per_all_people_f.known_as%TYPE,
841: p_title per_all_people_f.title%TYPE,
842: p_suffix per_all_people_f.suffix%TYPE,
843: p_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE,
844: p_date_of_birth per_all_people_f.date_of_birth%TYPE,
845: p_previous_last_name per_all_people_f.previous_last_name%TYPE DEFAULT NULL,

Line 842: p_suffix per_all_people_f.suffix%TYPE,

838: p_middle_names per_all_people_f.middle_names%TYPE,
839: p_last_name per_all_people_f.last_name%TYPE,
840: p_known_as per_all_people_f.known_as%TYPE,
841: p_title per_all_people_f.title%TYPE,
842: p_suffix per_all_people_f.suffix%TYPE,
843: p_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE,
844: p_date_of_birth per_all_people_f.date_of_birth%TYPE,
845: p_previous_last_name per_all_people_f.previous_last_name%TYPE DEFAULT NULL,
846: p_email_address per_all_people_f.email_address%TYPE DEFAULT NULL,

Line 843: p_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE,

839: p_last_name per_all_people_f.last_name%TYPE,
840: p_known_as per_all_people_f.known_as%TYPE,
841: p_title per_all_people_f.title%TYPE,
842: p_suffix per_all_people_f.suffix%TYPE,
843: p_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE,
844: p_date_of_birth per_all_people_f.date_of_birth%TYPE,
845: p_previous_last_name per_all_people_f.previous_last_name%TYPE DEFAULT NULL,
846: p_email_address per_all_people_f.email_address%TYPE DEFAULT NULL,
847: p_employee_number per_all_people_f.employee_number%TYPE DEFAULT NULL,

Line 844: p_date_of_birth per_all_people_f.date_of_birth%TYPE,

840: p_known_as per_all_people_f.known_as%TYPE,
841: p_title per_all_people_f.title%TYPE,
842: p_suffix per_all_people_f.suffix%TYPE,
843: p_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE,
844: p_date_of_birth per_all_people_f.date_of_birth%TYPE,
845: p_previous_last_name per_all_people_f.previous_last_name%TYPE DEFAULT NULL,
846: p_email_address per_all_people_f.email_address%TYPE DEFAULT NULL,
847: p_employee_number per_all_people_f.employee_number%TYPE DEFAULT NULL,
848: p_applicant_number per_all_people_f.applicant_number%TYPE DEFAULT NULL,

Line 845: p_previous_last_name per_all_people_f.previous_last_name%TYPE DEFAULT NULL,

841: p_title per_all_people_f.title%TYPE,
842: p_suffix per_all_people_f.suffix%TYPE,
843: p_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE,
844: p_date_of_birth per_all_people_f.date_of_birth%TYPE,
845: p_previous_last_name per_all_people_f.previous_last_name%TYPE DEFAULT NULL,
846: p_email_address per_all_people_f.email_address%TYPE DEFAULT NULL,
847: p_employee_number per_all_people_f.employee_number%TYPE DEFAULT NULL,
848: p_applicant_number per_all_people_f.applicant_number%TYPE DEFAULT NULL,
849: p_npw_number per_all_people_f.npw_number%TYPE DEFAULT NULL,

Line 846: p_email_address per_all_people_f.email_address%TYPE DEFAULT NULL,

842: p_suffix per_all_people_f.suffix%TYPE,
843: p_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE,
844: p_date_of_birth per_all_people_f.date_of_birth%TYPE,
845: p_previous_last_name per_all_people_f.previous_last_name%TYPE DEFAULT NULL,
846: p_email_address per_all_people_f.email_address%TYPE DEFAULT NULL,
847: p_employee_number per_all_people_f.employee_number%TYPE DEFAULT NULL,
848: p_applicant_number per_all_people_f.applicant_number%TYPE DEFAULT NULL,
849: p_npw_number per_all_people_f.npw_number%TYPE DEFAULT NULL,
850: p_per_information1 per_all_people_f.per_information1%TYPE DEFAULT NULL,

Line 847: p_employee_number per_all_people_f.employee_number%TYPE DEFAULT NULL,

843: p_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE,
844: p_date_of_birth per_all_people_f.date_of_birth%TYPE,
845: p_previous_last_name per_all_people_f.previous_last_name%TYPE DEFAULT NULL,
846: p_email_address per_all_people_f.email_address%TYPE DEFAULT NULL,
847: p_employee_number per_all_people_f.employee_number%TYPE DEFAULT NULL,
848: p_applicant_number per_all_people_f.applicant_number%TYPE DEFAULT NULL,
849: p_npw_number per_all_people_f.npw_number%TYPE DEFAULT NULL,
850: p_per_information1 per_all_people_f.per_information1%TYPE DEFAULT NULL,
851: p_per_information2 per_all_people_f.per_information2%TYPE DEFAULT NULL,

Line 848: p_applicant_number per_all_people_f.applicant_number%TYPE DEFAULT NULL,

844: p_date_of_birth per_all_people_f.date_of_birth%TYPE,
845: p_previous_last_name per_all_people_f.previous_last_name%TYPE DEFAULT NULL,
846: p_email_address per_all_people_f.email_address%TYPE DEFAULT NULL,
847: p_employee_number per_all_people_f.employee_number%TYPE DEFAULT NULL,
848: p_applicant_number per_all_people_f.applicant_number%TYPE DEFAULT NULL,
849: p_npw_number per_all_people_f.npw_number%TYPE DEFAULT NULL,
850: p_per_information1 per_all_people_f.per_information1%TYPE DEFAULT NULL,
851: p_per_information2 per_all_people_f.per_information2%TYPE DEFAULT NULL,
852: p_per_information3 per_all_people_f.per_information3%TYPE DEFAULT NULL,

Line 849: p_npw_number per_all_people_f.npw_number%TYPE DEFAULT NULL,

845: p_previous_last_name per_all_people_f.previous_last_name%TYPE DEFAULT NULL,
846: p_email_address per_all_people_f.email_address%TYPE DEFAULT NULL,
847: p_employee_number per_all_people_f.employee_number%TYPE DEFAULT NULL,
848: p_applicant_number per_all_people_f.applicant_number%TYPE DEFAULT NULL,
849: p_npw_number per_all_people_f.npw_number%TYPE DEFAULT NULL,
850: p_per_information1 per_all_people_f.per_information1%TYPE DEFAULT NULL,
851: p_per_information2 per_all_people_f.per_information2%TYPE DEFAULT NULL,
852: p_per_information3 per_all_people_f.per_information3%TYPE DEFAULT NULL,
853: p_per_information4 per_all_people_f.per_information4%TYPE DEFAULT NULL,

Line 850: p_per_information1 per_all_people_f.per_information1%TYPE DEFAULT NULL,

846: p_email_address per_all_people_f.email_address%TYPE DEFAULT NULL,
847: p_employee_number per_all_people_f.employee_number%TYPE DEFAULT NULL,
848: p_applicant_number per_all_people_f.applicant_number%TYPE DEFAULT NULL,
849: p_npw_number per_all_people_f.npw_number%TYPE DEFAULT NULL,
850: p_per_information1 per_all_people_f.per_information1%TYPE DEFAULT NULL,
851: p_per_information2 per_all_people_f.per_information2%TYPE DEFAULT NULL,
852: p_per_information3 per_all_people_f.per_information3%TYPE DEFAULT NULL,
853: p_per_information4 per_all_people_f.per_information4%TYPE DEFAULT NULL,
854: p_per_information5 per_all_people_f.per_information5%TYPE DEFAULT NULL,

Line 851: p_per_information2 per_all_people_f.per_information2%TYPE DEFAULT NULL,

847: p_employee_number per_all_people_f.employee_number%TYPE DEFAULT NULL,
848: p_applicant_number per_all_people_f.applicant_number%TYPE DEFAULT NULL,
849: p_npw_number per_all_people_f.npw_number%TYPE DEFAULT NULL,
850: p_per_information1 per_all_people_f.per_information1%TYPE DEFAULT NULL,
851: p_per_information2 per_all_people_f.per_information2%TYPE DEFAULT NULL,
852: p_per_information3 per_all_people_f.per_information3%TYPE DEFAULT NULL,
853: p_per_information4 per_all_people_f.per_information4%TYPE DEFAULT NULL,
854: p_per_information5 per_all_people_f.per_information5%TYPE DEFAULT NULL,
855: p_per_information6 per_all_people_f.per_information6%TYPE DEFAULT NULL,

Line 852: p_per_information3 per_all_people_f.per_information3%TYPE DEFAULT NULL,

848: p_applicant_number per_all_people_f.applicant_number%TYPE DEFAULT NULL,
849: p_npw_number per_all_people_f.npw_number%TYPE DEFAULT NULL,
850: p_per_information1 per_all_people_f.per_information1%TYPE DEFAULT NULL,
851: p_per_information2 per_all_people_f.per_information2%TYPE DEFAULT NULL,
852: p_per_information3 per_all_people_f.per_information3%TYPE DEFAULT NULL,
853: p_per_information4 per_all_people_f.per_information4%TYPE DEFAULT NULL,
854: p_per_information5 per_all_people_f.per_information5%TYPE DEFAULT NULL,
855: p_per_information6 per_all_people_f.per_information6%TYPE DEFAULT NULL,
856: p_per_information7 per_all_people_f.per_information7%TYPE DEFAULT NULL,

Line 853: p_per_information4 per_all_people_f.per_information4%TYPE DEFAULT NULL,

849: p_npw_number per_all_people_f.npw_number%TYPE DEFAULT NULL,
850: p_per_information1 per_all_people_f.per_information1%TYPE DEFAULT NULL,
851: p_per_information2 per_all_people_f.per_information2%TYPE DEFAULT NULL,
852: p_per_information3 per_all_people_f.per_information3%TYPE DEFAULT NULL,
853: p_per_information4 per_all_people_f.per_information4%TYPE DEFAULT NULL,
854: p_per_information5 per_all_people_f.per_information5%TYPE DEFAULT NULL,
855: p_per_information6 per_all_people_f.per_information6%TYPE DEFAULT NULL,
856: p_per_information7 per_all_people_f.per_information7%TYPE DEFAULT NULL,
857: p_per_information8 per_all_people_f.per_information8%TYPE DEFAULT NULL,

Line 854: p_per_information5 per_all_people_f.per_information5%TYPE DEFAULT NULL,

850: p_per_information1 per_all_people_f.per_information1%TYPE DEFAULT NULL,
851: p_per_information2 per_all_people_f.per_information2%TYPE DEFAULT NULL,
852: p_per_information3 per_all_people_f.per_information3%TYPE DEFAULT NULL,
853: p_per_information4 per_all_people_f.per_information4%TYPE DEFAULT NULL,
854: p_per_information5 per_all_people_f.per_information5%TYPE DEFAULT NULL,
855: p_per_information6 per_all_people_f.per_information6%TYPE DEFAULT NULL,
856: p_per_information7 per_all_people_f.per_information7%TYPE DEFAULT NULL,
857: p_per_information8 per_all_people_f.per_information8%TYPE DEFAULT NULL,
858: p_per_information9 per_all_people_f.per_information9%TYPE DEFAULT NULL,

Line 855: p_per_information6 per_all_people_f.per_information6%TYPE DEFAULT NULL,

851: p_per_information2 per_all_people_f.per_information2%TYPE DEFAULT NULL,
852: p_per_information3 per_all_people_f.per_information3%TYPE DEFAULT NULL,
853: p_per_information4 per_all_people_f.per_information4%TYPE DEFAULT NULL,
854: p_per_information5 per_all_people_f.per_information5%TYPE DEFAULT NULL,
855: p_per_information6 per_all_people_f.per_information6%TYPE DEFAULT NULL,
856: p_per_information7 per_all_people_f.per_information7%TYPE DEFAULT NULL,
857: p_per_information8 per_all_people_f.per_information8%TYPE DEFAULT NULL,
858: p_per_information9 per_all_people_f.per_information9%TYPE DEFAULT NULL,
859: p_per_information10 per_all_people_f.per_information10%TYPE DEFAULT NULL,

Line 856: p_per_information7 per_all_people_f.per_information7%TYPE DEFAULT NULL,

852: p_per_information3 per_all_people_f.per_information3%TYPE DEFAULT NULL,
853: p_per_information4 per_all_people_f.per_information4%TYPE DEFAULT NULL,
854: p_per_information5 per_all_people_f.per_information5%TYPE DEFAULT NULL,
855: p_per_information6 per_all_people_f.per_information6%TYPE DEFAULT NULL,
856: p_per_information7 per_all_people_f.per_information7%TYPE DEFAULT NULL,
857: p_per_information8 per_all_people_f.per_information8%TYPE DEFAULT NULL,
858: p_per_information9 per_all_people_f.per_information9%TYPE DEFAULT NULL,
859: p_per_information10 per_all_people_f.per_information10%TYPE DEFAULT NULL,
860: p_per_information11 per_all_people_f.per_information11%TYPE DEFAULT NULL,

Line 857: p_per_information8 per_all_people_f.per_information8%TYPE DEFAULT NULL,

853: p_per_information4 per_all_people_f.per_information4%TYPE DEFAULT NULL,
854: p_per_information5 per_all_people_f.per_information5%TYPE DEFAULT NULL,
855: p_per_information6 per_all_people_f.per_information6%TYPE DEFAULT NULL,
856: p_per_information7 per_all_people_f.per_information7%TYPE DEFAULT NULL,
857: p_per_information8 per_all_people_f.per_information8%TYPE DEFAULT NULL,
858: p_per_information9 per_all_people_f.per_information9%TYPE DEFAULT NULL,
859: p_per_information10 per_all_people_f.per_information10%TYPE DEFAULT NULL,
860: p_per_information11 per_all_people_f.per_information11%TYPE DEFAULT NULL,
861: p_per_information12 per_all_people_f.per_information12%TYPE DEFAULT NULL,

Line 858: p_per_information9 per_all_people_f.per_information9%TYPE DEFAULT NULL,

854: p_per_information5 per_all_people_f.per_information5%TYPE DEFAULT NULL,
855: p_per_information6 per_all_people_f.per_information6%TYPE DEFAULT NULL,
856: p_per_information7 per_all_people_f.per_information7%TYPE DEFAULT NULL,
857: p_per_information8 per_all_people_f.per_information8%TYPE DEFAULT NULL,
858: p_per_information9 per_all_people_f.per_information9%TYPE DEFAULT NULL,
859: p_per_information10 per_all_people_f.per_information10%TYPE DEFAULT NULL,
860: p_per_information11 per_all_people_f.per_information11%TYPE DEFAULT NULL,
861: p_per_information12 per_all_people_f.per_information12%TYPE DEFAULT NULL,
862: p_per_information13 per_all_people_f.per_information13%TYPE DEFAULT NULL,

Line 859: p_per_information10 per_all_people_f.per_information10%TYPE DEFAULT NULL,

855: p_per_information6 per_all_people_f.per_information6%TYPE DEFAULT NULL,
856: p_per_information7 per_all_people_f.per_information7%TYPE DEFAULT NULL,
857: p_per_information8 per_all_people_f.per_information8%TYPE DEFAULT NULL,
858: p_per_information9 per_all_people_f.per_information9%TYPE DEFAULT NULL,
859: p_per_information10 per_all_people_f.per_information10%TYPE DEFAULT NULL,
860: p_per_information11 per_all_people_f.per_information11%TYPE DEFAULT NULL,
861: p_per_information12 per_all_people_f.per_information12%TYPE DEFAULT NULL,
862: p_per_information13 per_all_people_f.per_information13%TYPE DEFAULT NULL,
863: p_per_information14 per_all_people_f.per_information14%TYPE DEFAULT NULL,

Line 860: p_per_information11 per_all_people_f.per_information11%TYPE DEFAULT NULL,

856: p_per_information7 per_all_people_f.per_information7%TYPE DEFAULT NULL,
857: p_per_information8 per_all_people_f.per_information8%TYPE DEFAULT NULL,
858: p_per_information9 per_all_people_f.per_information9%TYPE DEFAULT NULL,
859: p_per_information10 per_all_people_f.per_information10%TYPE DEFAULT NULL,
860: p_per_information11 per_all_people_f.per_information11%TYPE DEFAULT NULL,
861: p_per_information12 per_all_people_f.per_information12%TYPE DEFAULT NULL,
862: p_per_information13 per_all_people_f.per_information13%TYPE DEFAULT NULL,
863: p_per_information14 per_all_people_f.per_information14%TYPE DEFAULT NULL,
864: p_per_information15 per_all_people_f.per_information15%TYPE DEFAULT NULL,

Line 861: p_per_information12 per_all_people_f.per_information12%TYPE DEFAULT NULL,

857: p_per_information8 per_all_people_f.per_information8%TYPE DEFAULT NULL,
858: p_per_information9 per_all_people_f.per_information9%TYPE DEFAULT NULL,
859: p_per_information10 per_all_people_f.per_information10%TYPE DEFAULT NULL,
860: p_per_information11 per_all_people_f.per_information11%TYPE DEFAULT NULL,
861: p_per_information12 per_all_people_f.per_information12%TYPE DEFAULT NULL,
862: p_per_information13 per_all_people_f.per_information13%TYPE DEFAULT NULL,
863: p_per_information14 per_all_people_f.per_information14%TYPE DEFAULT NULL,
864: p_per_information15 per_all_people_f.per_information15%TYPE DEFAULT NULL,
865: p_per_information16 per_all_people_f.per_information16%TYPE DEFAULT NULL,

Line 862: p_per_information13 per_all_people_f.per_information13%TYPE DEFAULT NULL,

858: p_per_information9 per_all_people_f.per_information9%TYPE DEFAULT NULL,
859: p_per_information10 per_all_people_f.per_information10%TYPE DEFAULT NULL,
860: p_per_information11 per_all_people_f.per_information11%TYPE DEFAULT NULL,
861: p_per_information12 per_all_people_f.per_information12%TYPE DEFAULT NULL,
862: p_per_information13 per_all_people_f.per_information13%TYPE DEFAULT NULL,
863: p_per_information14 per_all_people_f.per_information14%TYPE DEFAULT NULL,
864: p_per_information15 per_all_people_f.per_information15%TYPE DEFAULT NULL,
865: p_per_information16 per_all_people_f.per_information16%TYPE DEFAULT NULL,
866: p_per_information17 per_all_people_f.per_information17%TYPE DEFAULT NULL,

Line 863: p_per_information14 per_all_people_f.per_information14%TYPE DEFAULT NULL,

859: p_per_information10 per_all_people_f.per_information10%TYPE DEFAULT NULL,
860: p_per_information11 per_all_people_f.per_information11%TYPE DEFAULT NULL,
861: p_per_information12 per_all_people_f.per_information12%TYPE DEFAULT NULL,
862: p_per_information13 per_all_people_f.per_information13%TYPE DEFAULT NULL,
863: p_per_information14 per_all_people_f.per_information14%TYPE DEFAULT NULL,
864: p_per_information15 per_all_people_f.per_information15%TYPE DEFAULT NULL,
865: p_per_information16 per_all_people_f.per_information16%TYPE DEFAULT NULL,
866: p_per_information17 per_all_people_f.per_information17%TYPE DEFAULT NULL,
867: p_per_information18 per_all_people_f.per_information18%TYPE DEFAULT NULL,

Line 864: p_per_information15 per_all_people_f.per_information15%TYPE DEFAULT NULL,

860: p_per_information11 per_all_people_f.per_information11%TYPE DEFAULT NULL,
861: p_per_information12 per_all_people_f.per_information12%TYPE DEFAULT NULL,
862: p_per_information13 per_all_people_f.per_information13%TYPE DEFAULT NULL,
863: p_per_information14 per_all_people_f.per_information14%TYPE DEFAULT NULL,
864: p_per_information15 per_all_people_f.per_information15%TYPE DEFAULT NULL,
865: p_per_information16 per_all_people_f.per_information16%TYPE DEFAULT NULL,
866: p_per_information17 per_all_people_f.per_information17%TYPE DEFAULT NULL,
867: p_per_information18 per_all_people_f.per_information18%TYPE DEFAULT NULL,
868: p_per_information19 per_all_people_f.per_information19%TYPE DEFAULT NULL,

Line 865: p_per_information16 per_all_people_f.per_information16%TYPE DEFAULT NULL,

861: p_per_information12 per_all_people_f.per_information12%TYPE DEFAULT NULL,
862: p_per_information13 per_all_people_f.per_information13%TYPE DEFAULT NULL,
863: p_per_information14 per_all_people_f.per_information14%TYPE DEFAULT NULL,
864: p_per_information15 per_all_people_f.per_information15%TYPE DEFAULT NULL,
865: p_per_information16 per_all_people_f.per_information16%TYPE DEFAULT NULL,
866: p_per_information17 per_all_people_f.per_information17%TYPE DEFAULT NULL,
867: p_per_information18 per_all_people_f.per_information18%TYPE DEFAULT NULL,
868: p_per_information19 per_all_people_f.per_information19%TYPE DEFAULT NULL,
869: p_per_information20 per_all_people_f.per_information20%TYPE DEFAULT NULL,

Line 866: p_per_information17 per_all_people_f.per_information17%TYPE DEFAULT NULL,

862: p_per_information13 per_all_people_f.per_information13%TYPE DEFAULT NULL,
863: p_per_information14 per_all_people_f.per_information14%TYPE DEFAULT NULL,
864: p_per_information15 per_all_people_f.per_information15%TYPE DEFAULT NULL,
865: p_per_information16 per_all_people_f.per_information16%TYPE DEFAULT NULL,
866: p_per_information17 per_all_people_f.per_information17%TYPE DEFAULT NULL,
867: p_per_information18 per_all_people_f.per_information18%TYPE DEFAULT NULL,
868: p_per_information19 per_all_people_f.per_information19%TYPE DEFAULT NULL,
869: p_per_information20 per_all_people_f.per_information20%TYPE DEFAULT NULL,
870: p_per_information21 per_all_people_f.per_information21%TYPE DEFAULT NULL,

Line 867: p_per_information18 per_all_people_f.per_information18%TYPE DEFAULT NULL,

863: p_per_information14 per_all_people_f.per_information14%TYPE DEFAULT NULL,
864: p_per_information15 per_all_people_f.per_information15%TYPE DEFAULT NULL,
865: p_per_information16 per_all_people_f.per_information16%TYPE DEFAULT NULL,
866: p_per_information17 per_all_people_f.per_information17%TYPE DEFAULT NULL,
867: p_per_information18 per_all_people_f.per_information18%TYPE DEFAULT NULL,
868: p_per_information19 per_all_people_f.per_information19%TYPE DEFAULT NULL,
869: p_per_information20 per_all_people_f.per_information20%TYPE DEFAULT NULL,
870: p_per_information21 per_all_people_f.per_information21%TYPE DEFAULT NULL,
871: p_per_information22 per_all_people_f.per_information22%TYPE DEFAULT NULL,

Line 868: p_per_information19 per_all_people_f.per_information19%TYPE DEFAULT NULL,

864: p_per_information15 per_all_people_f.per_information15%TYPE DEFAULT NULL,
865: p_per_information16 per_all_people_f.per_information16%TYPE DEFAULT NULL,
866: p_per_information17 per_all_people_f.per_information17%TYPE DEFAULT NULL,
867: p_per_information18 per_all_people_f.per_information18%TYPE DEFAULT NULL,
868: p_per_information19 per_all_people_f.per_information19%TYPE DEFAULT NULL,
869: p_per_information20 per_all_people_f.per_information20%TYPE DEFAULT NULL,
870: p_per_information21 per_all_people_f.per_information21%TYPE DEFAULT NULL,
871: p_per_information22 per_all_people_f.per_information22%TYPE DEFAULT NULL,
872: p_per_information23 per_all_people_f.per_information23%TYPE DEFAULT NULL,

Line 869: p_per_information20 per_all_people_f.per_information20%TYPE DEFAULT NULL,

865: p_per_information16 per_all_people_f.per_information16%TYPE DEFAULT NULL,
866: p_per_information17 per_all_people_f.per_information17%TYPE DEFAULT NULL,
867: p_per_information18 per_all_people_f.per_information18%TYPE DEFAULT NULL,
868: p_per_information19 per_all_people_f.per_information19%TYPE DEFAULT NULL,
869: p_per_information20 per_all_people_f.per_information20%TYPE DEFAULT NULL,
870: p_per_information21 per_all_people_f.per_information21%TYPE DEFAULT NULL,
871: p_per_information22 per_all_people_f.per_information22%TYPE DEFAULT NULL,
872: p_per_information23 per_all_people_f.per_information23%TYPE DEFAULT NULL,
873: p_per_information24 per_all_people_f.per_information24%TYPE DEFAULT NULL,

Line 870: p_per_information21 per_all_people_f.per_information21%TYPE DEFAULT NULL,

866: p_per_information17 per_all_people_f.per_information17%TYPE DEFAULT NULL,
867: p_per_information18 per_all_people_f.per_information18%TYPE DEFAULT NULL,
868: p_per_information19 per_all_people_f.per_information19%TYPE DEFAULT NULL,
869: p_per_information20 per_all_people_f.per_information20%TYPE DEFAULT NULL,
870: p_per_information21 per_all_people_f.per_information21%TYPE DEFAULT NULL,
871: p_per_information22 per_all_people_f.per_information22%TYPE DEFAULT NULL,
872: p_per_information23 per_all_people_f.per_information23%TYPE DEFAULT NULL,
873: p_per_information24 per_all_people_f.per_information24%TYPE DEFAULT NULL,
874: p_per_information25 per_all_people_f.per_information25%TYPE DEFAULT NULL,

Line 871: p_per_information22 per_all_people_f.per_information22%TYPE DEFAULT NULL,

867: p_per_information18 per_all_people_f.per_information18%TYPE DEFAULT NULL,
868: p_per_information19 per_all_people_f.per_information19%TYPE DEFAULT NULL,
869: p_per_information20 per_all_people_f.per_information20%TYPE DEFAULT NULL,
870: p_per_information21 per_all_people_f.per_information21%TYPE DEFAULT NULL,
871: p_per_information22 per_all_people_f.per_information22%TYPE DEFAULT NULL,
872: p_per_information23 per_all_people_f.per_information23%TYPE DEFAULT NULL,
873: p_per_information24 per_all_people_f.per_information24%TYPE DEFAULT NULL,
874: p_per_information25 per_all_people_f.per_information25%TYPE DEFAULT NULL,
875: p_per_information26 per_all_people_f.per_information26%TYPE DEFAULT NULL,

Line 872: p_per_information23 per_all_people_f.per_information23%TYPE DEFAULT NULL,

868: p_per_information19 per_all_people_f.per_information19%TYPE DEFAULT NULL,
869: p_per_information20 per_all_people_f.per_information20%TYPE DEFAULT NULL,
870: p_per_information21 per_all_people_f.per_information21%TYPE DEFAULT NULL,
871: p_per_information22 per_all_people_f.per_information22%TYPE DEFAULT NULL,
872: p_per_information23 per_all_people_f.per_information23%TYPE DEFAULT NULL,
873: p_per_information24 per_all_people_f.per_information24%TYPE DEFAULT NULL,
874: p_per_information25 per_all_people_f.per_information25%TYPE DEFAULT NULL,
875: p_per_information26 per_all_people_f.per_information26%TYPE DEFAULT NULL,
876: p_per_information27 per_all_people_f.per_information27%TYPE DEFAULT NULL,

Line 873: p_per_information24 per_all_people_f.per_information24%TYPE DEFAULT NULL,

869: p_per_information20 per_all_people_f.per_information20%TYPE DEFAULT NULL,
870: p_per_information21 per_all_people_f.per_information21%TYPE DEFAULT NULL,
871: p_per_information22 per_all_people_f.per_information22%TYPE DEFAULT NULL,
872: p_per_information23 per_all_people_f.per_information23%TYPE DEFAULT NULL,
873: p_per_information24 per_all_people_f.per_information24%TYPE DEFAULT NULL,
874: p_per_information25 per_all_people_f.per_information25%TYPE DEFAULT NULL,
875: p_per_information26 per_all_people_f.per_information26%TYPE DEFAULT NULL,
876: p_per_information27 per_all_people_f.per_information27%TYPE DEFAULT NULL,
877: p_per_information28 per_all_people_f.per_information28%TYPE DEFAULT NULL,

Line 874: p_per_information25 per_all_people_f.per_information25%TYPE DEFAULT NULL,

870: p_per_information21 per_all_people_f.per_information21%TYPE DEFAULT NULL,
871: p_per_information22 per_all_people_f.per_information22%TYPE DEFAULT NULL,
872: p_per_information23 per_all_people_f.per_information23%TYPE DEFAULT NULL,
873: p_per_information24 per_all_people_f.per_information24%TYPE DEFAULT NULL,
874: p_per_information25 per_all_people_f.per_information25%TYPE DEFAULT NULL,
875: p_per_information26 per_all_people_f.per_information26%TYPE DEFAULT NULL,
876: p_per_information27 per_all_people_f.per_information27%TYPE DEFAULT NULL,
877: p_per_information28 per_all_people_f.per_information28%TYPE DEFAULT NULL,
878: p_per_information29 per_all_people_f.per_information29%TYPE DEFAULT NULL,

Line 875: p_per_information26 per_all_people_f.per_information26%TYPE DEFAULT NULL,

871: p_per_information22 per_all_people_f.per_information22%TYPE DEFAULT NULL,
872: p_per_information23 per_all_people_f.per_information23%TYPE DEFAULT NULL,
873: p_per_information24 per_all_people_f.per_information24%TYPE DEFAULT NULL,
874: p_per_information25 per_all_people_f.per_information25%TYPE DEFAULT NULL,
875: p_per_information26 per_all_people_f.per_information26%TYPE DEFAULT NULL,
876: p_per_information27 per_all_people_f.per_information27%TYPE DEFAULT NULL,
877: p_per_information28 per_all_people_f.per_information28%TYPE DEFAULT NULL,
878: p_per_information29 per_all_people_f.per_information29%TYPE DEFAULT NULL,
879: p_per_information30 per_all_people_f.per_information30%TYPE DEFAULT NULL,

Line 876: p_per_information27 per_all_people_f.per_information27%TYPE DEFAULT NULL,

872: p_per_information23 per_all_people_f.per_information23%TYPE DEFAULT NULL,
873: p_per_information24 per_all_people_f.per_information24%TYPE DEFAULT NULL,
874: p_per_information25 per_all_people_f.per_information25%TYPE DEFAULT NULL,
875: p_per_information26 per_all_people_f.per_information26%TYPE DEFAULT NULL,
876: p_per_information27 per_all_people_f.per_information27%TYPE DEFAULT NULL,
877: p_per_information28 per_all_people_f.per_information28%TYPE DEFAULT NULL,
878: p_per_information29 per_all_people_f.per_information29%TYPE DEFAULT NULL,
879: p_per_information30 per_all_people_f.per_information30%TYPE DEFAULT NULL,
880: p_attribute1 per_all_people_f.attribute1%TYPE DEFAULT NULL,

Line 877: p_per_information28 per_all_people_f.per_information28%TYPE DEFAULT NULL,

873: p_per_information24 per_all_people_f.per_information24%TYPE DEFAULT NULL,
874: p_per_information25 per_all_people_f.per_information25%TYPE DEFAULT NULL,
875: p_per_information26 per_all_people_f.per_information26%TYPE DEFAULT NULL,
876: p_per_information27 per_all_people_f.per_information27%TYPE DEFAULT NULL,
877: p_per_information28 per_all_people_f.per_information28%TYPE DEFAULT NULL,
878: p_per_information29 per_all_people_f.per_information29%TYPE DEFAULT NULL,
879: p_per_information30 per_all_people_f.per_information30%TYPE DEFAULT NULL,
880: p_attribute1 per_all_people_f.attribute1%TYPE DEFAULT NULL,
881: p_attribute2 per_all_people_f.attribute2%TYPE DEFAULT NULL,

Line 878: p_per_information29 per_all_people_f.per_information29%TYPE DEFAULT NULL,

874: p_per_information25 per_all_people_f.per_information25%TYPE DEFAULT NULL,
875: p_per_information26 per_all_people_f.per_information26%TYPE DEFAULT NULL,
876: p_per_information27 per_all_people_f.per_information27%TYPE DEFAULT NULL,
877: p_per_information28 per_all_people_f.per_information28%TYPE DEFAULT NULL,
878: p_per_information29 per_all_people_f.per_information29%TYPE DEFAULT NULL,
879: p_per_information30 per_all_people_f.per_information30%TYPE DEFAULT NULL,
880: p_attribute1 per_all_people_f.attribute1%TYPE DEFAULT NULL,
881: p_attribute2 per_all_people_f.attribute2%TYPE DEFAULT NULL,
882: p_attribute3 per_all_people_f.attribute3%TYPE DEFAULT NULL,

Line 879: p_per_information30 per_all_people_f.per_information30%TYPE DEFAULT NULL,

875: p_per_information26 per_all_people_f.per_information26%TYPE DEFAULT NULL,
876: p_per_information27 per_all_people_f.per_information27%TYPE DEFAULT NULL,
877: p_per_information28 per_all_people_f.per_information28%TYPE DEFAULT NULL,
878: p_per_information29 per_all_people_f.per_information29%TYPE DEFAULT NULL,
879: p_per_information30 per_all_people_f.per_information30%TYPE DEFAULT NULL,
880: p_attribute1 per_all_people_f.attribute1%TYPE DEFAULT NULL,
881: p_attribute2 per_all_people_f.attribute2%TYPE DEFAULT NULL,
882: p_attribute3 per_all_people_f.attribute3%TYPE DEFAULT NULL,
883: p_attribute4 per_all_people_f.attribute4%TYPE DEFAULT NULL,

Line 880: p_attribute1 per_all_people_f.attribute1%TYPE DEFAULT NULL,

876: p_per_information27 per_all_people_f.per_information27%TYPE DEFAULT NULL,
877: p_per_information28 per_all_people_f.per_information28%TYPE DEFAULT NULL,
878: p_per_information29 per_all_people_f.per_information29%TYPE DEFAULT NULL,
879: p_per_information30 per_all_people_f.per_information30%TYPE DEFAULT NULL,
880: p_attribute1 per_all_people_f.attribute1%TYPE DEFAULT NULL,
881: p_attribute2 per_all_people_f.attribute2%TYPE DEFAULT NULL,
882: p_attribute3 per_all_people_f.attribute3%TYPE DEFAULT NULL,
883: p_attribute4 per_all_people_f.attribute4%TYPE DEFAULT NULL,
884: p_attribute5 per_all_people_f.attribute5%TYPE DEFAULT NULL,

Line 881: p_attribute2 per_all_people_f.attribute2%TYPE DEFAULT NULL,

877: p_per_information28 per_all_people_f.per_information28%TYPE DEFAULT NULL,
878: p_per_information29 per_all_people_f.per_information29%TYPE DEFAULT NULL,
879: p_per_information30 per_all_people_f.per_information30%TYPE DEFAULT NULL,
880: p_attribute1 per_all_people_f.attribute1%TYPE DEFAULT NULL,
881: p_attribute2 per_all_people_f.attribute2%TYPE DEFAULT NULL,
882: p_attribute3 per_all_people_f.attribute3%TYPE DEFAULT NULL,
883: p_attribute4 per_all_people_f.attribute4%TYPE DEFAULT NULL,
884: p_attribute5 per_all_people_f.attribute5%TYPE DEFAULT NULL,
885: p_attribute6 per_all_people_f.attribute6%TYPE DEFAULT NULL,

Line 882: p_attribute3 per_all_people_f.attribute3%TYPE DEFAULT NULL,

878: p_per_information29 per_all_people_f.per_information29%TYPE DEFAULT NULL,
879: p_per_information30 per_all_people_f.per_information30%TYPE DEFAULT NULL,
880: p_attribute1 per_all_people_f.attribute1%TYPE DEFAULT NULL,
881: p_attribute2 per_all_people_f.attribute2%TYPE DEFAULT NULL,
882: p_attribute3 per_all_people_f.attribute3%TYPE DEFAULT NULL,
883: p_attribute4 per_all_people_f.attribute4%TYPE DEFAULT NULL,
884: p_attribute5 per_all_people_f.attribute5%TYPE DEFAULT NULL,
885: p_attribute6 per_all_people_f.attribute6%TYPE DEFAULT NULL,
886: p_attribute7 per_all_people_f.attribute7%TYPE DEFAULT NULL,

Line 883: p_attribute4 per_all_people_f.attribute4%TYPE DEFAULT NULL,

879: p_per_information30 per_all_people_f.per_information30%TYPE DEFAULT NULL,
880: p_attribute1 per_all_people_f.attribute1%TYPE DEFAULT NULL,
881: p_attribute2 per_all_people_f.attribute2%TYPE DEFAULT NULL,
882: p_attribute3 per_all_people_f.attribute3%TYPE DEFAULT NULL,
883: p_attribute4 per_all_people_f.attribute4%TYPE DEFAULT NULL,
884: p_attribute5 per_all_people_f.attribute5%TYPE DEFAULT NULL,
885: p_attribute6 per_all_people_f.attribute6%TYPE DEFAULT NULL,
886: p_attribute7 per_all_people_f.attribute7%TYPE DEFAULT NULL,
887: p_attribute8 per_all_people_f.attribute8%TYPE DEFAULT NULL,

Line 884: p_attribute5 per_all_people_f.attribute5%TYPE DEFAULT NULL,

880: p_attribute1 per_all_people_f.attribute1%TYPE DEFAULT NULL,
881: p_attribute2 per_all_people_f.attribute2%TYPE DEFAULT NULL,
882: p_attribute3 per_all_people_f.attribute3%TYPE DEFAULT NULL,
883: p_attribute4 per_all_people_f.attribute4%TYPE DEFAULT NULL,
884: p_attribute5 per_all_people_f.attribute5%TYPE DEFAULT NULL,
885: p_attribute6 per_all_people_f.attribute6%TYPE DEFAULT NULL,
886: p_attribute7 per_all_people_f.attribute7%TYPE DEFAULT NULL,
887: p_attribute8 per_all_people_f.attribute8%TYPE DEFAULT NULL,
888: p_attribute9 per_all_people_f.attribute9%TYPE DEFAULT NULL,

Line 885: p_attribute6 per_all_people_f.attribute6%TYPE DEFAULT NULL,

881: p_attribute2 per_all_people_f.attribute2%TYPE DEFAULT NULL,
882: p_attribute3 per_all_people_f.attribute3%TYPE DEFAULT NULL,
883: p_attribute4 per_all_people_f.attribute4%TYPE DEFAULT NULL,
884: p_attribute5 per_all_people_f.attribute5%TYPE DEFAULT NULL,
885: p_attribute6 per_all_people_f.attribute6%TYPE DEFAULT NULL,
886: p_attribute7 per_all_people_f.attribute7%TYPE DEFAULT NULL,
887: p_attribute8 per_all_people_f.attribute8%TYPE DEFAULT NULL,
888: p_attribute9 per_all_people_f.attribute9%TYPE DEFAULT NULL,
889: p_attribute10 per_all_people_f.attribute10%TYPE DEFAULT NULL,

Line 886: p_attribute7 per_all_people_f.attribute7%TYPE DEFAULT NULL,

882: p_attribute3 per_all_people_f.attribute3%TYPE DEFAULT NULL,
883: p_attribute4 per_all_people_f.attribute4%TYPE DEFAULT NULL,
884: p_attribute5 per_all_people_f.attribute5%TYPE DEFAULT NULL,
885: p_attribute6 per_all_people_f.attribute6%TYPE DEFAULT NULL,
886: p_attribute7 per_all_people_f.attribute7%TYPE DEFAULT NULL,
887: p_attribute8 per_all_people_f.attribute8%TYPE DEFAULT NULL,
888: p_attribute9 per_all_people_f.attribute9%TYPE DEFAULT NULL,
889: p_attribute10 per_all_people_f.attribute10%TYPE DEFAULT NULL,
890: p_attribute11 per_all_people_f.attribute11%TYPE DEFAULT NULL,

Line 887: p_attribute8 per_all_people_f.attribute8%TYPE DEFAULT NULL,

883: p_attribute4 per_all_people_f.attribute4%TYPE DEFAULT NULL,
884: p_attribute5 per_all_people_f.attribute5%TYPE DEFAULT NULL,
885: p_attribute6 per_all_people_f.attribute6%TYPE DEFAULT NULL,
886: p_attribute7 per_all_people_f.attribute7%TYPE DEFAULT NULL,
887: p_attribute8 per_all_people_f.attribute8%TYPE DEFAULT NULL,
888: p_attribute9 per_all_people_f.attribute9%TYPE DEFAULT NULL,
889: p_attribute10 per_all_people_f.attribute10%TYPE DEFAULT NULL,
890: p_attribute11 per_all_people_f.attribute11%TYPE DEFAULT NULL,
891: p_attribute12 per_all_people_f.attribute12%TYPE DEFAULT NULL,

Line 888: p_attribute9 per_all_people_f.attribute9%TYPE DEFAULT NULL,

884: p_attribute5 per_all_people_f.attribute5%TYPE DEFAULT NULL,
885: p_attribute6 per_all_people_f.attribute6%TYPE DEFAULT NULL,
886: p_attribute7 per_all_people_f.attribute7%TYPE DEFAULT NULL,
887: p_attribute8 per_all_people_f.attribute8%TYPE DEFAULT NULL,
888: p_attribute9 per_all_people_f.attribute9%TYPE DEFAULT NULL,
889: p_attribute10 per_all_people_f.attribute10%TYPE DEFAULT NULL,
890: p_attribute11 per_all_people_f.attribute11%TYPE DEFAULT NULL,
891: p_attribute12 per_all_people_f.attribute12%TYPE DEFAULT NULL,
892: p_attribute13 per_all_people_f.attribute13%TYPE DEFAULT NULL,

Line 889: p_attribute10 per_all_people_f.attribute10%TYPE DEFAULT NULL,

885: p_attribute6 per_all_people_f.attribute6%TYPE DEFAULT NULL,
886: p_attribute7 per_all_people_f.attribute7%TYPE DEFAULT NULL,
887: p_attribute8 per_all_people_f.attribute8%TYPE DEFAULT NULL,
888: p_attribute9 per_all_people_f.attribute9%TYPE DEFAULT NULL,
889: p_attribute10 per_all_people_f.attribute10%TYPE DEFAULT NULL,
890: p_attribute11 per_all_people_f.attribute11%TYPE DEFAULT NULL,
891: p_attribute12 per_all_people_f.attribute12%TYPE DEFAULT NULL,
892: p_attribute13 per_all_people_f.attribute13%TYPE DEFAULT NULL,
893: p_attribute14 per_all_people_f.attribute14%TYPE DEFAULT NULL,

Line 890: p_attribute11 per_all_people_f.attribute11%TYPE DEFAULT NULL,

886: p_attribute7 per_all_people_f.attribute7%TYPE DEFAULT NULL,
887: p_attribute8 per_all_people_f.attribute8%TYPE DEFAULT NULL,
888: p_attribute9 per_all_people_f.attribute9%TYPE DEFAULT NULL,
889: p_attribute10 per_all_people_f.attribute10%TYPE DEFAULT NULL,
890: p_attribute11 per_all_people_f.attribute11%TYPE DEFAULT NULL,
891: p_attribute12 per_all_people_f.attribute12%TYPE DEFAULT NULL,
892: p_attribute13 per_all_people_f.attribute13%TYPE DEFAULT NULL,
893: p_attribute14 per_all_people_f.attribute14%TYPE DEFAULT NULL,
894: p_attribute15 per_all_people_f.attribute15%TYPE DEFAULT NULL,

Line 891: p_attribute12 per_all_people_f.attribute12%TYPE DEFAULT NULL,

887: p_attribute8 per_all_people_f.attribute8%TYPE DEFAULT NULL,
888: p_attribute9 per_all_people_f.attribute9%TYPE DEFAULT NULL,
889: p_attribute10 per_all_people_f.attribute10%TYPE DEFAULT NULL,
890: p_attribute11 per_all_people_f.attribute11%TYPE DEFAULT NULL,
891: p_attribute12 per_all_people_f.attribute12%TYPE DEFAULT NULL,
892: p_attribute13 per_all_people_f.attribute13%TYPE DEFAULT NULL,
893: p_attribute14 per_all_people_f.attribute14%TYPE DEFAULT NULL,
894: p_attribute15 per_all_people_f.attribute15%TYPE DEFAULT NULL,
895: p_attribute16 per_all_people_f.attribute16%TYPE DEFAULT NULL,

Line 892: p_attribute13 per_all_people_f.attribute13%TYPE DEFAULT NULL,

888: p_attribute9 per_all_people_f.attribute9%TYPE DEFAULT NULL,
889: p_attribute10 per_all_people_f.attribute10%TYPE DEFAULT NULL,
890: p_attribute11 per_all_people_f.attribute11%TYPE DEFAULT NULL,
891: p_attribute12 per_all_people_f.attribute12%TYPE DEFAULT NULL,
892: p_attribute13 per_all_people_f.attribute13%TYPE DEFAULT NULL,
893: p_attribute14 per_all_people_f.attribute14%TYPE DEFAULT NULL,
894: p_attribute15 per_all_people_f.attribute15%TYPE DEFAULT NULL,
895: p_attribute16 per_all_people_f.attribute16%TYPE DEFAULT NULL,
896: p_attribute17 per_all_people_f.attribute17%TYPE DEFAULT NULL,

Line 893: p_attribute14 per_all_people_f.attribute14%TYPE DEFAULT NULL,

889: p_attribute10 per_all_people_f.attribute10%TYPE DEFAULT NULL,
890: p_attribute11 per_all_people_f.attribute11%TYPE DEFAULT NULL,
891: p_attribute12 per_all_people_f.attribute12%TYPE DEFAULT NULL,
892: p_attribute13 per_all_people_f.attribute13%TYPE DEFAULT NULL,
893: p_attribute14 per_all_people_f.attribute14%TYPE DEFAULT NULL,
894: p_attribute15 per_all_people_f.attribute15%TYPE DEFAULT NULL,
895: p_attribute16 per_all_people_f.attribute16%TYPE DEFAULT NULL,
896: p_attribute17 per_all_people_f.attribute17%TYPE DEFAULT NULL,
897: p_attribute18 per_all_people_f.attribute18%TYPE DEFAULT NULL,

Line 894: p_attribute15 per_all_people_f.attribute15%TYPE DEFAULT NULL,

890: p_attribute11 per_all_people_f.attribute11%TYPE DEFAULT NULL,
891: p_attribute12 per_all_people_f.attribute12%TYPE DEFAULT NULL,
892: p_attribute13 per_all_people_f.attribute13%TYPE DEFAULT NULL,
893: p_attribute14 per_all_people_f.attribute14%TYPE DEFAULT NULL,
894: p_attribute15 per_all_people_f.attribute15%TYPE DEFAULT NULL,
895: p_attribute16 per_all_people_f.attribute16%TYPE DEFAULT NULL,
896: p_attribute17 per_all_people_f.attribute17%TYPE DEFAULT NULL,
897: p_attribute18 per_all_people_f.attribute18%TYPE DEFAULT NULL,
898: p_attribute19 per_all_people_f.attribute19%TYPE DEFAULT NULL,

Line 895: p_attribute16 per_all_people_f.attribute16%TYPE DEFAULT NULL,

891: p_attribute12 per_all_people_f.attribute12%TYPE DEFAULT NULL,
892: p_attribute13 per_all_people_f.attribute13%TYPE DEFAULT NULL,
893: p_attribute14 per_all_people_f.attribute14%TYPE DEFAULT NULL,
894: p_attribute15 per_all_people_f.attribute15%TYPE DEFAULT NULL,
895: p_attribute16 per_all_people_f.attribute16%TYPE DEFAULT NULL,
896: p_attribute17 per_all_people_f.attribute17%TYPE DEFAULT NULL,
897: p_attribute18 per_all_people_f.attribute18%TYPE DEFAULT NULL,
898: p_attribute19 per_all_people_f.attribute19%TYPE DEFAULT NULL,
899: p_attribute20 per_all_people_f.attribute20%TYPE DEFAULT NULL,

Line 896: p_attribute17 per_all_people_f.attribute17%TYPE DEFAULT NULL,

892: p_attribute13 per_all_people_f.attribute13%TYPE DEFAULT NULL,
893: p_attribute14 per_all_people_f.attribute14%TYPE DEFAULT NULL,
894: p_attribute15 per_all_people_f.attribute15%TYPE DEFAULT NULL,
895: p_attribute16 per_all_people_f.attribute16%TYPE DEFAULT NULL,
896: p_attribute17 per_all_people_f.attribute17%TYPE DEFAULT NULL,
897: p_attribute18 per_all_people_f.attribute18%TYPE DEFAULT NULL,
898: p_attribute19 per_all_people_f.attribute19%TYPE DEFAULT NULL,
899: p_attribute20 per_all_people_f.attribute20%TYPE DEFAULT NULL,
900: p_attribute21 per_all_people_f.attribute21%TYPE DEFAULT NULL,

Line 897: p_attribute18 per_all_people_f.attribute18%TYPE DEFAULT NULL,

893: p_attribute14 per_all_people_f.attribute14%TYPE DEFAULT NULL,
894: p_attribute15 per_all_people_f.attribute15%TYPE DEFAULT NULL,
895: p_attribute16 per_all_people_f.attribute16%TYPE DEFAULT NULL,
896: p_attribute17 per_all_people_f.attribute17%TYPE DEFAULT NULL,
897: p_attribute18 per_all_people_f.attribute18%TYPE DEFAULT NULL,
898: p_attribute19 per_all_people_f.attribute19%TYPE DEFAULT NULL,
899: p_attribute20 per_all_people_f.attribute20%TYPE DEFAULT NULL,
900: p_attribute21 per_all_people_f.attribute21%TYPE DEFAULT NULL,
901: p_attribute22 per_all_people_f.attribute22%TYPE DEFAULT NULL,

Line 898: p_attribute19 per_all_people_f.attribute19%TYPE DEFAULT NULL,

894: p_attribute15 per_all_people_f.attribute15%TYPE DEFAULT NULL,
895: p_attribute16 per_all_people_f.attribute16%TYPE DEFAULT NULL,
896: p_attribute17 per_all_people_f.attribute17%TYPE DEFAULT NULL,
897: p_attribute18 per_all_people_f.attribute18%TYPE DEFAULT NULL,
898: p_attribute19 per_all_people_f.attribute19%TYPE DEFAULT NULL,
899: p_attribute20 per_all_people_f.attribute20%TYPE DEFAULT NULL,
900: p_attribute21 per_all_people_f.attribute21%TYPE DEFAULT NULL,
901: p_attribute22 per_all_people_f.attribute22%TYPE DEFAULT NULL,
902: p_attribute23 per_all_people_f.attribute23%TYPE DEFAULT NULL,

Line 899: p_attribute20 per_all_people_f.attribute20%TYPE DEFAULT NULL,

895: p_attribute16 per_all_people_f.attribute16%TYPE DEFAULT NULL,
896: p_attribute17 per_all_people_f.attribute17%TYPE DEFAULT NULL,
897: p_attribute18 per_all_people_f.attribute18%TYPE DEFAULT NULL,
898: p_attribute19 per_all_people_f.attribute19%TYPE DEFAULT NULL,
899: p_attribute20 per_all_people_f.attribute20%TYPE DEFAULT NULL,
900: p_attribute21 per_all_people_f.attribute21%TYPE DEFAULT NULL,
901: p_attribute22 per_all_people_f.attribute22%TYPE DEFAULT NULL,
902: p_attribute23 per_all_people_f.attribute23%TYPE DEFAULT NULL,
903: p_attribute24 per_all_people_f.attribute24%TYPE DEFAULT NULL,

Line 900: p_attribute21 per_all_people_f.attribute21%TYPE DEFAULT NULL,

896: p_attribute17 per_all_people_f.attribute17%TYPE DEFAULT NULL,
897: p_attribute18 per_all_people_f.attribute18%TYPE DEFAULT NULL,
898: p_attribute19 per_all_people_f.attribute19%TYPE DEFAULT NULL,
899: p_attribute20 per_all_people_f.attribute20%TYPE DEFAULT NULL,
900: p_attribute21 per_all_people_f.attribute21%TYPE DEFAULT NULL,
901: p_attribute22 per_all_people_f.attribute22%TYPE DEFAULT NULL,
902: p_attribute23 per_all_people_f.attribute23%TYPE DEFAULT NULL,
903: p_attribute24 per_all_people_f.attribute24%TYPE DEFAULT NULL,
904: p_attribute25 per_all_people_f.attribute25%TYPE DEFAULT NULL,

Line 901: p_attribute22 per_all_people_f.attribute22%TYPE DEFAULT NULL,

897: p_attribute18 per_all_people_f.attribute18%TYPE DEFAULT NULL,
898: p_attribute19 per_all_people_f.attribute19%TYPE DEFAULT NULL,
899: p_attribute20 per_all_people_f.attribute20%TYPE DEFAULT NULL,
900: p_attribute21 per_all_people_f.attribute21%TYPE DEFAULT NULL,
901: p_attribute22 per_all_people_f.attribute22%TYPE DEFAULT NULL,
902: p_attribute23 per_all_people_f.attribute23%TYPE DEFAULT NULL,
903: p_attribute24 per_all_people_f.attribute24%TYPE DEFAULT NULL,
904: p_attribute25 per_all_people_f.attribute25%TYPE DEFAULT NULL,
905: p_attribute26 per_all_people_f.attribute26%TYPE DEFAULT NULL,

Line 902: p_attribute23 per_all_people_f.attribute23%TYPE DEFAULT NULL,

898: p_attribute19 per_all_people_f.attribute19%TYPE DEFAULT NULL,
899: p_attribute20 per_all_people_f.attribute20%TYPE DEFAULT NULL,
900: p_attribute21 per_all_people_f.attribute21%TYPE DEFAULT NULL,
901: p_attribute22 per_all_people_f.attribute22%TYPE DEFAULT NULL,
902: p_attribute23 per_all_people_f.attribute23%TYPE DEFAULT NULL,
903: p_attribute24 per_all_people_f.attribute24%TYPE DEFAULT NULL,
904: p_attribute25 per_all_people_f.attribute25%TYPE DEFAULT NULL,
905: p_attribute26 per_all_people_f.attribute26%TYPE DEFAULT NULL,
906: p_attribute27 per_all_people_f.attribute27%TYPE DEFAULT NULL,

Line 903: p_attribute24 per_all_people_f.attribute24%TYPE DEFAULT NULL,

899: p_attribute20 per_all_people_f.attribute20%TYPE DEFAULT NULL,
900: p_attribute21 per_all_people_f.attribute21%TYPE DEFAULT NULL,
901: p_attribute22 per_all_people_f.attribute22%TYPE DEFAULT NULL,
902: p_attribute23 per_all_people_f.attribute23%TYPE DEFAULT NULL,
903: p_attribute24 per_all_people_f.attribute24%TYPE DEFAULT NULL,
904: p_attribute25 per_all_people_f.attribute25%TYPE DEFAULT NULL,
905: p_attribute26 per_all_people_f.attribute26%TYPE DEFAULT NULL,
906: p_attribute27 per_all_people_f.attribute27%TYPE DEFAULT NULL,
907: p_attribute28 per_all_people_f.attribute28%TYPE DEFAULT NULL,

Line 904: p_attribute25 per_all_people_f.attribute25%TYPE DEFAULT NULL,

900: p_attribute21 per_all_people_f.attribute21%TYPE DEFAULT NULL,
901: p_attribute22 per_all_people_f.attribute22%TYPE DEFAULT NULL,
902: p_attribute23 per_all_people_f.attribute23%TYPE DEFAULT NULL,
903: p_attribute24 per_all_people_f.attribute24%TYPE DEFAULT NULL,
904: p_attribute25 per_all_people_f.attribute25%TYPE DEFAULT NULL,
905: p_attribute26 per_all_people_f.attribute26%TYPE DEFAULT NULL,
906: p_attribute27 per_all_people_f.attribute27%TYPE DEFAULT NULL,
907: p_attribute28 per_all_people_f.attribute28%TYPE DEFAULT NULL,
908: p_attribute29 per_all_people_f.attribute29%TYPE DEFAULT NULL,

Line 905: p_attribute26 per_all_people_f.attribute26%TYPE DEFAULT NULL,

901: p_attribute22 per_all_people_f.attribute22%TYPE DEFAULT NULL,
902: p_attribute23 per_all_people_f.attribute23%TYPE DEFAULT NULL,
903: p_attribute24 per_all_people_f.attribute24%TYPE DEFAULT NULL,
904: p_attribute25 per_all_people_f.attribute25%TYPE DEFAULT NULL,
905: p_attribute26 per_all_people_f.attribute26%TYPE DEFAULT NULL,
906: p_attribute27 per_all_people_f.attribute27%TYPE DEFAULT NULL,
907: p_attribute28 per_all_people_f.attribute28%TYPE DEFAULT NULL,
908: p_attribute29 per_all_people_f.attribute29%TYPE DEFAULT NULL,
909: p_attribute30 per_all_people_f.attribute30%TYPE DEFAULT NULL,

Line 906: p_attribute27 per_all_people_f.attribute27%TYPE DEFAULT NULL,

902: p_attribute23 per_all_people_f.attribute23%TYPE DEFAULT NULL,
903: p_attribute24 per_all_people_f.attribute24%TYPE DEFAULT NULL,
904: p_attribute25 per_all_people_f.attribute25%TYPE DEFAULT NULL,
905: p_attribute26 per_all_people_f.attribute26%TYPE DEFAULT NULL,
906: p_attribute27 per_all_people_f.attribute27%TYPE DEFAULT NULL,
907: p_attribute28 per_all_people_f.attribute28%TYPE DEFAULT NULL,
908: p_attribute29 per_all_people_f.attribute29%TYPE DEFAULT NULL,
909: p_attribute30 per_all_people_f.attribute30%TYPE DEFAULT NULL,
910: p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE ,

Line 907: p_attribute28 per_all_people_f.attribute28%TYPE DEFAULT NULL,

903: p_attribute24 per_all_people_f.attribute24%TYPE DEFAULT NULL,
904: p_attribute25 per_all_people_f.attribute25%TYPE DEFAULT NULL,
905: p_attribute26 per_all_people_f.attribute26%TYPE DEFAULT NULL,
906: p_attribute27 per_all_people_f.attribute27%TYPE DEFAULT NULL,
907: p_attribute28 per_all_people_f.attribute28%TYPE DEFAULT NULL,
908: p_attribute29 per_all_people_f.attribute29%TYPE DEFAULT NULL,
909: p_attribute30 per_all_people_f.attribute30%TYPE DEFAULT NULL,
910: p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE ,
911: p_order_name OUT NOCOPY per_all_people_f.order_name%TYPE,

Line 908: p_attribute29 per_all_people_f.attribute29%TYPE DEFAULT NULL,

904: p_attribute25 per_all_people_f.attribute25%TYPE DEFAULT NULL,
905: p_attribute26 per_all_people_f.attribute26%TYPE DEFAULT NULL,
906: p_attribute27 per_all_people_f.attribute27%TYPE DEFAULT NULL,
907: p_attribute28 per_all_people_f.attribute28%TYPE DEFAULT NULL,
908: p_attribute29 per_all_people_f.attribute29%TYPE DEFAULT NULL,
909: p_attribute30 per_all_people_f.attribute30%TYPE DEFAULT NULL,
910: p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE ,
911: p_order_name OUT NOCOPY per_all_people_f.order_name%TYPE,
912: p_global_name OUT NOCOPY per_all_people_f.global_name%TYPE,

Line 909: p_attribute30 per_all_people_f.attribute30%TYPE DEFAULT NULL,

905: p_attribute26 per_all_people_f.attribute26%TYPE DEFAULT NULL,
906: p_attribute27 per_all_people_f.attribute27%TYPE DEFAULT NULL,
907: p_attribute28 per_all_people_f.attribute28%TYPE DEFAULT NULL,
908: p_attribute29 per_all_people_f.attribute29%TYPE DEFAULT NULL,
909: p_attribute30 per_all_people_f.attribute30%TYPE DEFAULT NULL,
910: p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE ,
911: p_order_name OUT NOCOPY per_all_people_f.order_name%TYPE,
912: p_global_name OUT NOCOPY per_all_people_f.global_name%TYPE,
913: p_local_name OUT NOCOPY per_all_people_f.local_name%TYPE,

Line 910: p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE ,

906: p_attribute27 per_all_people_f.attribute27%TYPE DEFAULT NULL,
907: p_attribute28 per_all_people_f.attribute28%TYPE DEFAULT NULL,
908: p_attribute29 per_all_people_f.attribute29%TYPE DEFAULT NULL,
909: p_attribute30 per_all_people_f.attribute30%TYPE DEFAULT NULL,
910: p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE ,
911: p_order_name OUT NOCOPY per_all_people_f.order_name%TYPE,
912: p_global_name OUT NOCOPY per_all_people_f.global_name%TYPE,
913: p_local_name OUT NOCOPY per_all_people_f.local_name%TYPE,
914: p_duplicate_flag OUT NOCOPY VARCHAR2

Line 911: p_order_name OUT NOCOPY per_all_people_f.order_name%TYPE,

907: p_attribute28 per_all_people_f.attribute28%TYPE DEFAULT NULL,
908: p_attribute29 per_all_people_f.attribute29%TYPE DEFAULT NULL,
909: p_attribute30 per_all_people_f.attribute30%TYPE DEFAULT NULL,
910: p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE ,
911: p_order_name OUT NOCOPY per_all_people_f.order_name%TYPE,
912: p_global_name OUT NOCOPY per_all_people_f.global_name%TYPE,
913: p_local_name OUT NOCOPY per_all_people_f.local_name%TYPE,
914: p_duplicate_flag OUT NOCOPY VARCHAR2
915: ) is

Line 912: p_global_name OUT NOCOPY per_all_people_f.global_name%TYPE,

908: p_attribute29 per_all_people_f.attribute29%TYPE DEFAULT NULL,
909: p_attribute30 per_all_people_f.attribute30%TYPE DEFAULT NULL,
910: p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE ,
911: p_order_name OUT NOCOPY per_all_people_f.order_name%TYPE,
912: p_global_name OUT NOCOPY per_all_people_f.global_name%TYPE,
913: p_local_name OUT NOCOPY per_all_people_f.local_name%TYPE,
914: p_duplicate_flag OUT NOCOPY VARCHAR2
915: ) is
916: --

Line 913: p_local_name OUT NOCOPY per_all_people_f.local_name%TYPE,

909: p_attribute30 per_all_people_f.attribute30%TYPE DEFAULT NULL,
910: p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE ,
911: p_order_name OUT NOCOPY per_all_people_f.order_name%TYPE,
912: p_global_name OUT NOCOPY per_all_people_f.global_name%TYPE,
913: p_local_name OUT NOCOPY per_all_people_f.local_name%TYPE,
914: p_duplicate_flag OUT NOCOPY VARCHAR2
915: ) is
916: --
917: l_proc CONSTANT varchar2(80) := g_package||'get_derive_person_names';

Line 1267: FROM per_all_people_f pp

1263: SELECT 'Y'
1264: INTO l_status
1265: FROM sys.dual
1266: WHERE EXISTS (SELECT /*+ no_expand */ 'Duplicate Person Exists'
1267: FROM per_all_people_f pp
1268: WHERE /* Perform case insensitive check on last name */
1269: /* trying to use the index on last name */
1270: upper(pp.last_name) = upper(p_last_name)
1271: AND ( pp.last_name like l_ul_check

Line 1702: p_business_group_id per_all_people_f.business_group_id%TYPE,

1698: --
1699: --
1700: procedure derive_person_names
1701: (p_format_name hr_name_formats.format_name%TYPE,
1702: p_business_group_id per_all_people_f.business_group_id%TYPE,
1703: p_first_name per_all_people_f.first_name%TYPE,
1704: p_middle_names per_all_people_f.middle_names%TYPE,
1705: p_last_name per_all_people_f.last_name%TYPE,
1706: p_known_as per_all_people_f.known_as%TYPE,

Line 1703: p_first_name per_all_people_f.first_name%TYPE,

1699: --
1700: procedure derive_person_names
1701: (p_format_name hr_name_formats.format_name%TYPE,
1702: p_business_group_id per_all_people_f.business_group_id%TYPE,
1703: p_first_name per_all_people_f.first_name%TYPE,
1704: p_middle_names per_all_people_f.middle_names%TYPE,
1705: p_last_name per_all_people_f.last_name%TYPE,
1706: p_known_as per_all_people_f.known_as%TYPE,
1707: p_title per_all_people_f.title%TYPE,

Line 1704: p_middle_names per_all_people_f.middle_names%TYPE,

1700: procedure derive_person_names
1701: (p_format_name hr_name_formats.format_name%TYPE,
1702: p_business_group_id per_all_people_f.business_group_id%TYPE,
1703: p_first_name per_all_people_f.first_name%TYPE,
1704: p_middle_names per_all_people_f.middle_names%TYPE,
1705: p_last_name per_all_people_f.last_name%TYPE,
1706: p_known_as per_all_people_f.known_as%TYPE,
1707: p_title per_all_people_f.title%TYPE,
1708: p_suffix per_all_people_f.suffix%TYPE,

Line 1705: p_last_name per_all_people_f.last_name%TYPE,

1701: (p_format_name hr_name_formats.format_name%TYPE,
1702: p_business_group_id per_all_people_f.business_group_id%TYPE,
1703: p_first_name per_all_people_f.first_name%TYPE,
1704: p_middle_names per_all_people_f.middle_names%TYPE,
1705: p_last_name per_all_people_f.last_name%TYPE,
1706: p_known_as per_all_people_f.known_as%TYPE,
1707: p_title per_all_people_f.title%TYPE,
1708: p_suffix per_all_people_f.suffix%TYPE,
1709: p_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE,

Line 1706: p_known_as per_all_people_f.known_as%TYPE,

1702: p_business_group_id per_all_people_f.business_group_id%TYPE,
1703: p_first_name per_all_people_f.first_name%TYPE,
1704: p_middle_names per_all_people_f.middle_names%TYPE,
1705: p_last_name per_all_people_f.last_name%TYPE,
1706: p_known_as per_all_people_f.known_as%TYPE,
1707: p_title per_all_people_f.title%TYPE,
1708: p_suffix per_all_people_f.suffix%TYPE,
1709: p_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE,
1710: p_date_of_birth per_all_people_f.date_of_birth%TYPE,

Line 1707: p_title per_all_people_f.title%TYPE,

1703: p_first_name per_all_people_f.first_name%TYPE,
1704: p_middle_names per_all_people_f.middle_names%TYPE,
1705: p_last_name per_all_people_f.last_name%TYPE,
1706: p_known_as per_all_people_f.known_as%TYPE,
1707: p_title per_all_people_f.title%TYPE,
1708: p_suffix per_all_people_f.suffix%TYPE,
1709: p_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE,
1710: p_date_of_birth per_all_people_f.date_of_birth%TYPE,
1711: p_previous_last_name per_all_people_f.previous_last_name%TYPE DEFAULT NULL,

Line 1708: p_suffix per_all_people_f.suffix%TYPE,

1704: p_middle_names per_all_people_f.middle_names%TYPE,
1705: p_last_name per_all_people_f.last_name%TYPE,
1706: p_known_as per_all_people_f.known_as%TYPE,
1707: p_title per_all_people_f.title%TYPE,
1708: p_suffix per_all_people_f.suffix%TYPE,
1709: p_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE,
1710: p_date_of_birth per_all_people_f.date_of_birth%TYPE,
1711: p_previous_last_name per_all_people_f.previous_last_name%TYPE DEFAULT NULL,
1712: p_email_address per_all_people_f.email_address%TYPE DEFAULT NULL,

Line 1709: p_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE,

1705: p_last_name per_all_people_f.last_name%TYPE,
1706: p_known_as per_all_people_f.known_as%TYPE,
1707: p_title per_all_people_f.title%TYPE,
1708: p_suffix per_all_people_f.suffix%TYPE,
1709: p_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE,
1710: p_date_of_birth per_all_people_f.date_of_birth%TYPE,
1711: p_previous_last_name per_all_people_f.previous_last_name%TYPE DEFAULT NULL,
1712: p_email_address per_all_people_f.email_address%TYPE DEFAULT NULL,
1713: p_employee_number per_all_people_f.employee_number%TYPE DEFAULT NULL,

Line 1710: p_date_of_birth per_all_people_f.date_of_birth%TYPE,

1706: p_known_as per_all_people_f.known_as%TYPE,
1707: p_title per_all_people_f.title%TYPE,
1708: p_suffix per_all_people_f.suffix%TYPE,
1709: p_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE,
1710: p_date_of_birth per_all_people_f.date_of_birth%TYPE,
1711: p_previous_last_name per_all_people_f.previous_last_name%TYPE DEFAULT NULL,
1712: p_email_address per_all_people_f.email_address%TYPE DEFAULT NULL,
1713: p_employee_number per_all_people_f.employee_number%TYPE DEFAULT NULL,
1714: p_applicant_number per_all_people_f.applicant_number%TYPE DEFAULT NULL,

Line 1711: p_previous_last_name per_all_people_f.previous_last_name%TYPE DEFAULT NULL,

1707: p_title per_all_people_f.title%TYPE,
1708: p_suffix per_all_people_f.suffix%TYPE,
1709: p_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE,
1710: p_date_of_birth per_all_people_f.date_of_birth%TYPE,
1711: p_previous_last_name per_all_people_f.previous_last_name%TYPE DEFAULT NULL,
1712: p_email_address per_all_people_f.email_address%TYPE DEFAULT NULL,
1713: p_employee_number per_all_people_f.employee_number%TYPE DEFAULT NULL,
1714: p_applicant_number per_all_people_f.applicant_number%TYPE DEFAULT NULL,
1715: p_npw_number per_all_people_f.npw_number%TYPE DEFAULT NULL,

Line 1712: p_email_address per_all_people_f.email_address%TYPE DEFAULT NULL,

1708: p_suffix per_all_people_f.suffix%TYPE,
1709: p_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE,
1710: p_date_of_birth per_all_people_f.date_of_birth%TYPE,
1711: p_previous_last_name per_all_people_f.previous_last_name%TYPE DEFAULT NULL,
1712: p_email_address per_all_people_f.email_address%TYPE DEFAULT NULL,
1713: p_employee_number per_all_people_f.employee_number%TYPE DEFAULT NULL,
1714: p_applicant_number per_all_people_f.applicant_number%TYPE DEFAULT NULL,
1715: p_npw_number per_all_people_f.npw_number%TYPE DEFAULT NULL,
1716: p_per_information1 per_all_people_f.per_information1%TYPE DEFAULT NULL,

Line 1713: p_employee_number per_all_people_f.employee_number%TYPE DEFAULT NULL,

1709: p_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE,
1710: p_date_of_birth per_all_people_f.date_of_birth%TYPE,
1711: p_previous_last_name per_all_people_f.previous_last_name%TYPE DEFAULT NULL,
1712: p_email_address per_all_people_f.email_address%TYPE DEFAULT NULL,
1713: p_employee_number per_all_people_f.employee_number%TYPE DEFAULT NULL,
1714: p_applicant_number per_all_people_f.applicant_number%TYPE DEFAULT NULL,
1715: p_npw_number per_all_people_f.npw_number%TYPE DEFAULT NULL,
1716: p_per_information1 per_all_people_f.per_information1%TYPE DEFAULT NULL,
1717: p_per_information2 per_all_people_f.per_information2%TYPE DEFAULT NULL,

Line 1714: p_applicant_number per_all_people_f.applicant_number%TYPE DEFAULT NULL,

1710: p_date_of_birth per_all_people_f.date_of_birth%TYPE,
1711: p_previous_last_name per_all_people_f.previous_last_name%TYPE DEFAULT NULL,
1712: p_email_address per_all_people_f.email_address%TYPE DEFAULT NULL,
1713: p_employee_number per_all_people_f.employee_number%TYPE DEFAULT NULL,
1714: p_applicant_number per_all_people_f.applicant_number%TYPE DEFAULT NULL,
1715: p_npw_number per_all_people_f.npw_number%TYPE DEFAULT NULL,
1716: p_per_information1 per_all_people_f.per_information1%TYPE DEFAULT NULL,
1717: p_per_information2 per_all_people_f.per_information2%TYPE DEFAULT NULL,
1718: p_per_information3 per_all_people_f.per_information3%TYPE DEFAULT NULL,

Line 1715: p_npw_number per_all_people_f.npw_number%TYPE DEFAULT NULL,

1711: p_previous_last_name per_all_people_f.previous_last_name%TYPE DEFAULT NULL,
1712: p_email_address per_all_people_f.email_address%TYPE DEFAULT NULL,
1713: p_employee_number per_all_people_f.employee_number%TYPE DEFAULT NULL,
1714: p_applicant_number per_all_people_f.applicant_number%TYPE DEFAULT NULL,
1715: p_npw_number per_all_people_f.npw_number%TYPE DEFAULT NULL,
1716: p_per_information1 per_all_people_f.per_information1%TYPE DEFAULT NULL,
1717: p_per_information2 per_all_people_f.per_information2%TYPE DEFAULT NULL,
1718: p_per_information3 per_all_people_f.per_information3%TYPE DEFAULT NULL,
1719: p_per_information4 per_all_people_f.per_information4%TYPE DEFAULT NULL,

Line 1716: p_per_information1 per_all_people_f.per_information1%TYPE DEFAULT NULL,

1712: p_email_address per_all_people_f.email_address%TYPE DEFAULT NULL,
1713: p_employee_number per_all_people_f.employee_number%TYPE DEFAULT NULL,
1714: p_applicant_number per_all_people_f.applicant_number%TYPE DEFAULT NULL,
1715: p_npw_number per_all_people_f.npw_number%TYPE DEFAULT NULL,
1716: p_per_information1 per_all_people_f.per_information1%TYPE DEFAULT NULL,
1717: p_per_information2 per_all_people_f.per_information2%TYPE DEFAULT NULL,
1718: p_per_information3 per_all_people_f.per_information3%TYPE DEFAULT NULL,
1719: p_per_information4 per_all_people_f.per_information4%TYPE DEFAULT NULL,
1720: p_per_information5 per_all_people_f.per_information5%TYPE DEFAULT NULL,

Line 1717: p_per_information2 per_all_people_f.per_information2%TYPE DEFAULT NULL,

1713: p_employee_number per_all_people_f.employee_number%TYPE DEFAULT NULL,
1714: p_applicant_number per_all_people_f.applicant_number%TYPE DEFAULT NULL,
1715: p_npw_number per_all_people_f.npw_number%TYPE DEFAULT NULL,
1716: p_per_information1 per_all_people_f.per_information1%TYPE DEFAULT NULL,
1717: p_per_information2 per_all_people_f.per_information2%TYPE DEFAULT NULL,
1718: p_per_information3 per_all_people_f.per_information3%TYPE DEFAULT NULL,
1719: p_per_information4 per_all_people_f.per_information4%TYPE DEFAULT NULL,
1720: p_per_information5 per_all_people_f.per_information5%TYPE DEFAULT NULL,
1721: p_per_information6 per_all_people_f.per_information6%TYPE DEFAULT NULL,

Line 1718: p_per_information3 per_all_people_f.per_information3%TYPE DEFAULT NULL,

1714: p_applicant_number per_all_people_f.applicant_number%TYPE DEFAULT NULL,
1715: p_npw_number per_all_people_f.npw_number%TYPE DEFAULT NULL,
1716: p_per_information1 per_all_people_f.per_information1%TYPE DEFAULT NULL,
1717: p_per_information2 per_all_people_f.per_information2%TYPE DEFAULT NULL,
1718: p_per_information3 per_all_people_f.per_information3%TYPE DEFAULT NULL,
1719: p_per_information4 per_all_people_f.per_information4%TYPE DEFAULT NULL,
1720: p_per_information5 per_all_people_f.per_information5%TYPE DEFAULT NULL,
1721: p_per_information6 per_all_people_f.per_information6%TYPE DEFAULT NULL,
1722: p_per_information7 per_all_people_f.per_information7%TYPE DEFAULT NULL,

Line 1719: p_per_information4 per_all_people_f.per_information4%TYPE DEFAULT NULL,

1715: p_npw_number per_all_people_f.npw_number%TYPE DEFAULT NULL,
1716: p_per_information1 per_all_people_f.per_information1%TYPE DEFAULT NULL,
1717: p_per_information2 per_all_people_f.per_information2%TYPE DEFAULT NULL,
1718: p_per_information3 per_all_people_f.per_information3%TYPE DEFAULT NULL,
1719: p_per_information4 per_all_people_f.per_information4%TYPE DEFAULT NULL,
1720: p_per_information5 per_all_people_f.per_information5%TYPE DEFAULT NULL,
1721: p_per_information6 per_all_people_f.per_information6%TYPE DEFAULT NULL,
1722: p_per_information7 per_all_people_f.per_information7%TYPE DEFAULT NULL,
1723: p_per_information8 per_all_people_f.per_information8%TYPE DEFAULT NULL,

Line 1720: p_per_information5 per_all_people_f.per_information5%TYPE DEFAULT NULL,

1716: p_per_information1 per_all_people_f.per_information1%TYPE DEFAULT NULL,
1717: p_per_information2 per_all_people_f.per_information2%TYPE DEFAULT NULL,
1718: p_per_information3 per_all_people_f.per_information3%TYPE DEFAULT NULL,
1719: p_per_information4 per_all_people_f.per_information4%TYPE DEFAULT NULL,
1720: p_per_information5 per_all_people_f.per_information5%TYPE DEFAULT NULL,
1721: p_per_information6 per_all_people_f.per_information6%TYPE DEFAULT NULL,
1722: p_per_information7 per_all_people_f.per_information7%TYPE DEFAULT NULL,
1723: p_per_information8 per_all_people_f.per_information8%TYPE DEFAULT NULL,
1724: p_per_information9 per_all_people_f.per_information9%TYPE DEFAULT NULL,

Line 1721: p_per_information6 per_all_people_f.per_information6%TYPE DEFAULT NULL,

1717: p_per_information2 per_all_people_f.per_information2%TYPE DEFAULT NULL,
1718: p_per_information3 per_all_people_f.per_information3%TYPE DEFAULT NULL,
1719: p_per_information4 per_all_people_f.per_information4%TYPE DEFAULT NULL,
1720: p_per_information5 per_all_people_f.per_information5%TYPE DEFAULT NULL,
1721: p_per_information6 per_all_people_f.per_information6%TYPE DEFAULT NULL,
1722: p_per_information7 per_all_people_f.per_information7%TYPE DEFAULT NULL,
1723: p_per_information8 per_all_people_f.per_information8%TYPE DEFAULT NULL,
1724: p_per_information9 per_all_people_f.per_information9%TYPE DEFAULT NULL,
1725: p_per_information10 per_all_people_f.per_information10%TYPE DEFAULT NULL,

Line 1722: p_per_information7 per_all_people_f.per_information7%TYPE DEFAULT NULL,

1718: p_per_information3 per_all_people_f.per_information3%TYPE DEFAULT NULL,
1719: p_per_information4 per_all_people_f.per_information4%TYPE DEFAULT NULL,
1720: p_per_information5 per_all_people_f.per_information5%TYPE DEFAULT NULL,
1721: p_per_information6 per_all_people_f.per_information6%TYPE DEFAULT NULL,
1722: p_per_information7 per_all_people_f.per_information7%TYPE DEFAULT NULL,
1723: p_per_information8 per_all_people_f.per_information8%TYPE DEFAULT NULL,
1724: p_per_information9 per_all_people_f.per_information9%TYPE DEFAULT NULL,
1725: p_per_information10 per_all_people_f.per_information10%TYPE DEFAULT NULL,
1726: p_per_information11 per_all_people_f.per_information11%TYPE DEFAULT NULL,

Line 1723: p_per_information8 per_all_people_f.per_information8%TYPE DEFAULT NULL,

1719: p_per_information4 per_all_people_f.per_information4%TYPE DEFAULT NULL,
1720: p_per_information5 per_all_people_f.per_information5%TYPE DEFAULT NULL,
1721: p_per_information6 per_all_people_f.per_information6%TYPE DEFAULT NULL,
1722: p_per_information7 per_all_people_f.per_information7%TYPE DEFAULT NULL,
1723: p_per_information8 per_all_people_f.per_information8%TYPE DEFAULT NULL,
1724: p_per_information9 per_all_people_f.per_information9%TYPE DEFAULT NULL,
1725: p_per_information10 per_all_people_f.per_information10%TYPE DEFAULT NULL,
1726: p_per_information11 per_all_people_f.per_information11%TYPE DEFAULT NULL,
1727: p_per_information12 per_all_people_f.per_information12%TYPE DEFAULT NULL,

Line 1724: p_per_information9 per_all_people_f.per_information9%TYPE DEFAULT NULL,

1720: p_per_information5 per_all_people_f.per_information5%TYPE DEFAULT NULL,
1721: p_per_information6 per_all_people_f.per_information6%TYPE DEFAULT NULL,
1722: p_per_information7 per_all_people_f.per_information7%TYPE DEFAULT NULL,
1723: p_per_information8 per_all_people_f.per_information8%TYPE DEFAULT NULL,
1724: p_per_information9 per_all_people_f.per_information9%TYPE DEFAULT NULL,
1725: p_per_information10 per_all_people_f.per_information10%TYPE DEFAULT NULL,
1726: p_per_information11 per_all_people_f.per_information11%TYPE DEFAULT NULL,
1727: p_per_information12 per_all_people_f.per_information12%TYPE DEFAULT NULL,
1728: p_per_information13 per_all_people_f.per_information13%TYPE DEFAULT NULL,

Line 1725: p_per_information10 per_all_people_f.per_information10%TYPE DEFAULT NULL,

1721: p_per_information6 per_all_people_f.per_information6%TYPE DEFAULT NULL,
1722: p_per_information7 per_all_people_f.per_information7%TYPE DEFAULT NULL,
1723: p_per_information8 per_all_people_f.per_information8%TYPE DEFAULT NULL,
1724: p_per_information9 per_all_people_f.per_information9%TYPE DEFAULT NULL,
1725: p_per_information10 per_all_people_f.per_information10%TYPE DEFAULT NULL,
1726: p_per_information11 per_all_people_f.per_information11%TYPE DEFAULT NULL,
1727: p_per_information12 per_all_people_f.per_information12%TYPE DEFAULT NULL,
1728: p_per_information13 per_all_people_f.per_information13%TYPE DEFAULT NULL,
1729: p_per_information14 per_all_people_f.per_information14%TYPE DEFAULT NULL,

Line 1726: p_per_information11 per_all_people_f.per_information11%TYPE DEFAULT NULL,

1722: p_per_information7 per_all_people_f.per_information7%TYPE DEFAULT NULL,
1723: p_per_information8 per_all_people_f.per_information8%TYPE DEFAULT NULL,
1724: p_per_information9 per_all_people_f.per_information9%TYPE DEFAULT NULL,
1725: p_per_information10 per_all_people_f.per_information10%TYPE DEFAULT NULL,
1726: p_per_information11 per_all_people_f.per_information11%TYPE DEFAULT NULL,
1727: p_per_information12 per_all_people_f.per_information12%TYPE DEFAULT NULL,
1728: p_per_information13 per_all_people_f.per_information13%TYPE DEFAULT NULL,
1729: p_per_information14 per_all_people_f.per_information14%TYPE DEFAULT NULL,
1730: p_per_information15 per_all_people_f.per_information15%TYPE DEFAULT NULL,

Line 1727: p_per_information12 per_all_people_f.per_information12%TYPE DEFAULT NULL,

1723: p_per_information8 per_all_people_f.per_information8%TYPE DEFAULT NULL,
1724: p_per_information9 per_all_people_f.per_information9%TYPE DEFAULT NULL,
1725: p_per_information10 per_all_people_f.per_information10%TYPE DEFAULT NULL,
1726: p_per_information11 per_all_people_f.per_information11%TYPE DEFAULT NULL,
1727: p_per_information12 per_all_people_f.per_information12%TYPE DEFAULT NULL,
1728: p_per_information13 per_all_people_f.per_information13%TYPE DEFAULT NULL,
1729: p_per_information14 per_all_people_f.per_information14%TYPE DEFAULT NULL,
1730: p_per_information15 per_all_people_f.per_information15%TYPE DEFAULT NULL,
1731: p_per_information16 per_all_people_f.per_information16%TYPE DEFAULT NULL,

Line 1728: p_per_information13 per_all_people_f.per_information13%TYPE DEFAULT NULL,

1724: p_per_information9 per_all_people_f.per_information9%TYPE DEFAULT NULL,
1725: p_per_information10 per_all_people_f.per_information10%TYPE DEFAULT NULL,
1726: p_per_information11 per_all_people_f.per_information11%TYPE DEFAULT NULL,
1727: p_per_information12 per_all_people_f.per_information12%TYPE DEFAULT NULL,
1728: p_per_information13 per_all_people_f.per_information13%TYPE DEFAULT NULL,
1729: p_per_information14 per_all_people_f.per_information14%TYPE DEFAULT NULL,
1730: p_per_information15 per_all_people_f.per_information15%TYPE DEFAULT NULL,
1731: p_per_information16 per_all_people_f.per_information16%TYPE DEFAULT NULL,
1732: p_per_information17 per_all_people_f.per_information17%TYPE DEFAULT NULL,

Line 1729: p_per_information14 per_all_people_f.per_information14%TYPE DEFAULT NULL,

1725: p_per_information10 per_all_people_f.per_information10%TYPE DEFAULT NULL,
1726: p_per_information11 per_all_people_f.per_information11%TYPE DEFAULT NULL,
1727: p_per_information12 per_all_people_f.per_information12%TYPE DEFAULT NULL,
1728: p_per_information13 per_all_people_f.per_information13%TYPE DEFAULT NULL,
1729: p_per_information14 per_all_people_f.per_information14%TYPE DEFAULT NULL,
1730: p_per_information15 per_all_people_f.per_information15%TYPE DEFAULT NULL,
1731: p_per_information16 per_all_people_f.per_information16%TYPE DEFAULT NULL,
1732: p_per_information17 per_all_people_f.per_information17%TYPE DEFAULT NULL,
1733: p_per_information18 per_all_people_f.per_information18%TYPE DEFAULT NULL,

Line 1730: p_per_information15 per_all_people_f.per_information15%TYPE DEFAULT NULL,

1726: p_per_information11 per_all_people_f.per_information11%TYPE DEFAULT NULL,
1727: p_per_information12 per_all_people_f.per_information12%TYPE DEFAULT NULL,
1728: p_per_information13 per_all_people_f.per_information13%TYPE DEFAULT NULL,
1729: p_per_information14 per_all_people_f.per_information14%TYPE DEFAULT NULL,
1730: p_per_information15 per_all_people_f.per_information15%TYPE DEFAULT NULL,
1731: p_per_information16 per_all_people_f.per_information16%TYPE DEFAULT NULL,
1732: p_per_information17 per_all_people_f.per_information17%TYPE DEFAULT NULL,
1733: p_per_information18 per_all_people_f.per_information18%TYPE DEFAULT NULL,
1734: p_per_information19 per_all_people_f.per_information19%TYPE DEFAULT NULL,

Line 1731: p_per_information16 per_all_people_f.per_information16%TYPE DEFAULT NULL,

1727: p_per_information12 per_all_people_f.per_information12%TYPE DEFAULT NULL,
1728: p_per_information13 per_all_people_f.per_information13%TYPE DEFAULT NULL,
1729: p_per_information14 per_all_people_f.per_information14%TYPE DEFAULT NULL,
1730: p_per_information15 per_all_people_f.per_information15%TYPE DEFAULT NULL,
1731: p_per_information16 per_all_people_f.per_information16%TYPE DEFAULT NULL,
1732: p_per_information17 per_all_people_f.per_information17%TYPE DEFAULT NULL,
1733: p_per_information18 per_all_people_f.per_information18%TYPE DEFAULT NULL,
1734: p_per_information19 per_all_people_f.per_information19%TYPE DEFAULT NULL,
1735: p_per_information20 per_all_people_f.per_information20%TYPE DEFAULT NULL,

Line 1732: p_per_information17 per_all_people_f.per_information17%TYPE DEFAULT NULL,

1728: p_per_information13 per_all_people_f.per_information13%TYPE DEFAULT NULL,
1729: p_per_information14 per_all_people_f.per_information14%TYPE DEFAULT NULL,
1730: p_per_information15 per_all_people_f.per_information15%TYPE DEFAULT NULL,
1731: p_per_information16 per_all_people_f.per_information16%TYPE DEFAULT NULL,
1732: p_per_information17 per_all_people_f.per_information17%TYPE DEFAULT NULL,
1733: p_per_information18 per_all_people_f.per_information18%TYPE DEFAULT NULL,
1734: p_per_information19 per_all_people_f.per_information19%TYPE DEFAULT NULL,
1735: p_per_information20 per_all_people_f.per_information20%TYPE DEFAULT NULL,
1736: p_per_information21 per_all_people_f.per_information21%TYPE DEFAULT NULL,

Line 1733: p_per_information18 per_all_people_f.per_information18%TYPE DEFAULT NULL,

1729: p_per_information14 per_all_people_f.per_information14%TYPE DEFAULT NULL,
1730: p_per_information15 per_all_people_f.per_information15%TYPE DEFAULT NULL,
1731: p_per_information16 per_all_people_f.per_information16%TYPE DEFAULT NULL,
1732: p_per_information17 per_all_people_f.per_information17%TYPE DEFAULT NULL,
1733: p_per_information18 per_all_people_f.per_information18%TYPE DEFAULT NULL,
1734: p_per_information19 per_all_people_f.per_information19%TYPE DEFAULT NULL,
1735: p_per_information20 per_all_people_f.per_information20%TYPE DEFAULT NULL,
1736: p_per_information21 per_all_people_f.per_information21%TYPE DEFAULT NULL,
1737: p_per_information22 per_all_people_f.per_information22%TYPE DEFAULT NULL,

Line 1734: p_per_information19 per_all_people_f.per_information19%TYPE DEFAULT NULL,

1730: p_per_information15 per_all_people_f.per_information15%TYPE DEFAULT NULL,
1731: p_per_information16 per_all_people_f.per_information16%TYPE DEFAULT NULL,
1732: p_per_information17 per_all_people_f.per_information17%TYPE DEFAULT NULL,
1733: p_per_information18 per_all_people_f.per_information18%TYPE DEFAULT NULL,
1734: p_per_information19 per_all_people_f.per_information19%TYPE DEFAULT NULL,
1735: p_per_information20 per_all_people_f.per_information20%TYPE DEFAULT NULL,
1736: p_per_information21 per_all_people_f.per_information21%TYPE DEFAULT NULL,
1737: p_per_information22 per_all_people_f.per_information22%TYPE DEFAULT NULL,
1738: p_per_information23 per_all_people_f.per_information23%TYPE DEFAULT NULL,

Line 1735: p_per_information20 per_all_people_f.per_information20%TYPE DEFAULT NULL,

1731: p_per_information16 per_all_people_f.per_information16%TYPE DEFAULT NULL,
1732: p_per_information17 per_all_people_f.per_information17%TYPE DEFAULT NULL,
1733: p_per_information18 per_all_people_f.per_information18%TYPE DEFAULT NULL,
1734: p_per_information19 per_all_people_f.per_information19%TYPE DEFAULT NULL,
1735: p_per_information20 per_all_people_f.per_information20%TYPE DEFAULT NULL,
1736: p_per_information21 per_all_people_f.per_information21%TYPE DEFAULT NULL,
1737: p_per_information22 per_all_people_f.per_information22%TYPE DEFAULT NULL,
1738: p_per_information23 per_all_people_f.per_information23%TYPE DEFAULT NULL,
1739: p_per_information24 per_all_people_f.per_information24%TYPE DEFAULT NULL,

Line 1736: p_per_information21 per_all_people_f.per_information21%TYPE DEFAULT NULL,

1732: p_per_information17 per_all_people_f.per_information17%TYPE DEFAULT NULL,
1733: p_per_information18 per_all_people_f.per_information18%TYPE DEFAULT NULL,
1734: p_per_information19 per_all_people_f.per_information19%TYPE DEFAULT NULL,
1735: p_per_information20 per_all_people_f.per_information20%TYPE DEFAULT NULL,
1736: p_per_information21 per_all_people_f.per_information21%TYPE DEFAULT NULL,
1737: p_per_information22 per_all_people_f.per_information22%TYPE DEFAULT NULL,
1738: p_per_information23 per_all_people_f.per_information23%TYPE DEFAULT NULL,
1739: p_per_information24 per_all_people_f.per_information24%TYPE DEFAULT NULL,
1740: p_per_information25 per_all_people_f.per_information25%TYPE DEFAULT NULL,

Line 1737: p_per_information22 per_all_people_f.per_information22%TYPE DEFAULT NULL,

1733: p_per_information18 per_all_people_f.per_information18%TYPE DEFAULT NULL,
1734: p_per_information19 per_all_people_f.per_information19%TYPE DEFAULT NULL,
1735: p_per_information20 per_all_people_f.per_information20%TYPE DEFAULT NULL,
1736: p_per_information21 per_all_people_f.per_information21%TYPE DEFAULT NULL,
1737: p_per_information22 per_all_people_f.per_information22%TYPE DEFAULT NULL,
1738: p_per_information23 per_all_people_f.per_information23%TYPE DEFAULT NULL,
1739: p_per_information24 per_all_people_f.per_information24%TYPE DEFAULT NULL,
1740: p_per_information25 per_all_people_f.per_information25%TYPE DEFAULT NULL,
1741: p_per_information26 per_all_people_f.per_information26%TYPE DEFAULT NULL,

Line 1738: p_per_information23 per_all_people_f.per_information23%TYPE DEFAULT NULL,

1734: p_per_information19 per_all_people_f.per_information19%TYPE DEFAULT NULL,
1735: p_per_information20 per_all_people_f.per_information20%TYPE DEFAULT NULL,
1736: p_per_information21 per_all_people_f.per_information21%TYPE DEFAULT NULL,
1737: p_per_information22 per_all_people_f.per_information22%TYPE DEFAULT NULL,
1738: p_per_information23 per_all_people_f.per_information23%TYPE DEFAULT NULL,
1739: p_per_information24 per_all_people_f.per_information24%TYPE DEFAULT NULL,
1740: p_per_information25 per_all_people_f.per_information25%TYPE DEFAULT NULL,
1741: p_per_information26 per_all_people_f.per_information26%TYPE DEFAULT NULL,
1742: p_per_information27 per_all_people_f.per_information27%TYPE DEFAULT NULL,

Line 1739: p_per_information24 per_all_people_f.per_information24%TYPE DEFAULT NULL,

1735: p_per_information20 per_all_people_f.per_information20%TYPE DEFAULT NULL,
1736: p_per_information21 per_all_people_f.per_information21%TYPE DEFAULT NULL,
1737: p_per_information22 per_all_people_f.per_information22%TYPE DEFAULT NULL,
1738: p_per_information23 per_all_people_f.per_information23%TYPE DEFAULT NULL,
1739: p_per_information24 per_all_people_f.per_information24%TYPE DEFAULT NULL,
1740: p_per_information25 per_all_people_f.per_information25%TYPE DEFAULT NULL,
1741: p_per_information26 per_all_people_f.per_information26%TYPE DEFAULT NULL,
1742: p_per_information27 per_all_people_f.per_information27%TYPE DEFAULT NULL,
1743: p_per_information28 per_all_people_f.per_information28%TYPE DEFAULT NULL,

Line 1740: p_per_information25 per_all_people_f.per_information25%TYPE DEFAULT NULL,

1736: p_per_information21 per_all_people_f.per_information21%TYPE DEFAULT NULL,
1737: p_per_information22 per_all_people_f.per_information22%TYPE DEFAULT NULL,
1738: p_per_information23 per_all_people_f.per_information23%TYPE DEFAULT NULL,
1739: p_per_information24 per_all_people_f.per_information24%TYPE DEFAULT NULL,
1740: p_per_information25 per_all_people_f.per_information25%TYPE DEFAULT NULL,
1741: p_per_information26 per_all_people_f.per_information26%TYPE DEFAULT NULL,
1742: p_per_information27 per_all_people_f.per_information27%TYPE DEFAULT NULL,
1743: p_per_information28 per_all_people_f.per_information28%TYPE DEFAULT NULL,
1744: p_per_information29 per_all_people_f.per_information29%TYPE DEFAULT NULL,

Line 1741: p_per_information26 per_all_people_f.per_information26%TYPE DEFAULT NULL,

1737: p_per_information22 per_all_people_f.per_information22%TYPE DEFAULT NULL,
1738: p_per_information23 per_all_people_f.per_information23%TYPE DEFAULT NULL,
1739: p_per_information24 per_all_people_f.per_information24%TYPE DEFAULT NULL,
1740: p_per_information25 per_all_people_f.per_information25%TYPE DEFAULT NULL,
1741: p_per_information26 per_all_people_f.per_information26%TYPE DEFAULT NULL,
1742: p_per_information27 per_all_people_f.per_information27%TYPE DEFAULT NULL,
1743: p_per_information28 per_all_people_f.per_information28%TYPE DEFAULT NULL,
1744: p_per_information29 per_all_people_f.per_information29%TYPE DEFAULT NULL,
1745: p_per_information30 per_all_people_f.per_information30%TYPE DEFAULT NULL,

Line 1742: p_per_information27 per_all_people_f.per_information27%TYPE DEFAULT NULL,

1738: p_per_information23 per_all_people_f.per_information23%TYPE DEFAULT NULL,
1739: p_per_information24 per_all_people_f.per_information24%TYPE DEFAULT NULL,
1740: p_per_information25 per_all_people_f.per_information25%TYPE DEFAULT NULL,
1741: p_per_information26 per_all_people_f.per_information26%TYPE DEFAULT NULL,
1742: p_per_information27 per_all_people_f.per_information27%TYPE DEFAULT NULL,
1743: p_per_information28 per_all_people_f.per_information28%TYPE DEFAULT NULL,
1744: p_per_information29 per_all_people_f.per_information29%TYPE DEFAULT NULL,
1745: p_per_information30 per_all_people_f.per_information30%TYPE DEFAULT NULL,
1746: p_attribute1 per_all_people_f.attribute1%TYPE DEFAULT NULL,

Line 1743: p_per_information28 per_all_people_f.per_information28%TYPE DEFAULT NULL,

1739: p_per_information24 per_all_people_f.per_information24%TYPE DEFAULT NULL,
1740: p_per_information25 per_all_people_f.per_information25%TYPE DEFAULT NULL,
1741: p_per_information26 per_all_people_f.per_information26%TYPE DEFAULT NULL,
1742: p_per_information27 per_all_people_f.per_information27%TYPE DEFAULT NULL,
1743: p_per_information28 per_all_people_f.per_information28%TYPE DEFAULT NULL,
1744: p_per_information29 per_all_people_f.per_information29%TYPE DEFAULT NULL,
1745: p_per_information30 per_all_people_f.per_information30%TYPE DEFAULT NULL,
1746: p_attribute1 per_all_people_f.attribute1%TYPE DEFAULT NULL,
1747: p_attribute2 per_all_people_f.attribute2%TYPE DEFAULT NULL,

Line 1744: p_per_information29 per_all_people_f.per_information29%TYPE DEFAULT NULL,

1740: p_per_information25 per_all_people_f.per_information25%TYPE DEFAULT NULL,
1741: p_per_information26 per_all_people_f.per_information26%TYPE DEFAULT NULL,
1742: p_per_information27 per_all_people_f.per_information27%TYPE DEFAULT NULL,
1743: p_per_information28 per_all_people_f.per_information28%TYPE DEFAULT NULL,
1744: p_per_information29 per_all_people_f.per_information29%TYPE DEFAULT NULL,
1745: p_per_information30 per_all_people_f.per_information30%TYPE DEFAULT NULL,
1746: p_attribute1 per_all_people_f.attribute1%TYPE DEFAULT NULL,
1747: p_attribute2 per_all_people_f.attribute2%TYPE DEFAULT NULL,
1748: p_attribute3 per_all_people_f.attribute3%TYPE DEFAULT NULL,

Line 1745: p_per_information30 per_all_people_f.per_information30%TYPE DEFAULT NULL,

1741: p_per_information26 per_all_people_f.per_information26%TYPE DEFAULT NULL,
1742: p_per_information27 per_all_people_f.per_information27%TYPE DEFAULT NULL,
1743: p_per_information28 per_all_people_f.per_information28%TYPE DEFAULT NULL,
1744: p_per_information29 per_all_people_f.per_information29%TYPE DEFAULT NULL,
1745: p_per_information30 per_all_people_f.per_information30%TYPE DEFAULT NULL,
1746: p_attribute1 per_all_people_f.attribute1%TYPE DEFAULT NULL,
1747: p_attribute2 per_all_people_f.attribute2%TYPE DEFAULT NULL,
1748: p_attribute3 per_all_people_f.attribute3%TYPE DEFAULT NULL,
1749: p_attribute4 per_all_people_f.attribute4%TYPE DEFAULT NULL,

Line 1746: p_attribute1 per_all_people_f.attribute1%TYPE DEFAULT NULL,

1742: p_per_information27 per_all_people_f.per_information27%TYPE DEFAULT NULL,
1743: p_per_information28 per_all_people_f.per_information28%TYPE DEFAULT NULL,
1744: p_per_information29 per_all_people_f.per_information29%TYPE DEFAULT NULL,
1745: p_per_information30 per_all_people_f.per_information30%TYPE DEFAULT NULL,
1746: p_attribute1 per_all_people_f.attribute1%TYPE DEFAULT NULL,
1747: p_attribute2 per_all_people_f.attribute2%TYPE DEFAULT NULL,
1748: p_attribute3 per_all_people_f.attribute3%TYPE DEFAULT NULL,
1749: p_attribute4 per_all_people_f.attribute4%TYPE DEFAULT NULL,
1750: p_attribute5 per_all_people_f.attribute5%TYPE DEFAULT NULL,

Line 1747: p_attribute2 per_all_people_f.attribute2%TYPE DEFAULT NULL,

1743: p_per_information28 per_all_people_f.per_information28%TYPE DEFAULT NULL,
1744: p_per_information29 per_all_people_f.per_information29%TYPE DEFAULT NULL,
1745: p_per_information30 per_all_people_f.per_information30%TYPE DEFAULT NULL,
1746: p_attribute1 per_all_people_f.attribute1%TYPE DEFAULT NULL,
1747: p_attribute2 per_all_people_f.attribute2%TYPE DEFAULT NULL,
1748: p_attribute3 per_all_people_f.attribute3%TYPE DEFAULT NULL,
1749: p_attribute4 per_all_people_f.attribute4%TYPE DEFAULT NULL,
1750: p_attribute5 per_all_people_f.attribute5%TYPE DEFAULT NULL,
1751: p_attribute6 per_all_people_f.attribute6%TYPE DEFAULT NULL,

Line 1748: p_attribute3 per_all_people_f.attribute3%TYPE DEFAULT NULL,

1744: p_per_information29 per_all_people_f.per_information29%TYPE DEFAULT NULL,
1745: p_per_information30 per_all_people_f.per_information30%TYPE DEFAULT NULL,
1746: p_attribute1 per_all_people_f.attribute1%TYPE DEFAULT NULL,
1747: p_attribute2 per_all_people_f.attribute2%TYPE DEFAULT NULL,
1748: p_attribute3 per_all_people_f.attribute3%TYPE DEFAULT NULL,
1749: p_attribute4 per_all_people_f.attribute4%TYPE DEFAULT NULL,
1750: p_attribute5 per_all_people_f.attribute5%TYPE DEFAULT NULL,
1751: p_attribute6 per_all_people_f.attribute6%TYPE DEFAULT NULL,
1752: p_attribute7 per_all_people_f.attribute7%TYPE DEFAULT NULL,

Line 1749: p_attribute4 per_all_people_f.attribute4%TYPE DEFAULT NULL,

1745: p_per_information30 per_all_people_f.per_information30%TYPE DEFAULT NULL,
1746: p_attribute1 per_all_people_f.attribute1%TYPE DEFAULT NULL,
1747: p_attribute2 per_all_people_f.attribute2%TYPE DEFAULT NULL,
1748: p_attribute3 per_all_people_f.attribute3%TYPE DEFAULT NULL,
1749: p_attribute4 per_all_people_f.attribute4%TYPE DEFAULT NULL,
1750: p_attribute5 per_all_people_f.attribute5%TYPE DEFAULT NULL,
1751: p_attribute6 per_all_people_f.attribute6%TYPE DEFAULT NULL,
1752: p_attribute7 per_all_people_f.attribute7%TYPE DEFAULT NULL,
1753: p_attribute8 per_all_people_f.attribute8%TYPE DEFAULT NULL,

Line 1750: p_attribute5 per_all_people_f.attribute5%TYPE DEFAULT NULL,

1746: p_attribute1 per_all_people_f.attribute1%TYPE DEFAULT NULL,
1747: p_attribute2 per_all_people_f.attribute2%TYPE DEFAULT NULL,
1748: p_attribute3 per_all_people_f.attribute3%TYPE DEFAULT NULL,
1749: p_attribute4 per_all_people_f.attribute4%TYPE DEFAULT NULL,
1750: p_attribute5 per_all_people_f.attribute5%TYPE DEFAULT NULL,
1751: p_attribute6 per_all_people_f.attribute6%TYPE DEFAULT NULL,
1752: p_attribute7 per_all_people_f.attribute7%TYPE DEFAULT NULL,
1753: p_attribute8 per_all_people_f.attribute8%TYPE DEFAULT NULL,
1754: p_attribute9 per_all_people_f.attribute9%TYPE DEFAULT NULL,

Line 1751: p_attribute6 per_all_people_f.attribute6%TYPE DEFAULT NULL,

1747: p_attribute2 per_all_people_f.attribute2%TYPE DEFAULT NULL,
1748: p_attribute3 per_all_people_f.attribute3%TYPE DEFAULT NULL,
1749: p_attribute4 per_all_people_f.attribute4%TYPE DEFAULT NULL,
1750: p_attribute5 per_all_people_f.attribute5%TYPE DEFAULT NULL,
1751: p_attribute6 per_all_people_f.attribute6%TYPE DEFAULT NULL,
1752: p_attribute7 per_all_people_f.attribute7%TYPE DEFAULT NULL,
1753: p_attribute8 per_all_people_f.attribute8%TYPE DEFAULT NULL,
1754: p_attribute9 per_all_people_f.attribute9%TYPE DEFAULT NULL,
1755: p_attribute10 per_all_people_f.attribute10%TYPE DEFAULT NULL,

Line 1752: p_attribute7 per_all_people_f.attribute7%TYPE DEFAULT NULL,

1748: p_attribute3 per_all_people_f.attribute3%TYPE DEFAULT NULL,
1749: p_attribute4 per_all_people_f.attribute4%TYPE DEFAULT NULL,
1750: p_attribute5 per_all_people_f.attribute5%TYPE DEFAULT NULL,
1751: p_attribute6 per_all_people_f.attribute6%TYPE DEFAULT NULL,
1752: p_attribute7 per_all_people_f.attribute7%TYPE DEFAULT NULL,
1753: p_attribute8 per_all_people_f.attribute8%TYPE DEFAULT NULL,
1754: p_attribute9 per_all_people_f.attribute9%TYPE DEFAULT NULL,
1755: p_attribute10 per_all_people_f.attribute10%TYPE DEFAULT NULL,
1756: p_attribute11 per_all_people_f.attribute11%TYPE DEFAULT NULL,

Line 1753: p_attribute8 per_all_people_f.attribute8%TYPE DEFAULT NULL,

1749: p_attribute4 per_all_people_f.attribute4%TYPE DEFAULT NULL,
1750: p_attribute5 per_all_people_f.attribute5%TYPE DEFAULT NULL,
1751: p_attribute6 per_all_people_f.attribute6%TYPE DEFAULT NULL,
1752: p_attribute7 per_all_people_f.attribute7%TYPE DEFAULT NULL,
1753: p_attribute8 per_all_people_f.attribute8%TYPE DEFAULT NULL,
1754: p_attribute9 per_all_people_f.attribute9%TYPE DEFAULT NULL,
1755: p_attribute10 per_all_people_f.attribute10%TYPE DEFAULT NULL,
1756: p_attribute11 per_all_people_f.attribute11%TYPE DEFAULT NULL,
1757: p_attribute12 per_all_people_f.attribute12%TYPE DEFAULT NULL,

Line 1754: p_attribute9 per_all_people_f.attribute9%TYPE DEFAULT NULL,

1750: p_attribute5 per_all_people_f.attribute5%TYPE DEFAULT NULL,
1751: p_attribute6 per_all_people_f.attribute6%TYPE DEFAULT NULL,
1752: p_attribute7 per_all_people_f.attribute7%TYPE DEFAULT NULL,
1753: p_attribute8 per_all_people_f.attribute8%TYPE DEFAULT NULL,
1754: p_attribute9 per_all_people_f.attribute9%TYPE DEFAULT NULL,
1755: p_attribute10 per_all_people_f.attribute10%TYPE DEFAULT NULL,
1756: p_attribute11 per_all_people_f.attribute11%TYPE DEFAULT NULL,
1757: p_attribute12 per_all_people_f.attribute12%TYPE DEFAULT NULL,
1758: p_attribute13 per_all_people_f.attribute13%TYPE DEFAULT NULL,

Line 1755: p_attribute10 per_all_people_f.attribute10%TYPE DEFAULT NULL,

1751: p_attribute6 per_all_people_f.attribute6%TYPE DEFAULT NULL,
1752: p_attribute7 per_all_people_f.attribute7%TYPE DEFAULT NULL,
1753: p_attribute8 per_all_people_f.attribute8%TYPE DEFAULT NULL,
1754: p_attribute9 per_all_people_f.attribute9%TYPE DEFAULT NULL,
1755: p_attribute10 per_all_people_f.attribute10%TYPE DEFAULT NULL,
1756: p_attribute11 per_all_people_f.attribute11%TYPE DEFAULT NULL,
1757: p_attribute12 per_all_people_f.attribute12%TYPE DEFAULT NULL,
1758: p_attribute13 per_all_people_f.attribute13%TYPE DEFAULT NULL,
1759: p_attribute14 per_all_people_f.attribute14%TYPE DEFAULT NULL,

Line 1756: p_attribute11 per_all_people_f.attribute11%TYPE DEFAULT NULL,

1752: p_attribute7 per_all_people_f.attribute7%TYPE DEFAULT NULL,
1753: p_attribute8 per_all_people_f.attribute8%TYPE DEFAULT NULL,
1754: p_attribute9 per_all_people_f.attribute9%TYPE DEFAULT NULL,
1755: p_attribute10 per_all_people_f.attribute10%TYPE DEFAULT NULL,
1756: p_attribute11 per_all_people_f.attribute11%TYPE DEFAULT NULL,
1757: p_attribute12 per_all_people_f.attribute12%TYPE DEFAULT NULL,
1758: p_attribute13 per_all_people_f.attribute13%TYPE DEFAULT NULL,
1759: p_attribute14 per_all_people_f.attribute14%TYPE DEFAULT NULL,
1760: p_attribute15 per_all_people_f.attribute15%TYPE DEFAULT NULL,

Line 1757: p_attribute12 per_all_people_f.attribute12%TYPE DEFAULT NULL,

1753: p_attribute8 per_all_people_f.attribute8%TYPE DEFAULT NULL,
1754: p_attribute9 per_all_people_f.attribute9%TYPE DEFAULT NULL,
1755: p_attribute10 per_all_people_f.attribute10%TYPE DEFAULT NULL,
1756: p_attribute11 per_all_people_f.attribute11%TYPE DEFAULT NULL,
1757: p_attribute12 per_all_people_f.attribute12%TYPE DEFAULT NULL,
1758: p_attribute13 per_all_people_f.attribute13%TYPE DEFAULT NULL,
1759: p_attribute14 per_all_people_f.attribute14%TYPE DEFAULT NULL,
1760: p_attribute15 per_all_people_f.attribute15%TYPE DEFAULT NULL,
1761: p_attribute16 per_all_people_f.attribute16%TYPE DEFAULT NULL,

Line 1758: p_attribute13 per_all_people_f.attribute13%TYPE DEFAULT NULL,

1754: p_attribute9 per_all_people_f.attribute9%TYPE DEFAULT NULL,
1755: p_attribute10 per_all_people_f.attribute10%TYPE DEFAULT NULL,
1756: p_attribute11 per_all_people_f.attribute11%TYPE DEFAULT NULL,
1757: p_attribute12 per_all_people_f.attribute12%TYPE DEFAULT NULL,
1758: p_attribute13 per_all_people_f.attribute13%TYPE DEFAULT NULL,
1759: p_attribute14 per_all_people_f.attribute14%TYPE DEFAULT NULL,
1760: p_attribute15 per_all_people_f.attribute15%TYPE DEFAULT NULL,
1761: p_attribute16 per_all_people_f.attribute16%TYPE DEFAULT NULL,
1762: p_attribute17 per_all_people_f.attribute17%TYPE DEFAULT NULL,

Line 1759: p_attribute14 per_all_people_f.attribute14%TYPE DEFAULT NULL,

1755: p_attribute10 per_all_people_f.attribute10%TYPE DEFAULT NULL,
1756: p_attribute11 per_all_people_f.attribute11%TYPE DEFAULT NULL,
1757: p_attribute12 per_all_people_f.attribute12%TYPE DEFAULT NULL,
1758: p_attribute13 per_all_people_f.attribute13%TYPE DEFAULT NULL,
1759: p_attribute14 per_all_people_f.attribute14%TYPE DEFAULT NULL,
1760: p_attribute15 per_all_people_f.attribute15%TYPE DEFAULT NULL,
1761: p_attribute16 per_all_people_f.attribute16%TYPE DEFAULT NULL,
1762: p_attribute17 per_all_people_f.attribute17%TYPE DEFAULT NULL,
1763: p_attribute18 per_all_people_f.attribute18%TYPE DEFAULT NULL,

Line 1760: p_attribute15 per_all_people_f.attribute15%TYPE DEFAULT NULL,

1756: p_attribute11 per_all_people_f.attribute11%TYPE DEFAULT NULL,
1757: p_attribute12 per_all_people_f.attribute12%TYPE DEFAULT NULL,
1758: p_attribute13 per_all_people_f.attribute13%TYPE DEFAULT NULL,
1759: p_attribute14 per_all_people_f.attribute14%TYPE DEFAULT NULL,
1760: p_attribute15 per_all_people_f.attribute15%TYPE DEFAULT NULL,
1761: p_attribute16 per_all_people_f.attribute16%TYPE DEFAULT NULL,
1762: p_attribute17 per_all_people_f.attribute17%TYPE DEFAULT NULL,
1763: p_attribute18 per_all_people_f.attribute18%TYPE DEFAULT NULL,
1764: p_attribute19 per_all_people_f.attribute19%TYPE DEFAULT NULL,

Line 1761: p_attribute16 per_all_people_f.attribute16%TYPE DEFAULT NULL,

1757: p_attribute12 per_all_people_f.attribute12%TYPE DEFAULT NULL,
1758: p_attribute13 per_all_people_f.attribute13%TYPE DEFAULT NULL,
1759: p_attribute14 per_all_people_f.attribute14%TYPE DEFAULT NULL,
1760: p_attribute15 per_all_people_f.attribute15%TYPE DEFAULT NULL,
1761: p_attribute16 per_all_people_f.attribute16%TYPE DEFAULT NULL,
1762: p_attribute17 per_all_people_f.attribute17%TYPE DEFAULT NULL,
1763: p_attribute18 per_all_people_f.attribute18%TYPE DEFAULT NULL,
1764: p_attribute19 per_all_people_f.attribute19%TYPE DEFAULT NULL,
1765: p_attribute20 per_all_people_f.attribute20%TYPE DEFAULT NULL,

Line 1762: p_attribute17 per_all_people_f.attribute17%TYPE DEFAULT NULL,

1758: p_attribute13 per_all_people_f.attribute13%TYPE DEFAULT NULL,
1759: p_attribute14 per_all_people_f.attribute14%TYPE DEFAULT NULL,
1760: p_attribute15 per_all_people_f.attribute15%TYPE DEFAULT NULL,
1761: p_attribute16 per_all_people_f.attribute16%TYPE DEFAULT NULL,
1762: p_attribute17 per_all_people_f.attribute17%TYPE DEFAULT NULL,
1763: p_attribute18 per_all_people_f.attribute18%TYPE DEFAULT NULL,
1764: p_attribute19 per_all_people_f.attribute19%TYPE DEFAULT NULL,
1765: p_attribute20 per_all_people_f.attribute20%TYPE DEFAULT NULL,
1766: p_attribute21 per_all_people_f.attribute21%TYPE DEFAULT NULL,

Line 1763: p_attribute18 per_all_people_f.attribute18%TYPE DEFAULT NULL,

1759: p_attribute14 per_all_people_f.attribute14%TYPE DEFAULT NULL,
1760: p_attribute15 per_all_people_f.attribute15%TYPE DEFAULT NULL,
1761: p_attribute16 per_all_people_f.attribute16%TYPE DEFAULT NULL,
1762: p_attribute17 per_all_people_f.attribute17%TYPE DEFAULT NULL,
1763: p_attribute18 per_all_people_f.attribute18%TYPE DEFAULT NULL,
1764: p_attribute19 per_all_people_f.attribute19%TYPE DEFAULT NULL,
1765: p_attribute20 per_all_people_f.attribute20%TYPE DEFAULT NULL,
1766: p_attribute21 per_all_people_f.attribute21%TYPE DEFAULT NULL,
1767: p_attribute22 per_all_people_f.attribute22%TYPE DEFAULT NULL,

Line 1764: p_attribute19 per_all_people_f.attribute19%TYPE DEFAULT NULL,

1760: p_attribute15 per_all_people_f.attribute15%TYPE DEFAULT NULL,
1761: p_attribute16 per_all_people_f.attribute16%TYPE DEFAULT NULL,
1762: p_attribute17 per_all_people_f.attribute17%TYPE DEFAULT NULL,
1763: p_attribute18 per_all_people_f.attribute18%TYPE DEFAULT NULL,
1764: p_attribute19 per_all_people_f.attribute19%TYPE DEFAULT NULL,
1765: p_attribute20 per_all_people_f.attribute20%TYPE DEFAULT NULL,
1766: p_attribute21 per_all_people_f.attribute21%TYPE DEFAULT NULL,
1767: p_attribute22 per_all_people_f.attribute22%TYPE DEFAULT NULL,
1768: p_attribute23 per_all_people_f.attribute23%TYPE DEFAULT NULL,

Line 1765: p_attribute20 per_all_people_f.attribute20%TYPE DEFAULT NULL,

1761: p_attribute16 per_all_people_f.attribute16%TYPE DEFAULT NULL,
1762: p_attribute17 per_all_people_f.attribute17%TYPE DEFAULT NULL,
1763: p_attribute18 per_all_people_f.attribute18%TYPE DEFAULT NULL,
1764: p_attribute19 per_all_people_f.attribute19%TYPE DEFAULT NULL,
1765: p_attribute20 per_all_people_f.attribute20%TYPE DEFAULT NULL,
1766: p_attribute21 per_all_people_f.attribute21%TYPE DEFAULT NULL,
1767: p_attribute22 per_all_people_f.attribute22%TYPE DEFAULT NULL,
1768: p_attribute23 per_all_people_f.attribute23%TYPE DEFAULT NULL,
1769: p_attribute24 per_all_people_f.attribute24%TYPE DEFAULT NULL,

Line 1766: p_attribute21 per_all_people_f.attribute21%TYPE DEFAULT NULL,

1762: p_attribute17 per_all_people_f.attribute17%TYPE DEFAULT NULL,
1763: p_attribute18 per_all_people_f.attribute18%TYPE DEFAULT NULL,
1764: p_attribute19 per_all_people_f.attribute19%TYPE DEFAULT NULL,
1765: p_attribute20 per_all_people_f.attribute20%TYPE DEFAULT NULL,
1766: p_attribute21 per_all_people_f.attribute21%TYPE DEFAULT NULL,
1767: p_attribute22 per_all_people_f.attribute22%TYPE DEFAULT NULL,
1768: p_attribute23 per_all_people_f.attribute23%TYPE DEFAULT NULL,
1769: p_attribute24 per_all_people_f.attribute24%TYPE DEFAULT NULL,
1770: p_attribute25 per_all_people_f.attribute25%TYPE DEFAULT NULL,

Line 1767: p_attribute22 per_all_people_f.attribute22%TYPE DEFAULT NULL,

1763: p_attribute18 per_all_people_f.attribute18%TYPE DEFAULT NULL,
1764: p_attribute19 per_all_people_f.attribute19%TYPE DEFAULT NULL,
1765: p_attribute20 per_all_people_f.attribute20%TYPE DEFAULT NULL,
1766: p_attribute21 per_all_people_f.attribute21%TYPE DEFAULT NULL,
1767: p_attribute22 per_all_people_f.attribute22%TYPE DEFAULT NULL,
1768: p_attribute23 per_all_people_f.attribute23%TYPE DEFAULT NULL,
1769: p_attribute24 per_all_people_f.attribute24%TYPE DEFAULT NULL,
1770: p_attribute25 per_all_people_f.attribute25%TYPE DEFAULT NULL,
1771: p_attribute26 per_all_people_f.attribute26%TYPE DEFAULT NULL,

Line 1768: p_attribute23 per_all_people_f.attribute23%TYPE DEFAULT NULL,

1764: p_attribute19 per_all_people_f.attribute19%TYPE DEFAULT NULL,
1765: p_attribute20 per_all_people_f.attribute20%TYPE DEFAULT NULL,
1766: p_attribute21 per_all_people_f.attribute21%TYPE DEFAULT NULL,
1767: p_attribute22 per_all_people_f.attribute22%TYPE DEFAULT NULL,
1768: p_attribute23 per_all_people_f.attribute23%TYPE DEFAULT NULL,
1769: p_attribute24 per_all_people_f.attribute24%TYPE DEFAULT NULL,
1770: p_attribute25 per_all_people_f.attribute25%TYPE DEFAULT NULL,
1771: p_attribute26 per_all_people_f.attribute26%TYPE DEFAULT NULL,
1772: p_attribute27 per_all_people_f.attribute27%TYPE DEFAULT NULL,

Line 1769: p_attribute24 per_all_people_f.attribute24%TYPE DEFAULT NULL,

1765: p_attribute20 per_all_people_f.attribute20%TYPE DEFAULT NULL,
1766: p_attribute21 per_all_people_f.attribute21%TYPE DEFAULT NULL,
1767: p_attribute22 per_all_people_f.attribute22%TYPE DEFAULT NULL,
1768: p_attribute23 per_all_people_f.attribute23%TYPE DEFAULT NULL,
1769: p_attribute24 per_all_people_f.attribute24%TYPE DEFAULT NULL,
1770: p_attribute25 per_all_people_f.attribute25%TYPE DEFAULT NULL,
1771: p_attribute26 per_all_people_f.attribute26%TYPE DEFAULT NULL,
1772: p_attribute27 per_all_people_f.attribute27%TYPE DEFAULT NULL,
1773: p_attribute28 per_all_people_f.attribute28%TYPE DEFAULT NULL,

Line 1770: p_attribute25 per_all_people_f.attribute25%TYPE DEFAULT NULL,

1766: p_attribute21 per_all_people_f.attribute21%TYPE DEFAULT NULL,
1767: p_attribute22 per_all_people_f.attribute22%TYPE DEFAULT NULL,
1768: p_attribute23 per_all_people_f.attribute23%TYPE DEFAULT NULL,
1769: p_attribute24 per_all_people_f.attribute24%TYPE DEFAULT NULL,
1770: p_attribute25 per_all_people_f.attribute25%TYPE DEFAULT NULL,
1771: p_attribute26 per_all_people_f.attribute26%TYPE DEFAULT NULL,
1772: p_attribute27 per_all_people_f.attribute27%TYPE DEFAULT NULL,
1773: p_attribute28 per_all_people_f.attribute28%TYPE DEFAULT NULL,
1774: p_attribute29 per_all_people_f.attribute29%TYPE DEFAULT NULL,

Line 1771: p_attribute26 per_all_people_f.attribute26%TYPE DEFAULT NULL,

1767: p_attribute22 per_all_people_f.attribute22%TYPE DEFAULT NULL,
1768: p_attribute23 per_all_people_f.attribute23%TYPE DEFAULT NULL,
1769: p_attribute24 per_all_people_f.attribute24%TYPE DEFAULT NULL,
1770: p_attribute25 per_all_people_f.attribute25%TYPE DEFAULT NULL,
1771: p_attribute26 per_all_people_f.attribute26%TYPE DEFAULT NULL,
1772: p_attribute27 per_all_people_f.attribute27%TYPE DEFAULT NULL,
1773: p_attribute28 per_all_people_f.attribute28%TYPE DEFAULT NULL,
1774: p_attribute29 per_all_people_f.attribute29%TYPE DEFAULT NULL,
1775: p_attribute30 per_all_people_f.attribute30%TYPE DEFAULT NULL,

Line 1772: p_attribute27 per_all_people_f.attribute27%TYPE DEFAULT NULL,

1768: p_attribute23 per_all_people_f.attribute23%TYPE DEFAULT NULL,
1769: p_attribute24 per_all_people_f.attribute24%TYPE DEFAULT NULL,
1770: p_attribute25 per_all_people_f.attribute25%TYPE DEFAULT NULL,
1771: p_attribute26 per_all_people_f.attribute26%TYPE DEFAULT NULL,
1772: p_attribute27 per_all_people_f.attribute27%TYPE DEFAULT NULL,
1773: p_attribute28 per_all_people_f.attribute28%TYPE DEFAULT NULL,
1774: p_attribute29 per_all_people_f.attribute29%TYPE DEFAULT NULL,
1775: p_attribute30 per_all_people_f.attribute30%TYPE DEFAULT NULL,
1776: p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE ,

Line 1773: p_attribute28 per_all_people_f.attribute28%TYPE DEFAULT NULL,

1769: p_attribute24 per_all_people_f.attribute24%TYPE DEFAULT NULL,
1770: p_attribute25 per_all_people_f.attribute25%TYPE DEFAULT NULL,
1771: p_attribute26 per_all_people_f.attribute26%TYPE DEFAULT NULL,
1772: p_attribute27 per_all_people_f.attribute27%TYPE DEFAULT NULL,
1773: p_attribute28 per_all_people_f.attribute28%TYPE DEFAULT NULL,
1774: p_attribute29 per_all_people_f.attribute29%TYPE DEFAULT NULL,
1775: p_attribute30 per_all_people_f.attribute30%TYPE DEFAULT NULL,
1776: p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE ,
1777: p_order_name OUT NOCOPY per_all_people_f.order_name%TYPE,

Line 1774: p_attribute29 per_all_people_f.attribute29%TYPE DEFAULT NULL,

1770: p_attribute25 per_all_people_f.attribute25%TYPE DEFAULT NULL,
1771: p_attribute26 per_all_people_f.attribute26%TYPE DEFAULT NULL,
1772: p_attribute27 per_all_people_f.attribute27%TYPE DEFAULT NULL,
1773: p_attribute28 per_all_people_f.attribute28%TYPE DEFAULT NULL,
1774: p_attribute29 per_all_people_f.attribute29%TYPE DEFAULT NULL,
1775: p_attribute30 per_all_people_f.attribute30%TYPE DEFAULT NULL,
1776: p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE ,
1777: p_order_name OUT NOCOPY per_all_people_f.order_name%TYPE,
1778: p_global_name OUT NOCOPY per_all_people_f.global_name%TYPE,

Line 1775: p_attribute30 per_all_people_f.attribute30%TYPE DEFAULT NULL,

1771: p_attribute26 per_all_people_f.attribute26%TYPE DEFAULT NULL,
1772: p_attribute27 per_all_people_f.attribute27%TYPE DEFAULT NULL,
1773: p_attribute28 per_all_people_f.attribute28%TYPE DEFAULT NULL,
1774: p_attribute29 per_all_people_f.attribute29%TYPE DEFAULT NULL,
1775: p_attribute30 per_all_people_f.attribute30%TYPE DEFAULT NULL,
1776: p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE ,
1777: p_order_name OUT NOCOPY per_all_people_f.order_name%TYPE,
1778: p_global_name OUT NOCOPY per_all_people_f.global_name%TYPE,
1779: p_local_name OUT NOCOPY per_all_people_f.local_name%TYPE

Line 1776: p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE ,

1772: p_attribute27 per_all_people_f.attribute27%TYPE DEFAULT NULL,
1773: p_attribute28 per_all_people_f.attribute28%TYPE DEFAULT NULL,
1774: p_attribute29 per_all_people_f.attribute29%TYPE DEFAULT NULL,
1775: p_attribute30 per_all_people_f.attribute30%TYPE DEFAULT NULL,
1776: p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE ,
1777: p_order_name OUT NOCOPY per_all_people_f.order_name%TYPE,
1778: p_global_name OUT NOCOPY per_all_people_f.global_name%TYPE,
1779: p_local_name OUT NOCOPY per_all_people_f.local_name%TYPE
1780: ) is

Line 1777: p_order_name OUT NOCOPY per_all_people_f.order_name%TYPE,

1773: p_attribute28 per_all_people_f.attribute28%TYPE DEFAULT NULL,
1774: p_attribute29 per_all_people_f.attribute29%TYPE DEFAULT NULL,
1775: p_attribute30 per_all_people_f.attribute30%TYPE DEFAULT NULL,
1776: p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE ,
1777: p_order_name OUT NOCOPY per_all_people_f.order_name%TYPE,
1778: p_global_name OUT NOCOPY per_all_people_f.global_name%TYPE,
1779: p_local_name OUT NOCOPY per_all_people_f.local_name%TYPE
1780: ) is
1781: --

Line 1778: p_global_name OUT NOCOPY per_all_people_f.global_name%TYPE,

1774: p_attribute29 per_all_people_f.attribute29%TYPE DEFAULT NULL,
1775: p_attribute30 per_all_people_f.attribute30%TYPE DEFAULT NULL,
1776: p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE ,
1777: p_order_name OUT NOCOPY per_all_people_f.order_name%TYPE,
1778: p_global_name OUT NOCOPY per_all_people_f.global_name%TYPE,
1779: p_local_name OUT NOCOPY per_all_people_f.local_name%TYPE
1780: ) is
1781: --
1782: l_proc CONSTANT varchar2(80) := g_package||'get_derive_person_names';

Line 1779: p_local_name OUT NOCOPY per_all_people_f.local_name%TYPE

1775: p_attribute30 per_all_people_f.attribute30%TYPE DEFAULT NULL,
1776: p_full_name OUT NOCOPY per_all_people_f.full_name%TYPE ,
1777: p_order_name OUT NOCOPY per_all_people_f.order_name%TYPE,
1778: p_global_name OUT NOCOPY per_all_people_f.global_name%TYPE,
1779: p_local_name OUT NOCOPY per_all_people_f.local_name%TYPE
1780: ) is
1781: --
1782: l_proc CONSTANT varchar2(80) := g_package||'get_derive_person_names';
1783: --