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.BEN_EXT_PERSON dependencies on PER_ALL_PEOPLE_F

Line 27: g_person_id per_all_people_f.person_id%TYPE;

23:
24: --
25: -- detail - personal (25)
26: -- ======================
27: g_person_id per_all_people_f.person_id%TYPE;
28: --
29: g_chg_evt_cd varchar2(30);
30: g_chg_evt_source varchar2(30);
31: g_chg_eff_dt ben_ext_chg_evt_log.chg_eff_dt%TYPE;

Line 66: g_part_ssn per_all_people_f.national_identifier%TYPE;

62: g_chg_pay_evt_index number ;
63: --
64: g_part_type varchar2(30);
65: g_per_rlshp_type varchar2(30);
66: g_part_ssn per_all_people_f.national_identifier%TYPE;
67: g_part_first_name per_all_people_f.first_name%TYPE;
68: g_part_last_name per_all_people_f.last_name%TYPE;
69: --
70: g_national_identifier per_all_people_f.national_identifier%TYPE;

Line 67: g_part_first_name per_all_people_f.first_name%TYPE;

63: --
64: g_part_type varchar2(30);
65: g_per_rlshp_type varchar2(30);
66: g_part_ssn per_all_people_f.national_identifier%TYPE;
67: g_part_first_name per_all_people_f.first_name%TYPE;
68: g_part_last_name per_all_people_f.last_name%TYPE;
69: --
70: g_national_identifier per_all_people_f.national_identifier%TYPE;
71: g_last_name per_all_people_f.last_name%TYPE;

Line 68: g_part_last_name per_all_people_f.last_name%TYPE;

64: g_part_type varchar2(30);
65: g_per_rlshp_type varchar2(30);
66: g_part_ssn per_all_people_f.national_identifier%TYPE;
67: g_part_first_name per_all_people_f.first_name%TYPE;
68: g_part_last_name per_all_people_f.last_name%TYPE;
69: --
70: g_national_identifier per_all_people_f.national_identifier%TYPE;
71: g_last_name per_all_people_f.last_name%TYPE;
72: g_first_name per_all_people_f.first_name%TYPE;

Line 70: g_national_identifier per_all_people_f.national_identifier%TYPE;

66: g_part_ssn per_all_people_f.national_identifier%TYPE;
67: g_part_first_name per_all_people_f.first_name%TYPE;
68: g_part_last_name per_all_people_f.last_name%TYPE;
69: --
70: g_national_identifier per_all_people_f.national_identifier%TYPE;
71: g_last_name per_all_people_f.last_name%TYPE;
72: g_first_name per_all_people_f.first_name%TYPE;
73: g_middle_names per_all_people_f.middle_names%TYPE;
74: g_full_name per_all_people_f.full_name%TYPE;

Line 71: g_last_name per_all_people_f.last_name%TYPE;

67: g_part_first_name per_all_people_f.first_name%TYPE;
68: g_part_last_name per_all_people_f.last_name%TYPE;
69: --
70: g_national_identifier per_all_people_f.national_identifier%TYPE;
71: g_last_name per_all_people_f.last_name%TYPE;
72: g_first_name per_all_people_f.first_name%TYPE;
73: g_middle_names per_all_people_f.middle_names%TYPE;
74: g_full_name per_all_people_f.full_name%TYPE;
75: g_suffix per_all_people_f.suffix%TYPE;

Line 72: g_first_name per_all_people_f.first_name%TYPE;

68: g_part_last_name per_all_people_f.last_name%TYPE;
69: --
70: g_national_identifier per_all_people_f.national_identifier%TYPE;
71: g_last_name per_all_people_f.last_name%TYPE;
72: g_first_name per_all_people_f.first_name%TYPE;
73: g_middle_names per_all_people_f.middle_names%TYPE;
74: g_full_name per_all_people_f.full_name%TYPE;
75: g_suffix per_all_people_f.suffix%TYPE;
76: g_prefix per_all_people_f.pre_name_adjunct%TYPE;

Line 73: g_middle_names per_all_people_f.middle_names%TYPE;

69: --
70: g_national_identifier per_all_people_f.national_identifier%TYPE;
71: g_last_name per_all_people_f.last_name%TYPE;
72: g_first_name per_all_people_f.first_name%TYPE;
73: g_middle_names per_all_people_f.middle_names%TYPE;
74: g_full_name per_all_people_f.full_name%TYPE;
75: g_suffix per_all_people_f.suffix%TYPE;
76: g_prefix per_all_people_f.pre_name_adjunct%TYPE;
77: g_title per_all_people_f.title%TYPE;

Line 74: g_full_name per_all_people_f.full_name%TYPE;

70: g_national_identifier per_all_people_f.national_identifier%TYPE;
71: g_last_name per_all_people_f.last_name%TYPE;
72: g_first_name per_all_people_f.first_name%TYPE;
73: g_middle_names per_all_people_f.middle_names%TYPE;
74: g_full_name per_all_people_f.full_name%TYPE;
75: g_suffix per_all_people_f.suffix%TYPE;
76: g_prefix per_all_people_f.pre_name_adjunct%TYPE;
77: g_title per_all_people_f.title%TYPE;
78: g_sup_full_name per_all_people_f.full_name%TYPE;

Line 75: g_suffix per_all_people_f.suffix%TYPE;

71: g_last_name per_all_people_f.last_name%TYPE;
72: g_first_name per_all_people_f.first_name%TYPE;
73: g_middle_names per_all_people_f.middle_names%TYPE;
74: g_full_name per_all_people_f.full_name%TYPE;
75: g_suffix per_all_people_f.suffix%TYPE;
76: g_prefix per_all_people_f.pre_name_adjunct%TYPE;
77: g_title per_all_people_f.title%TYPE;
78: g_sup_full_name per_all_people_f.full_name%TYPE;
79: --

Line 76: g_prefix per_all_people_f.pre_name_adjunct%TYPE;

72: g_first_name per_all_people_f.first_name%TYPE;
73: g_middle_names per_all_people_f.middle_names%TYPE;
74: g_full_name per_all_people_f.full_name%TYPE;
75: g_suffix per_all_people_f.suffix%TYPE;
76: g_prefix per_all_people_f.pre_name_adjunct%TYPE;
77: g_title per_all_people_f.title%TYPE;
78: g_sup_full_name per_all_people_f.full_name%TYPE;
79: --
80: g_sex per_all_people_f.sex%TYPE;

Line 77: g_title per_all_people_f.title%TYPE;

73: g_middle_names per_all_people_f.middle_names%TYPE;
74: g_full_name per_all_people_f.full_name%TYPE;
75: g_suffix per_all_people_f.suffix%TYPE;
76: g_prefix per_all_people_f.pre_name_adjunct%TYPE;
77: g_title per_all_people_f.title%TYPE;
78: g_sup_full_name per_all_people_f.full_name%TYPE;
79: --
80: g_sex per_all_people_f.sex%TYPE;
81: g_date_of_birth per_all_people_f.date_of_birth%TYPE;

Line 78: g_sup_full_name per_all_people_f.full_name%TYPE;

74: g_full_name per_all_people_f.full_name%TYPE;
75: g_suffix per_all_people_f.suffix%TYPE;
76: g_prefix per_all_people_f.pre_name_adjunct%TYPE;
77: g_title per_all_people_f.title%TYPE;
78: g_sup_full_name per_all_people_f.full_name%TYPE;
79: --
80: g_sex per_all_people_f.sex%TYPE;
81: g_date_of_birth per_all_people_f.date_of_birth%TYPE;
82: g_marital_status per_all_people_f.marital_status%TYPE;

Line 80: g_sex per_all_people_f.sex%TYPE;

76: g_prefix per_all_people_f.pre_name_adjunct%TYPE;
77: g_title per_all_people_f.title%TYPE;
78: g_sup_full_name per_all_people_f.full_name%TYPE;
79: --
80: g_sex per_all_people_f.sex%TYPE;
81: g_date_of_birth per_all_people_f.date_of_birth%TYPE;
82: g_marital_status per_all_people_f.marital_status%TYPE;
83: g_registered_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
84: g_student_status per_all_people_f.student_status%TYPE;

Line 81: g_date_of_birth per_all_people_f.date_of_birth%TYPE;

77: g_title per_all_people_f.title%TYPE;
78: g_sup_full_name per_all_people_f.full_name%TYPE;
79: --
80: g_sex per_all_people_f.sex%TYPE;
81: g_date_of_birth per_all_people_f.date_of_birth%TYPE;
82: g_marital_status per_all_people_f.marital_status%TYPE;
83: g_registered_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
84: g_student_status per_all_people_f.student_status%TYPE;
85: g_date_of_death per_all_people_f.date_of_death%TYPE;

Line 82: g_marital_status per_all_people_f.marital_status%TYPE;

78: g_sup_full_name per_all_people_f.full_name%TYPE;
79: --
80: g_sex per_all_people_f.sex%TYPE;
81: g_date_of_birth per_all_people_f.date_of_birth%TYPE;
82: g_marital_status per_all_people_f.marital_status%TYPE;
83: g_registered_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
84: g_student_status per_all_people_f.student_status%TYPE;
85: g_date_of_death per_all_people_f.date_of_death%TYPE;
86: g_employee_number per_all_people_f.employee_number%TYPE;

Line 83: g_registered_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;

79: --
80: g_sex per_all_people_f.sex%TYPE;
81: g_date_of_birth per_all_people_f.date_of_birth%TYPE;
82: g_marital_status per_all_people_f.marital_status%TYPE;
83: g_registered_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
84: g_student_status per_all_people_f.student_status%TYPE;
85: g_date_of_death per_all_people_f.date_of_death%TYPE;
86: g_employee_number per_all_people_f.employee_number%TYPE;
87: g_per_information1 per_all_people_f.per_information1%TYPE;

Line 84: g_student_status per_all_people_f.student_status%TYPE;

80: g_sex per_all_people_f.sex%TYPE;
81: g_date_of_birth per_all_people_f.date_of_birth%TYPE;
82: g_marital_status per_all_people_f.marital_status%TYPE;
83: g_registered_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
84: g_student_status per_all_people_f.student_status%TYPE;
85: g_date_of_death per_all_people_f.date_of_death%TYPE;
86: g_employee_number per_all_people_f.employee_number%TYPE;
87: g_per_information1 per_all_people_f.per_information1%TYPE;
88: g_per_information2 per_all_people_f.per_information2%TYPE;

Line 85: g_date_of_death per_all_people_f.date_of_death%TYPE;

81: g_date_of_birth per_all_people_f.date_of_birth%TYPE;
82: g_marital_status per_all_people_f.marital_status%TYPE;
83: g_registered_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
84: g_student_status per_all_people_f.student_status%TYPE;
85: g_date_of_death per_all_people_f.date_of_death%TYPE;
86: g_employee_number per_all_people_f.employee_number%TYPE;
87: g_per_information1 per_all_people_f.per_information1%TYPE;
88: g_per_information2 per_all_people_f.per_information2%TYPE;
89: g_per_information3 per_all_people_f.per_information3%TYPE;

Line 86: g_employee_number per_all_people_f.employee_number%TYPE;

82: g_marital_status per_all_people_f.marital_status%TYPE;
83: g_registered_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
84: g_student_status per_all_people_f.student_status%TYPE;
85: g_date_of_death per_all_people_f.date_of_death%TYPE;
86: g_employee_number per_all_people_f.employee_number%TYPE;
87: g_per_information1 per_all_people_f.per_information1%TYPE;
88: g_per_information2 per_all_people_f.per_information2%TYPE;
89: g_per_information3 per_all_people_f.per_information3%TYPE;
90: g_per_information4 per_all_people_f.per_information4%TYPE;

Line 87: g_per_information1 per_all_people_f.per_information1%TYPE;

83: g_registered_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
84: g_student_status per_all_people_f.student_status%TYPE;
85: g_date_of_death per_all_people_f.date_of_death%TYPE;
86: g_employee_number per_all_people_f.employee_number%TYPE;
87: g_per_information1 per_all_people_f.per_information1%TYPE;
88: g_per_information2 per_all_people_f.per_information2%TYPE;
89: g_per_information3 per_all_people_f.per_information3%TYPE;
90: g_per_information4 per_all_people_f.per_information4%TYPE;
91: g_per_information5 per_all_people_f.per_information5%TYPE;

Line 88: g_per_information2 per_all_people_f.per_information2%TYPE;

84: g_student_status per_all_people_f.student_status%TYPE;
85: g_date_of_death per_all_people_f.date_of_death%TYPE;
86: g_employee_number per_all_people_f.employee_number%TYPE;
87: g_per_information1 per_all_people_f.per_information1%TYPE;
88: g_per_information2 per_all_people_f.per_information2%TYPE;
89: g_per_information3 per_all_people_f.per_information3%TYPE;
90: g_per_information4 per_all_people_f.per_information4%TYPE;
91: g_per_information5 per_all_people_f.per_information5%TYPE;
92: g_per_information6 per_all_people_f.per_information6%TYPE;

Line 89: g_per_information3 per_all_people_f.per_information3%TYPE;

85: g_date_of_death per_all_people_f.date_of_death%TYPE;
86: g_employee_number per_all_people_f.employee_number%TYPE;
87: g_per_information1 per_all_people_f.per_information1%TYPE;
88: g_per_information2 per_all_people_f.per_information2%TYPE;
89: g_per_information3 per_all_people_f.per_information3%TYPE;
90: g_per_information4 per_all_people_f.per_information4%TYPE;
91: g_per_information5 per_all_people_f.per_information5%TYPE;
92: g_per_information6 per_all_people_f.per_information6%TYPE;
93: g_per_information7 per_all_people_f.per_information7%TYPE;

Line 90: g_per_information4 per_all_people_f.per_information4%TYPE;

86: g_employee_number per_all_people_f.employee_number%TYPE;
87: g_per_information1 per_all_people_f.per_information1%TYPE;
88: g_per_information2 per_all_people_f.per_information2%TYPE;
89: g_per_information3 per_all_people_f.per_information3%TYPE;
90: g_per_information4 per_all_people_f.per_information4%TYPE;
91: g_per_information5 per_all_people_f.per_information5%TYPE;
92: g_per_information6 per_all_people_f.per_information6%TYPE;
93: g_per_information7 per_all_people_f.per_information7%TYPE;
94: g_per_information8 per_all_people_f.per_information8%TYPE;

Line 91: g_per_information5 per_all_people_f.per_information5%TYPE;

87: g_per_information1 per_all_people_f.per_information1%TYPE;
88: g_per_information2 per_all_people_f.per_information2%TYPE;
89: g_per_information3 per_all_people_f.per_information3%TYPE;
90: g_per_information4 per_all_people_f.per_information4%TYPE;
91: g_per_information5 per_all_people_f.per_information5%TYPE;
92: g_per_information6 per_all_people_f.per_information6%TYPE;
93: g_per_information7 per_all_people_f.per_information7%TYPE;
94: g_per_information8 per_all_people_f.per_information8%TYPE;
95: g_per_information9 per_all_people_f.per_information9%TYPE;

Line 92: g_per_information6 per_all_people_f.per_information6%TYPE;

88: g_per_information2 per_all_people_f.per_information2%TYPE;
89: g_per_information3 per_all_people_f.per_information3%TYPE;
90: g_per_information4 per_all_people_f.per_information4%TYPE;
91: g_per_information5 per_all_people_f.per_information5%TYPE;
92: g_per_information6 per_all_people_f.per_information6%TYPE;
93: g_per_information7 per_all_people_f.per_information7%TYPE;
94: g_per_information8 per_all_people_f.per_information8%TYPE;
95: g_per_information9 per_all_people_f.per_information9%TYPE;
96: g_per_information10 per_all_people_f.per_information10%TYPE;

Line 93: g_per_information7 per_all_people_f.per_information7%TYPE;

89: g_per_information3 per_all_people_f.per_information3%TYPE;
90: g_per_information4 per_all_people_f.per_information4%TYPE;
91: g_per_information5 per_all_people_f.per_information5%TYPE;
92: g_per_information6 per_all_people_f.per_information6%TYPE;
93: g_per_information7 per_all_people_f.per_information7%TYPE;
94: g_per_information8 per_all_people_f.per_information8%TYPE;
95: g_per_information9 per_all_people_f.per_information9%TYPE;
96: g_per_information10 per_all_people_f.per_information10%TYPE;
97: g_per_information11 per_all_people_f.per_information11%TYPE;

Line 94: g_per_information8 per_all_people_f.per_information8%TYPE;

90: g_per_information4 per_all_people_f.per_information4%TYPE;
91: g_per_information5 per_all_people_f.per_information5%TYPE;
92: g_per_information6 per_all_people_f.per_information6%TYPE;
93: g_per_information7 per_all_people_f.per_information7%TYPE;
94: g_per_information8 per_all_people_f.per_information8%TYPE;
95: g_per_information9 per_all_people_f.per_information9%TYPE;
96: g_per_information10 per_all_people_f.per_information10%TYPE;
97: g_per_information11 per_all_people_f.per_information11%TYPE;
98: g_per_information12 per_all_people_f.per_information12%TYPE;

Line 95: g_per_information9 per_all_people_f.per_information9%TYPE;

91: g_per_information5 per_all_people_f.per_information5%TYPE;
92: g_per_information6 per_all_people_f.per_information6%TYPE;
93: g_per_information7 per_all_people_f.per_information7%TYPE;
94: g_per_information8 per_all_people_f.per_information8%TYPE;
95: g_per_information9 per_all_people_f.per_information9%TYPE;
96: g_per_information10 per_all_people_f.per_information10%TYPE;
97: g_per_information11 per_all_people_f.per_information11%TYPE;
98: g_per_information12 per_all_people_f.per_information12%TYPE;
99: g_per_information13 per_all_people_f.per_information13%TYPE;

Line 96: g_per_information10 per_all_people_f.per_information10%TYPE;

92: g_per_information6 per_all_people_f.per_information6%TYPE;
93: g_per_information7 per_all_people_f.per_information7%TYPE;
94: g_per_information8 per_all_people_f.per_information8%TYPE;
95: g_per_information9 per_all_people_f.per_information9%TYPE;
96: g_per_information10 per_all_people_f.per_information10%TYPE;
97: g_per_information11 per_all_people_f.per_information11%TYPE;
98: g_per_information12 per_all_people_f.per_information12%TYPE;
99: g_per_information13 per_all_people_f.per_information13%TYPE;
100: g_per_information14 per_all_people_f.per_information14%TYPE;

Line 97: g_per_information11 per_all_people_f.per_information11%TYPE;

93: g_per_information7 per_all_people_f.per_information7%TYPE;
94: g_per_information8 per_all_people_f.per_information8%TYPE;
95: g_per_information9 per_all_people_f.per_information9%TYPE;
96: g_per_information10 per_all_people_f.per_information10%TYPE;
97: g_per_information11 per_all_people_f.per_information11%TYPE;
98: g_per_information12 per_all_people_f.per_information12%TYPE;
99: g_per_information13 per_all_people_f.per_information13%TYPE;
100: g_per_information14 per_all_people_f.per_information14%TYPE;
101: g_per_information15 per_all_people_f.per_information14%TYPE;

Line 98: g_per_information12 per_all_people_f.per_information12%TYPE;

94: g_per_information8 per_all_people_f.per_information8%TYPE;
95: g_per_information9 per_all_people_f.per_information9%TYPE;
96: g_per_information10 per_all_people_f.per_information10%TYPE;
97: g_per_information11 per_all_people_f.per_information11%TYPE;
98: g_per_information12 per_all_people_f.per_information12%TYPE;
99: g_per_information13 per_all_people_f.per_information13%TYPE;
100: g_per_information14 per_all_people_f.per_information14%TYPE;
101: g_per_information15 per_all_people_f.per_information14%TYPE;
102: g_per_information16 per_all_people_f.per_information16%TYPE;

Line 99: g_per_information13 per_all_people_f.per_information13%TYPE;

95: g_per_information9 per_all_people_f.per_information9%TYPE;
96: g_per_information10 per_all_people_f.per_information10%TYPE;
97: g_per_information11 per_all_people_f.per_information11%TYPE;
98: g_per_information12 per_all_people_f.per_information12%TYPE;
99: g_per_information13 per_all_people_f.per_information13%TYPE;
100: g_per_information14 per_all_people_f.per_information14%TYPE;
101: g_per_information15 per_all_people_f.per_information14%TYPE;
102: g_per_information16 per_all_people_f.per_information16%TYPE;
103: g_per_information17 per_all_people_f.per_information17%TYPE;

Line 100: g_per_information14 per_all_people_f.per_information14%TYPE;

96: g_per_information10 per_all_people_f.per_information10%TYPE;
97: g_per_information11 per_all_people_f.per_information11%TYPE;
98: g_per_information12 per_all_people_f.per_information12%TYPE;
99: g_per_information13 per_all_people_f.per_information13%TYPE;
100: g_per_information14 per_all_people_f.per_information14%TYPE;
101: g_per_information15 per_all_people_f.per_information14%TYPE;
102: g_per_information16 per_all_people_f.per_information16%TYPE;
103: g_per_information17 per_all_people_f.per_information17%TYPE;
104: g_per_information18 per_all_people_f.per_information18%TYPE;

Line 101: g_per_information15 per_all_people_f.per_information14%TYPE;

97: g_per_information11 per_all_people_f.per_information11%TYPE;
98: g_per_information12 per_all_people_f.per_information12%TYPE;
99: g_per_information13 per_all_people_f.per_information13%TYPE;
100: g_per_information14 per_all_people_f.per_information14%TYPE;
101: g_per_information15 per_all_people_f.per_information14%TYPE;
102: g_per_information16 per_all_people_f.per_information16%TYPE;
103: g_per_information17 per_all_people_f.per_information17%TYPE;
104: g_per_information18 per_all_people_f.per_information18%TYPE;
105: g_per_information19 per_all_people_f.per_information19%TYPE;

Line 102: g_per_information16 per_all_people_f.per_information16%TYPE;

98: g_per_information12 per_all_people_f.per_information12%TYPE;
99: g_per_information13 per_all_people_f.per_information13%TYPE;
100: g_per_information14 per_all_people_f.per_information14%TYPE;
101: g_per_information15 per_all_people_f.per_information14%TYPE;
102: g_per_information16 per_all_people_f.per_information16%TYPE;
103: g_per_information17 per_all_people_f.per_information17%TYPE;
104: g_per_information18 per_all_people_f.per_information18%TYPE;
105: g_per_information19 per_all_people_f.per_information19%TYPE;
106: g_per_information20 per_all_people_f.per_information20%TYPE;

Line 103: g_per_information17 per_all_people_f.per_information17%TYPE;

99: g_per_information13 per_all_people_f.per_information13%TYPE;
100: g_per_information14 per_all_people_f.per_information14%TYPE;
101: g_per_information15 per_all_people_f.per_information14%TYPE;
102: g_per_information16 per_all_people_f.per_information16%TYPE;
103: g_per_information17 per_all_people_f.per_information17%TYPE;
104: g_per_information18 per_all_people_f.per_information18%TYPE;
105: g_per_information19 per_all_people_f.per_information19%TYPE;
106: g_per_information20 per_all_people_f.per_information20%TYPE;
107: g_per_information21 per_all_people_f.per_information20%TYPE;

Line 104: g_per_information18 per_all_people_f.per_information18%TYPE;

100: g_per_information14 per_all_people_f.per_information14%TYPE;
101: g_per_information15 per_all_people_f.per_information14%TYPE;
102: g_per_information16 per_all_people_f.per_information16%TYPE;
103: g_per_information17 per_all_people_f.per_information17%TYPE;
104: g_per_information18 per_all_people_f.per_information18%TYPE;
105: g_per_information19 per_all_people_f.per_information19%TYPE;
106: g_per_information20 per_all_people_f.per_information20%TYPE;
107: g_per_information21 per_all_people_f.per_information20%TYPE;
108: g_per_information22 per_all_people_f.per_information21%TYPE;

Line 105: g_per_information19 per_all_people_f.per_information19%TYPE;

101: g_per_information15 per_all_people_f.per_information14%TYPE;
102: g_per_information16 per_all_people_f.per_information16%TYPE;
103: g_per_information17 per_all_people_f.per_information17%TYPE;
104: g_per_information18 per_all_people_f.per_information18%TYPE;
105: g_per_information19 per_all_people_f.per_information19%TYPE;
106: g_per_information20 per_all_people_f.per_information20%TYPE;
107: g_per_information21 per_all_people_f.per_information20%TYPE;
108: g_per_information22 per_all_people_f.per_information21%TYPE;
109: g_per_information23 per_all_people_f.per_information22%TYPE;

Line 106: g_per_information20 per_all_people_f.per_information20%TYPE;

102: g_per_information16 per_all_people_f.per_information16%TYPE;
103: g_per_information17 per_all_people_f.per_information17%TYPE;
104: g_per_information18 per_all_people_f.per_information18%TYPE;
105: g_per_information19 per_all_people_f.per_information19%TYPE;
106: g_per_information20 per_all_people_f.per_information20%TYPE;
107: g_per_information21 per_all_people_f.per_information20%TYPE;
108: g_per_information22 per_all_people_f.per_information21%TYPE;
109: g_per_information23 per_all_people_f.per_information22%TYPE;
110: g_per_information24 per_all_people_f.per_information23%TYPE;

Line 107: g_per_information21 per_all_people_f.per_information20%TYPE;

103: g_per_information17 per_all_people_f.per_information17%TYPE;
104: g_per_information18 per_all_people_f.per_information18%TYPE;
105: g_per_information19 per_all_people_f.per_information19%TYPE;
106: g_per_information20 per_all_people_f.per_information20%TYPE;
107: g_per_information21 per_all_people_f.per_information20%TYPE;
108: g_per_information22 per_all_people_f.per_information21%TYPE;
109: g_per_information23 per_all_people_f.per_information22%TYPE;
110: g_per_information24 per_all_people_f.per_information23%TYPE;
111: g_per_information25 per_all_people_f.per_information24%TYPE;

Line 108: g_per_information22 per_all_people_f.per_information21%TYPE;

104: g_per_information18 per_all_people_f.per_information18%TYPE;
105: g_per_information19 per_all_people_f.per_information19%TYPE;
106: g_per_information20 per_all_people_f.per_information20%TYPE;
107: g_per_information21 per_all_people_f.per_information20%TYPE;
108: g_per_information22 per_all_people_f.per_information21%TYPE;
109: g_per_information23 per_all_people_f.per_information22%TYPE;
110: g_per_information24 per_all_people_f.per_information23%TYPE;
111: g_per_information25 per_all_people_f.per_information24%TYPE;
112: g_per_information26 per_all_people_f.per_information25%TYPE;

Line 109: g_per_information23 per_all_people_f.per_information22%TYPE;

105: g_per_information19 per_all_people_f.per_information19%TYPE;
106: g_per_information20 per_all_people_f.per_information20%TYPE;
107: g_per_information21 per_all_people_f.per_information20%TYPE;
108: g_per_information22 per_all_people_f.per_information21%TYPE;
109: g_per_information23 per_all_people_f.per_information22%TYPE;
110: g_per_information24 per_all_people_f.per_information23%TYPE;
111: g_per_information25 per_all_people_f.per_information24%TYPE;
112: g_per_information26 per_all_people_f.per_information25%TYPE;
113: g_per_information27 per_all_people_f.per_information27%TYPE;

Line 110: g_per_information24 per_all_people_f.per_information23%TYPE;

106: g_per_information20 per_all_people_f.per_information20%TYPE;
107: g_per_information21 per_all_people_f.per_information20%TYPE;
108: g_per_information22 per_all_people_f.per_information21%TYPE;
109: g_per_information23 per_all_people_f.per_information22%TYPE;
110: g_per_information24 per_all_people_f.per_information23%TYPE;
111: g_per_information25 per_all_people_f.per_information24%TYPE;
112: g_per_information26 per_all_people_f.per_information25%TYPE;
113: g_per_information27 per_all_people_f.per_information27%TYPE;
114: g_per_information28 per_all_people_f.per_information28%TYPE;

Line 111: g_per_information25 per_all_people_f.per_information24%TYPE;

107: g_per_information21 per_all_people_f.per_information20%TYPE;
108: g_per_information22 per_all_people_f.per_information21%TYPE;
109: g_per_information23 per_all_people_f.per_information22%TYPE;
110: g_per_information24 per_all_people_f.per_information23%TYPE;
111: g_per_information25 per_all_people_f.per_information24%TYPE;
112: g_per_information26 per_all_people_f.per_information25%TYPE;
113: g_per_information27 per_all_people_f.per_information27%TYPE;
114: g_per_information28 per_all_people_f.per_information28%TYPE;
115: g_per_information29 per_all_people_f.per_information29%TYPE;

Line 112: g_per_information26 per_all_people_f.per_information25%TYPE;

108: g_per_information22 per_all_people_f.per_information21%TYPE;
109: g_per_information23 per_all_people_f.per_information22%TYPE;
110: g_per_information24 per_all_people_f.per_information23%TYPE;
111: g_per_information25 per_all_people_f.per_information24%TYPE;
112: g_per_information26 per_all_people_f.per_information25%TYPE;
113: g_per_information27 per_all_people_f.per_information27%TYPE;
114: g_per_information28 per_all_people_f.per_information28%TYPE;
115: g_per_information29 per_all_people_f.per_information29%TYPE;
116: g_per_information30 per_all_people_f.per_information30%TYPE;

Line 113: g_per_information27 per_all_people_f.per_information27%TYPE;

109: g_per_information23 per_all_people_f.per_information22%TYPE;
110: g_per_information24 per_all_people_f.per_information23%TYPE;
111: g_per_information25 per_all_people_f.per_information24%TYPE;
112: g_per_information26 per_all_people_f.per_information25%TYPE;
113: g_per_information27 per_all_people_f.per_information27%TYPE;
114: g_per_information28 per_all_people_f.per_information28%TYPE;
115: g_per_information29 per_all_people_f.per_information29%TYPE;
116: g_per_information30 per_all_people_f.per_information30%TYPE;
117: g_benefit_group_id ben_benfts_grp.benfts_grp_id%TYPE;

Line 114: g_per_information28 per_all_people_f.per_information28%TYPE;

110: g_per_information24 per_all_people_f.per_information23%TYPE;
111: g_per_information25 per_all_people_f.per_information24%TYPE;
112: g_per_information26 per_all_people_f.per_information25%TYPE;
113: g_per_information27 per_all_people_f.per_information27%TYPE;
114: g_per_information28 per_all_people_f.per_information28%TYPE;
115: g_per_information29 per_all_people_f.per_information29%TYPE;
116: g_per_information30 per_all_people_f.per_information30%TYPE;
117: g_benefit_group_id ben_benfts_grp.benfts_grp_id%TYPE;
118: g_benefit_group ben_benfts_grp.name%TYPE;

Line 115: g_per_information29 per_all_people_f.per_information29%TYPE;

111: g_per_information25 per_all_people_f.per_information24%TYPE;
112: g_per_information26 per_all_people_f.per_information25%TYPE;
113: g_per_information27 per_all_people_f.per_information27%TYPE;
114: g_per_information28 per_all_people_f.per_information28%TYPE;
115: g_per_information29 per_all_people_f.per_information29%TYPE;
116: g_per_information30 per_all_people_f.per_information30%TYPE;
117: g_benefit_group_id ben_benfts_grp.benfts_grp_id%TYPE;
118: g_benefit_group ben_benfts_grp.name%TYPE;
119: g_benefit_bal_vacation ben_per_bnfts_bal_f.val%TYPE;

Line 116: g_per_information30 per_all_people_f.per_information30%TYPE;

112: g_per_information26 per_all_people_f.per_information25%TYPE;
113: g_per_information27 per_all_people_f.per_information27%TYPE;
114: g_per_information28 per_all_people_f.per_information28%TYPE;
115: g_per_information29 per_all_people_f.per_information29%TYPE;
116: g_per_information30 per_all_people_f.per_information30%TYPE;
117: g_benefit_group_id ben_benfts_grp.benfts_grp_id%TYPE;
118: g_benefit_group ben_benfts_grp.name%TYPE;
119: g_benefit_bal_vacation ben_per_bnfts_bal_f.val%TYPE;
120: g_benefit_bal_sickleave ben_per_bnfts_bal_f.val%TYPE;

Line 124: g_sup_employee_number per_all_people_f.employee_number%TYPE;

120: g_benefit_bal_sickleave ben_per_bnfts_bal_f.val%TYPE;
121: g_benefit_bal_pension ben_per_bnfts_bal_f.val%TYPE;
122: g_benefit_bal_dfncntrbn ben_per_bnfts_bal_f.val%TYPE;
123: g_benefit_bal_wellness ben_per_bnfts_bal_f.val%TYPE;
124: g_sup_employee_number per_all_people_f.employee_number%TYPE;
125: --
126: g_applicant_number per_all_people_f.applicant_number%TYPE;
127: g_correspondence_language per_all_people_f.correspondence_language%TYPE;
128: g_email_address per_all_people_f.email_address%TYPE;

Line 126: g_applicant_number per_all_people_f.applicant_number%TYPE;

122: g_benefit_bal_dfncntrbn ben_per_bnfts_bal_f.val%TYPE;
123: g_benefit_bal_wellness ben_per_bnfts_bal_f.val%TYPE;
124: g_sup_employee_number per_all_people_f.employee_number%TYPE;
125: --
126: g_applicant_number per_all_people_f.applicant_number%TYPE;
127: g_correspondence_language per_all_people_f.correspondence_language%TYPE;
128: g_email_address per_all_people_f.email_address%TYPE;
129: g_known_as per_all_people_f.known_as%TYPE;
130: g_mailstop per_all_people_f.mailstop%TYPE;

Line 127: g_correspondence_language per_all_people_f.correspondence_language%TYPE;

123: g_benefit_bal_wellness ben_per_bnfts_bal_f.val%TYPE;
124: g_sup_employee_number per_all_people_f.employee_number%TYPE;
125: --
126: g_applicant_number per_all_people_f.applicant_number%TYPE;
127: g_correspondence_language per_all_people_f.correspondence_language%TYPE;
128: g_email_address per_all_people_f.email_address%TYPE;
129: g_known_as per_all_people_f.known_as%TYPE;
130: g_mailstop per_all_people_f.mailstop%TYPE;
131: g_nationality per_all_people_f.nationality%TYPE;

Line 128: g_email_address per_all_people_f.email_address%TYPE;

124: g_sup_employee_number per_all_people_f.employee_number%TYPE;
125: --
126: g_applicant_number per_all_people_f.applicant_number%TYPE;
127: g_correspondence_language per_all_people_f.correspondence_language%TYPE;
128: g_email_address per_all_people_f.email_address%TYPE;
129: g_known_as per_all_people_f.known_as%TYPE;
130: g_mailstop per_all_people_f.mailstop%TYPE;
131: g_nationality per_all_people_f.nationality%TYPE;
132: g_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;

Line 129: g_known_as per_all_people_f.known_as%TYPE;

125: --
126: g_applicant_number per_all_people_f.applicant_number%TYPE;
127: g_correspondence_language per_all_people_f.correspondence_language%TYPE;
128: g_email_address per_all_people_f.email_address%TYPE;
129: g_known_as per_all_people_f.known_as%TYPE;
130: g_mailstop per_all_people_f.mailstop%TYPE;
131: g_nationality per_all_people_f.nationality%TYPE;
132: g_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
133: g_original_date_of_hire per_all_people_f.original_date_of_hire%TYPE;

Line 130: g_mailstop per_all_people_f.mailstop%TYPE;

126: g_applicant_number per_all_people_f.applicant_number%TYPE;
127: g_correspondence_language per_all_people_f.correspondence_language%TYPE;
128: g_email_address per_all_people_f.email_address%TYPE;
129: g_known_as per_all_people_f.known_as%TYPE;
130: g_mailstop per_all_people_f.mailstop%TYPE;
131: g_nationality per_all_people_f.nationality%TYPE;
132: g_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
133: g_original_date_of_hire per_all_people_f.original_date_of_hire%TYPE;
134: g_uses_tobacco_flag per_all_people_f.uses_tobacco_flag%TYPE;

Line 131: g_nationality per_all_people_f.nationality%TYPE;

127: g_correspondence_language per_all_people_f.correspondence_language%TYPE;
128: g_email_address per_all_people_f.email_address%TYPE;
129: g_known_as per_all_people_f.known_as%TYPE;
130: g_mailstop per_all_people_f.mailstop%TYPE;
131: g_nationality per_all_people_f.nationality%TYPE;
132: g_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
133: g_original_date_of_hire per_all_people_f.original_date_of_hire%TYPE;
134: g_uses_tobacco_flag per_all_people_f.uses_tobacco_flag%TYPE;
135: g_office_number per_all_people_f.office_number%TYPE;

Line 132: g_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;

128: g_email_address per_all_people_f.email_address%TYPE;
129: g_known_as per_all_people_f.known_as%TYPE;
130: g_mailstop per_all_people_f.mailstop%TYPE;
131: g_nationality per_all_people_f.nationality%TYPE;
132: g_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
133: g_original_date_of_hire per_all_people_f.original_date_of_hire%TYPE;
134: g_uses_tobacco_flag per_all_people_f.uses_tobacco_flag%TYPE;
135: g_office_number per_all_people_f.office_number%TYPE;
136: --

Line 133: g_original_date_of_hire per_all_people_f.original_date_of_hire%TYPE;

129: g_known_as per_all_people_f.known_as%TYPE;
130: g_mailstop per_all_people_f.mailstop%TYPE;
131: g_nationality per_all_people_f.nationality%TYPE;
132: g_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
133: g_original_date_of_hire per_all_people_f.original_date_of_hire%TYPE;
134: g_uses_tobacco_flag per_all_people_f.uses_tobacco_flag%TYPE;
135: g_office_number per_all_people_f.office_number%TYPE;
136: --
137: g_previous_last_name per_all_people_f.last_name%TYPE;

Line 134: g_uses_tobacco_flag per_all_people_f.uses_tobacco_flag%TYPE;

130: g_mailstop per_all_people_f.mailstop%TYPE;
131: g_nationality per_all_people_f.nationality%TYPE;
132: g_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
133: g_original_date_of_hire per_all_people_f.original_date_of_hire%TYPE;
134: g_uses_tobacco_flag per_all_people_f.uses_tobacco_flag%TYPE;
135: g_office_number per_all_people_f.office_number%TYPE;
136: --
137: g_previous_last_name per_all_people_f.last_name%TYPE;
138: g_previous_first_name per_all_people_f.first_name%TYPE;

Line 135: g_office_number per_all_people_f.office_number%TYPE;

131: g_nationality per_all_people_f.nationality%TYPE;
132: g_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
133: g_original_date_of_hire per_all_people_f.original_date_of_hire%TYPE;
134: g_uses_tobacco_flag per_all_people_f.uses_tobacco_flag%TYPE;
135: g_office_number per_all_people_f.office_number%TYPE;
136: --
137: g_previous_last_name per_all_people_f.last_name%TYPE;
138: g_previous_first_name per_all_people_f.first_name%TYPE;
139: g_previous_middle_name per_all_people_f.middle_names%TYPE;

Line 137: g_previous_last_name per_all_people_f.last_name%TYPE;

133: g_original_date_of_hire per_all_people_f.original_date_of_hire%TYPE;
134: g_uses_tobacco_flag per_all_people_f.uses_tobacco_flag%TYPE;
135: g_office_number per_all_people_f.office_number%TYPE;
136: --
137: g_previous_last_name per_all_people_f.last_name%TYPE;
138: g_previous_first_name per_all_people_f.first_name%TYPE;
139: g_previous_middle_name per_all_people_f.middle_names%TYPE;
140: g_previous_suffix per_all_people_f.suffix%TYPE;
141: g_previous_prefix per_all_people_f.pre_name_adjunct%TYPE;

Line 138: g_previous_first_name per_all_people_f.first_name%TYPE;

134: g_uses_tobacco_flag per_all_people_f.uses_tobacco_flag%TYPE;
135: g_office_number per_all_people_f.office_number%TYPE;
136: --
137: g_previous_last_name per_all_people_f.last_name%TYPE;
138: g_previous_first_name per_all_people_f.first_name%TYPE;
139: g_previous_middle_name per_all_people_f.middle_names%TYPE;
140: g_previous_suffix per_all_people_f.suffix%TYPE;
141: g_previous_prefix per_all_people_f.pre_name_adjunct%TYPE;
142: g_previous_ssn per_all_people_f.national_identifier%TYPE;

Line 139: g_previous_middle_name per_all_people_f.middle_names%TYPE;

135: g_office_number per_all_people_f.office_number%TYPE;
136: --
137: g_previous_last_name per_all_people_f.last_name%TYPE;
138: g_previous_first_name per_all_people_f.first_name%TYPE;
139: g_previous_middle_name per_all_people_f.middle_names%TYPE;
140: g_previous_suffix per_all_people_f.suffix%TYPE;
141: g_previous_prefix per_all_people_f.pre_name_adjunct%TYPE;
142: g_previous_ssn per_all_people_f.national_identifier%TYPE;
143: g_previous_dob per_all_people_f.date_of_birth%TYPE;

Line 140: g_previous_suffix per_all_people_f.suffix%TYPE;

136: --
137: g_previous_last_name per_all_people_f.last_name%TYPE;
138: g_previous_first_name per_all_people_f.first_name%TYPE;
139: g_previous_middle_name per_all_people_f.middle_names%TYPE;
140: g_previous_suffix per_all_people_f.suffix%TYPE;
141: g_previous_prefix per_all_people_f.pre_name_adjunct%TYPE;
142: g_previous_ssn per_all_people_f.national_identifier%TYPE;
143: g_previous_dob per_all_people_f.date_of_birth%TYPE;
144: g_previous_sex per_all_people_f.Sex%TYPE;

Line 141: g_previous_prefix per_all_people_f.pre_name_adjunct%TYPE;

137: g_previous_last_name per_all_people_f.last_name%TYPE;
138: g_previous_first_name per_all_people_f.first_name%TYPE;
139: g_previous_middle_name per_all_people_f.middle_names%TYPE;
140: g_previous_suffix per_all_people_f.suffix%TYPE;
141: g_previous_prefix per_all_people_f.pre_name_adjunct%TYPE;
142: g_previous_ssn per_all_people_f.national_identifier%TYPE;
143: g_previous_dob per_all_people_f.date_of_birth%TYPE;
144: g_previous_sex per_all_people_f.Sex%TYPE;
145: g_data_verification_dt per_all_people_f.date_employee_data_verified%TYPE;

Line 142: g_previous_ssn per_all_people_f.national_identifier%TYPE;

138: g_previous_first_name per_all_people_f.first_name%TYPE;
139: g_previous_middle_name per_all_people_f.middle_names%TYPE;
140: g_previous_suffix per_all_people_f.suffix%TYPE;
141: g_previous_prefix per_all_people_f.pre_name_adjunct%TYPE;
142: g_previous_ssn per_all_people_f.national_identifier%TYPE;
143: g_previous_dob per_all_people_f.date_of_birth%TYPE;
144: g_previous_sex per_all_people_f.Sex%TYPE;
145: g_data_verification_dt per_all_people_f.date_employee_data_verified%TYPE;
146: --

Line 143: g_previous_dob per_all_people_f.date_of_birth%TYPE;

139: g_previous_middle_name per_all_people_f.middle_names%TYPE;
140: g_previous_suffix per_all_people_f.suffix%TYPE;
141: g_previous_prefix per_all_people_f.pre_name_adjunct%TYPE;
142: g_previous_ssn per_all_people_f.national_identifier%TYPE;
143: g_previous_dob per_all_people_f.date_of_birth%TYPE;
144: g_previous_sex per_all_people_f.Sex%TYPE;
145: g_data_verification_dt per_all_people_f.date_employee_data_verified%TYPE;
146: --
147: g_last_update_date per_all_people_f.last_update_date%TYPE;

Line 144: g_previous_sex per_all_people_f.Sex%TYPE;

140: g_previous_suffix per_all_people_f.suffix%TYPE;
141: g_previous_prefix per_all_people_f.pre_name_adjunct%TYPE;
142: g_previous_ssn per_all_people_f.national_identifier%TYPE;
143: g_previous_dob per_all_people_f.date_of_birth%TYPE;
144: g_previous_sex per_all_people_f.Sex%TYPE;
145: g_data_verification_dt per_all_people_f.date_employee_data_verified%TYPE;
146: --
147: g_last_update_date per_all_people_f.last_update_date%TYPE;
148: g_last_updated_by per_all_people_f.last_updated_by%TYPE;

Line 145: g_data_verification_dt per_all_people_f.date_employee_data_verified%TYPE;

141: g_previous_prefix per_all_people_f.pre_name_adjunct%TYPE;
142: g_previous_ssn per_all_people_f.national_identifier%TYPE;
143: g_previous_dob per_all_people_f.date_of_birth%TYPE;
144: g_previous_sex per_all_people_f.Sex%TYPE;
145: g_data_verification_dt per_all_people_f.date_employee_data_verified%TYPE;
146: --
147: g_last_update_date per_all_people_f.last_update_date%TYPE;
148: g_last_updated_by per_all_people_f.last_updated_by%TYPE;
149: g_last_update_login per_all_people_f.last_update_login%TYPE;

Line 147: g_last_update_date per_all_people_f.last_update_date%TYPE;

143: g_previous_dob per_all_people_f.date_of_birth%TYPE;
144: g_previous_sex per_all_people_f.Sex%TYPE;
145: g_data_verification_dt per_all_people_f.date_employee_data_verified%TYPE;
146: --
147: g_last_update_date per_all_people_f.last_update_date%TYPE;
148: g_last_updated_by per_all_people_f.last_updated_by%TYPE;
149: g_last_update_login per_all_people_f.last_update_login%TYPE;
150: g_created_by per_all_people_f.created_by%TYPE;
151: g_creation_date per_all_people_f.creation_date%TYPE;

Line 148: g_last_updated_by per_all_people_f.last_updated_by%TYPE;

144: g_previous_sex per_all_people_f.Sex%TYPE;
145: g_data_verification_dt per_all_people_f.date_employee_data_verified%TYPE;
146: --
147: g_last_update_date per_all_people_f.last_update_date%TYPE;
148: g_last_updated_by per_all_people_f.last_updated_by%TYPE;
149: g_last_update_login per_all_people_f.last_update_login%TYPE;
150: g_created_by per_all_people_f.created_by%TYPE;
151: g_creation_date per_all_people_f.creation_date%TYPE;
152: --

Line 149: g_last_update_login per_all_people_f.last_update_login%TYPE;

145: g_data_verification_dt per_all_people_f.date_employee_data_verified%TYPE;
146: --
147: g_last_update_date per_all_people_f.last_update_date%TYPE;
148: g_last_updated_by per_all_people_f.last_updated_by%TYPE;
149: g_last_update_login per_all_people_f.last_update_login%TYPE;
150: g_created_by per_all_people_f.created_by%TYPE;
151: g_creation_date per_all_people_f.creation_date%TYPE;
152: --
153: g_per_attr_1 per_all_people_f.attribute1%TYPE;

Line 150: g_created_by per_all_people_f.created_by%TYPE;

146: --
147: g_last_update_date per_all_people_f.last_update_date%TYPE;
148: g_last_updated_by per_all_people_f.last_updated_by%TYPE;
149: g_last_update_login per_all_people_f.last_update_login%TYPE;
150: g_created_by per_all_people_f.created_by%TYPE;
151: g_creation_date per_all_people_f.creation_date%TYPE;
152: --
153: g_per_attr_1 per_all_people_f.attribute1%TYPE;
154: g_per_attr_2 per_all_people_f.attribute2%TYPE;

Line 151: g_creation_date per_all_people_f.creation_date%TYPE;

147: g_last_update_date per_all_people_f.last_update_date%TYPE;
148: g_last_updated_by per_all_people_f.last_updated_by%TYPE;
149: g_last_update_login per_all_people_f.last_update_login%TYPE;
150: g_created_by per_all_people_f.created_by%TYPE;
151: g_creation_date per_all_people_f.creation_date%TYPE;
152: --
153: g_per_attr_1 per_all_people_f.attribute1%TYPE;
154: g_per_attr_2 per_all_people_f.attribute2%TYPE;
155: g_per_attr_3 per_all_people_f.attribute3%TYPE;

Line 153: g_per_attr_1 per_all_people_f.attribute1%TYPE;

149: g_last_update_login per_all_people_f.last_update_login%TYPE;
150: g_created_by per_all_people_f.created_by%TYPE;
151: g_creation_date per_all_people_f.creation_date%TYPE;
152: --
153: g_per_attr_1 per_all_people_f.attribute1%TYPE;
154: g_per_attr_2 per_all_people_f.attribute2%TYPE;
155: g_per_attr_3 per_all_people_f.attribute3%TYPE;
156: g_per_attr_4 per_all_people_f.attribute4%TYPE;
157: g_per_attr_5 per_all_people_f.attribute5%TYPE;

Line 154: g_per_attr_2 per_all_people_f.attribute2%TYPE;

150: g_created_by per_all_people_f.created_by%TYPE;
151: g_creation_date per_all_people_f.creation_date%TYPE;
152: --
153: g_per_attr_1 per_all_people_f.attribute1%TYPE;
154: g_per_attr_2 per_all_people_f.attribute2%TYPE;
155: g_per_attr_3 per_all_people_f.attribute3%TYPE;
156: g_per_attr_4 per_all_people_f.attribute4%TYPE;
157: g_per_attr_5 per_all_people_f.attribute5%TYPE;
158: g_per_attr_6 per_all_people_f.attribute6%TYPE;

Line 155: g_per_attr_3 per_all_people_f.attribute3%TYPE;

151: g_creation_date per_all_people_f.creation_date%TYPE;
152: --
153: g_per_attr_1 per_all_people_f.attribute1%TYPE;
154: g_per_attr_2 per_all_people_f.attribute2%TYPE;
155: g_per_attr_3 per_all_people_f.attribute3%TYPE;
156: g_per_attr_4 per_all_people_f.attribute4%TYPE;
157: g_per_attr_5 per_all_people_f.attribute5%TYPE;
158: g_per_attr_6 per_all_people_f.attribute6%TYPE;
159: g_per_attr_7 per_all_people_f.attribute7%TYPE;

Line 156: g_per_attr_4 per_all_people_f.attribute4%TYPE;

152: --
153: g_per_attr_1 per_all_people_f.attribute1%TYPE;
154: g_per_attr_2 per_all_people_f.attribute2%TYPE;
155: g_per_attr_3 per_all_people_f.attribute3%TYPE;
156: g_per_attr_4 per_all_people_f.attribute4%TYPE;
157: g_per_attr_5 per_all_people_f.attribute5%TYPE;
158: g_per_attr_6 per_all_people_f.attribute6%TYPE;
159: g_per_attr_7 per_all_people_f.attribute7%TYPE;
160: g_per_attr_8 per_all_people_f.attribute8%TYPE;

Line 157: g_per_attr_5 per_all_people_f.attribute5%TYPE;

153: g_per_attr_1 per_all_people_f.attribute1%TYPE;
154: g_per_attr_2 per_all_people_f.attribute2%TYPE;
155: g_per_attr_3 per_all_people_f.attribute3%TYPE;
156: g_per_attr_4 per_all_people_f.attribute4%TYPE;
157: g_per_attr_5 per_all_people_f.attribute5%TYPE;
158: g_per_attr_6 per_all_people_f.attribute6%TYPE;
159: g_per_attr_7 per_all_people_f.attribute7%TYPE;
160: g_per_attr_8 per_all_people_f.attribute8%TYPE;
161: g_per_attr_9 per_all_people_f.attribute9%TYPE;

Line 158: g_per_attr_6 per_all_people_f.attribute6%TYPE;

154: g_per_attr_2 per_all_people_f.attribute2%TYPE;
155: g_per_attr_3 per_all_people_f.attribute3%TYPE;
156: g_per_attr_4 per_all_people_f.attribute4%TYPE;
157: g_per_attr_5 per_all_people_f.attribute5%TYPE;
158: g_per_attr_6 per_all_people_f.attribute6%TYPE;
159: g_per_attr_7 per_all_people_f.attribute7%TYPE;
160: g_per_attr_8 per_all_people_f.attribute8%TYPE;
161: g_per_attr_9 per_all_people_f.attribute9%TYPE;
162: g_per_attr_10 per_all_people_f.attribute10%TYPE;

Line 159: g_per_attr_7 per_all_people_f.attribute7%TYPE;

155: g_per_attr_3 per_all_people_f.attribute3%TYPE;
156: g_per_attr_4 per_all_people_f.attribute4%TYPE;
157: g_per_attr_5 per_all_people_f.attribute5%TYPE;
158: g_per_attr_6 per_all_people_f.attribute6%TYPE;
159: g_per_attr_7 per_all_people_f.attribute7%TYPE;
160: g_per_attr_8 per_all_people_f.attribute8%TYPE;
161: g_per_attr_9 per_all_people_f.attribute9%TYPE;
162: g_per_attr_10 per_all_people_f.attribute10%TYPE;
163: --

Line 160: g_per_attr_8 per_all_people_f.attribute8%TYPE;

156: g_per_attr_4 per_all_people_f.attribute4%TYPE;
157: g_per_attr_5 per_all_people_f.attribute5%TYPE;
158: g_per_attr_6 per_all_people_f.attribute6%TYPE;
159: g_per_attr_7 per_all_people_f.attribute7%TYPE;
160: g_per_attr_8 per_all_people_f.attribute8%TYPE;
161: g_per_attr_9 per_all_people_f.attribute9%TYPE;
162: g_per_attr_10 per_all_people_f.attribute10%TYPE;
163: --
164: -- g_work_telephone per_all_people_f.work_telephone%TYPE;

Line 161: g_per_attr_9 per_all_people_f.attribute9%TYPE;

157: g_per_attr_5 per_all_people_f.attribute5%TYPE;
158: g_per_attr_6 per_all_people_f.attribute6%TYPE;
159: g_per_attr_7 per_all_people_f.attribute7%TYPE;
160: g_per_attr_8 per_all_people_f.attribute8%TYPE;
161: g_per_attr_9 per_all_people_f.attribute9%TYPE;
162: g_per_attr_10 per_all_people_f.attribute10%TYPE;
163: --
164: -- g_work_telephone per_all_people_f.work_telephone%TYPE;
165: --

Line 162: g_per_attr_10 per_all_people_f.attribute10%TYPE;

158: g_per_attr_6 per_all_people_f.attribute6%TYPE;
159: g_per_attr_7 per_all_people_f.attribute7%TYPE;
160: g_per_attr_8 per_all_people_f.attribute8%TYPE;
161: g_per_attr_9 per_all_people_f.attribute9%TYPE;
162: g_per_attr_10 per_all_people_f.attribute10%TYPE;
163: --
164: -- g_work_telephone per_all_people_f.work_telephone%TYPE;
165: --
166: g_prim_address_line_1 per_addresses.address_line1%TYPE;

Line 164: -- g_work_telephone per_all_people_f.work_telephone%TYPE;

160: g_per_attr_8 per_all_people_f.attribute8%TYPE;
161: g_per_attr_9 per_all_people_f.attribute9%TYPE;
162: g_per_attr_10 per_all_people_f.attribute10%TYPE;
163: --
164: -- g_work_telephone per_all_people_f.work_telephone%TYPE;
165: --
166: g_prim_address_line_1 per_addresses.address_line1%TYPE;
167: g_prim_address_line_2 per_addresses.address_line2%TYPE;
168: g_prim_address_line_3 per_addresses.address_line3%TYPE;

Line 568: g_dpnt_national_identifier per_all_people_f.national_identifier%TYPE;

564: g_pev_ttl_other_rate number;
565: --
566: -- detail - dependent
567: --
568: g_dpnt_national_identifier per_all_people_f.national_identifier%TYPE;
569: g_dpnt_last_name per_all_people_f.last_name%TYPE;
570: g_dpnt_first_name per_all_people_f.first_name%TYPE;
571: g_dpnt_middle_names per_all_people_f.middle_names%TYPE;
572: g_dpnt_full_name per_all_people_f.full_name%TYPE;

Line 569: g_dpnt_last_name per_all_people_f.last_name%TYPE;

565: --
566: -- detail - dependent
567: --
568: g_dpnt_national_identifier per_all_people_f.national_identifier%TYPE;
569: g_dpnt_last_name per_all_people_f.last_name%TYPE;
570: g_dpnt_first_name per_all_people_f.first_name%TYPE;
571: g_dpnt_middle_names per_all_people_f.middle_names%TYPE;
572: g_dpnt_full_name per_all_people_f.full_name%TYPE;
573: g_dpnt_suffix per_all_people_f.suffix%TYPE;

Line 570: g_dpnt_first_name per_all_people_f.first_name%TYPE;

566: -- detail - dependent
567: --
568: g_dpnt_national_identifier per_all_people_f.national_identifier%TYPE;
569: g_dpnt_last_name per_all_people_f.last_name%TYPE;
570: g_dpnt_first_name per_all_people_f.first_name%TYPE;
571: g_dpnt_middle_names per_all_people_f.middle_names%TYPE;
572: g_dpnt_full_name per_all_people_f.full_name%TYPE;
573: g_dpnt_suffix per_all_people_f.suffix%TYPE;
574: g_Dpnt_prefix per_all_people_f.pre_name_adjunct%TYPE;

Line 571: g_dpnt_middle_names per_all_people_f.middle_names%TYPE;

567: --
568: g_dpnt_national_identifier per_all_people_f.national_identifier%TYPE;
569: g_dpnt_last_name per_all_people_f.last_name%TYPE;
570: g_dpnt_first_name per_all_people_f.first_name%TYPE;
571: g_dpnt_middle_names per_all_people_f.middle_names%TYPE;
572: g_dpnt_full_name per_all_people_f.full_name%TYPE;
573: g_dpnt_suffix per_all_people_f.suffix%TYPE;
574: g_Dpnt_prefix per_all_people_f.pre_name_adjunct%TYPE;
575: g_dpnt_title per_all_people_f.title%TYPE;

Line 572: g_dpnt_full_name per_all_people_f.full_name%TYPE;

568: g_dpnt_national_identifier per_all_people_f.national_identifier%TYPE;
569: g_dpnt_last_name per_all_people_f.last_name%TYPE;
570: g_dpnt_first_name per_all_people_f.first_name%TYPE;
571: g_dpnt_middle_names per_all_people_f.middle_names%TYPE;
572: g_dpnt_full_name per_all_people_f.full_name%TYPE;
573: g_dpnt_suffix per_all_people_f.suffix%TYPE;
574: g_Dpnt_prefix per_all_people_f.pre_name_adjunct%TYPE;
575: g_dpnt_title per_all_people_f.title%TYPE;
576: g_dpnt_rlshp_type per_contact_relationships.contact_type%TYPE;

Line 573: g_dpnt_suffix per_all_people_f.suffix%TYPE;

569: g_dpnt_last_name per_all_people_f.last_name%TYPE;
570: g_dpnt_first_name per_all_people_f.first_name%TYPE;
571: g_dpnt_middle_names per_all_people_f.middle_names%TYPE;
572: g_dpnt_full_name per_all_people_f.full_name%TYPE;
573: g_dpnt_suffix per_all_people_f.suffix%TYPE;
574: g_Dpnt_prefix per_all_people_f.pre_name_adjunct%TYPE;
575: g_dpnt_title per_all_people_f.title%TYPE;
576: g_dpnt_rlshp_type per_contact_relationships.contact_type%TYPE;
577: g_dpnt_contact_seq_num per_contact_relationships.sequence_number%TYPE;

Line 574: g_Dpnt_prefix per_all_people_f.pre_name_adjunct%TYPE;

570: g_dpnt_first_name per_all_people_f.first_name%TYPE;
571: g_dpnt_middle_names per_all_people_f.middle_names%TYPE;
572: g_dpnt_full_name per_all_people_f.full_name%TYPE;
573: g_dpnt_suffix per_all_people_f.suffix%TYPE;
574: g_Dpnt_prefix per_all_people_f.pre_name_adjunct%TYPE;
575: g_dpnt_title per_all_people_f.title%TYPE;
576: g_dpnt_rlshp_type per_contact_relationships.contact_type%TYPE;
577: g_dpnt_contact_seq_num per_contact_relationships.sequence_number%TYPE;
578: g_dpnt_shared_resd_flag per_contact_relationships.rltd_per_rsds_w_dsgntr_flag%TYPE;

Line 575: g_dpnt_title per_all_people_f.title%TYPE;

571: g_dpnt_middle_names per_all_people_f.middle_names%TYPE;
572: g_dpnt_full_name per_all_people_f.full_name%TYPE;
573: g_dpnt_suffix per_all_people_f.suffix%TYPE;
574: g_Dpnt_prefix per_all_people_f.pre_name_adjunct%TYPE;
575: g_dpnt_title per_all_people_f.title%TYPE;
576: g_dpnt_rlshp_type per_contact_relationships.contact_type%TYPE;
577: g_dpnt_contact_seq_num per_contact_relationships.sequence_number%TYPE;
578: g_dpnt_shared_resd_flag per_contact_relationships.rltd_per_rsds_w_dsgntr_flag%TYPE;
579: g_dpnt_sex per_all_people_f.sex%TYPE;

Line 579: g_dpnt_sex per_all_people_f.sex%TYPE;

575: g_dpnt_title per_all_people_f.title%TYPE;
576: g_dpnt_rlshp_type per_contact_relationships.contact_type%TYPE;
577: g_dpnt_contact_seq_num per_contact_relationships.sequence_number%TYPE;
578: g_dpnt_shared_resd_flag per_contact_relationships.rltd_per_rsds_w_dsgntr_flag%TYPE;
579: g_dpnt_sex per_all_people_f.sex%TYPE;
580: g_dpnt_date_of_birth per_all_people_f.date_of_birth%TYPE;
581: g_dpnt_marital_status per_all_people_f.marital_status%TYPE;
582: g_dpnt_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
583: g_dpnt_student_status per_all_people_f.student_status%TYPE;

Line 580: g_dpnt_date_of_birth per_all_people_f.date_of_birth%TYPE;

576: g_dpnt_rlshp_type per_contact_relationships.contact_type%TYPE;
577: g_dpnt_contact_seq_num per_contact_relationships.sequence_number%TYPE;
578: g_dpnt_shared_resd_flag per_contact_relationships.rltd_per_rsds_w_dsgntr_flag%TYPE;
579: g_dpnt_sex per_all_people_f.sex%TYPE;
580: g_dpnt_date_of_birth per_all_people_f.date_of_birth%TYPE;
581: g_dpnt_marital_status per_all_people_f.marital_status%TYPE;
582: g_dpnt_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
583: g_dpnt_student_status per_all_people_f.student_status%TYPE;
584: g_dpnt_date_of_death per_all_people_f.date_of_death%TYPE;

Line 581: g_dpnt_marital_status per_all_people_f.marital_status%TYPE;

577: g_dpnt_contact_seq_num per_contact_relationships.sequence_number%TYPE;
578: g_dpnt_shared_resd_flag per_contact_relationships.rltd_per_rsds_w_dsgntr_flag%TYPE;
579: g_dpnt_sex per_all_people_f.sex%TYPE;
580: g_dpnt_date_of_birth per_all_people_f.date_of_birth%TYPE;
581: g_dpnt_marital_status per_all_people_f.marital_status%TYPE;
582: g_dpnt_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
583: g_dpnt_student_status per_all_people_f.student_status%TYPE;
584: g_dpnt_date_of_death per_all_people_f.date_of_death%TYPE;
585: g_dpnt_cvg_strt_dt ben_elig_cvrd_dpnt_f.cvg_strt_dt%TYPE;

Line 582: g_dpnt_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;

578: g_dpnt_shared_resd_flag per_contact_relationships.rltd_per_rsds_w_dsgntr_flag%TYPE;
579: g_dpnt_sex per_all_people_f.sex%TYPE;
580: g_dpnt_date_of_birth per_all_people_f.date_of_birth%TYPE;
581: g_dpnt_marital_status per_all_people_f.marital_status%TYPE;
582: g_dpnt_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
583: g_dpnt_student_status per_all_people_f.student_status%TYPE;
584: g_dpnt_date_of_death per_all_people_f.date_of_death%TYPE;
585: g_dpnt_cvg_strt_dt ben_elig_cvrd_dpnt_f.cvg_strt_dt%TYPE;
586: g_dpnt_cvg_thru_dt ben_elig_cvrd_dpnt_f.cvg_thru_dt%TYPE;

Line 583: g_dpnt_student_status per_all_people_f.student_status%TYPE;

579: g_dpnt_sex per_all_people_f.sex%TYPE;
580: g_dpnt_date_of_birth per_all_people_f.date_of_birth%TYPE;
581: g_dpnt_marital_status per_all_people_f.marital_status%TYPE;
582: g_dpnt_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
583: g_dpnt_student_status per_all_people_f.student_status%TYPE;
584: g_dpnt_date_of_death per_all_people_f.date_of_death%TYPE;
585: g_dpnt_cvg_strt_dt ben_elig_cvrd_dpnt_f.cvg_strt_dt%TYPE;
586: g_dpnt_cvg_thru_dt ben_elig_cvrd_dpnt_f.cvg_thru_dt%TYPE;
587: g_dpnt_nationality per_all_people_f.nationality%TYPE;

Line 584: g_dpnt_date_of_death per_all_people_f.date_of_death%TYPE;

580: g_dpnt_date_of_birth per_all_people_f.date_of_birth%TYPE;
581: g_dpnt_marital_status per_all_people_f.marital_status%TYPE;
582: g_dpnt_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
583: g_dpnt_student_status per_all_people_f.student_status%TYPE;
584: g_dpnt_date_of_death per_all_people_f.date_of_death%TYPE;
585: g_dpnt_cvg_strt_dt ben_elig_cvrd_dpnt_f.cvg_strt_dt%TYPE;
586: g_dpnt_cvg_thru_dt ben_elig_cvrd_dpnt_f.cvg_thru_dt%TYPE;
587: g_dpnt_nationality per_all_people_f.nationality%TYPE;
588: g_dpnt_language per_all_people_f.correspondence_language%TYPE;

Line 587: g_dpnt_nationality per_all_people_f.nationality%TYPE;

583: g_dpnt_student_status per_all_people_f.student_status%TYPE;
584: g_dpnt_date_of_death per_all_people_f.date_of_death%TYPE;
585: g_dpnt_cvg_strt_dt ben_elig_cvrd_dpnt_f.cvg_strt_dt%TYPE;
586: g_dpnt_cvg_thru_dt ben_elig_cvrd_dpnt_f.cvg_thru_dt%TYPE;
587: g_dpnt_nationality per_all_people_f.nationality%TYPE;
588: g_dpnt_language per_all_people_f.correspondence_language%TYPE;
589: g_dpnt_email_address per_all_people_f.email_address%TYPE;
590: g_dpnt_known_as per_all_people_f.known_as%TYPE;
591: g_dpnt_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;

Line 588: g_dpnt_language per_all_people_f.correspondence_language%TYPE;

584: g_dpnt_date_of_death per_all_people_f.date_of_death%TYPE;
585: g_dpnt_cvg_strt_dt ben_elig_cvrd_dpnt_f.cvg_strt_dt%TYPE;
586: g_dpnt_cvg_thru_dt ben_elig_cvrd_dpnt_f.cvg_thru_dt%TYPE;
587: g_dpnt_nationality per_all_people_f.nationality%TYPE;
588: g_dpnt_language per_all_people_f.correspondence_language%TYPE;
589: g_dpnt_email_address per_all_people_f.email_address%TYPE;
590: g_dpnt_known_as per_all_people_f.known_as%TYPE;
591: g_dpnt_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
592: g_dpnt_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;

Line 589: g_dpnt_email_address per_all_people_f.email_address%TYPE;

585: g_dpnt_cvg_strt_dt ben_elig_cvrd_dpnt_f.cvg_strt_dt%TYPE;
586: g_dpnt_cvg_thru_dt ben_elig_cvrd_dpnt_f.cvg_thru_dt%TYPE;
587: g_dpnt_nationality per_all_people_f.nationality%TYPE;
588: g_dpnt_language per_all_people_f.correspondence_language%TYPE;
589: g_dpnt_email_address per_all_people_f.email_address%TYPE;
590: g_dpnt_known_as per_all_people_f.known_as%TYPE;
591: g_dpnt_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
592: g_dpnt_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
593: g_dpnt_prev_last_name per_all_people_f.last_name%TYPE;

Line 590: g_dpnt_known_as per_all_people_f.known_as%TYPE;

586: g_dpnt_cvg_thru_dt ben_elig_cvrd_dpnt_f.cvg_thru_dt%TYPE;
587: g_dpnt_nationality per_all_people_f.nationality%TYPE;
588: g_dpnt_language per_all_people_f.correspondence_language%TYPE;
589: g_dpnt_email_address per_all_people_f.email_address%TYPE;
590: g_dpnt_known_as per_all_people_f.known_as%TYPE;
591: g_dpnt_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
592: g_dpnt_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
593: g_dpnt_prev_last_name per_all_people_f.last_name%TYPE;
594: g_dpnt_prim_address1 per_addresses.address_line1%TYPE;

Line 591: g_dpnt_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;

587: g_dpnt_nationality per_all_people_f.nationality%TYPE;
588: g_dpnt_language per_all_people_f.correspondence_language%TYPE;
589: g_dpnt_email_address per_all_people_f.email_address%TYPE;
590: g_dpnt_known_as per_all_people_f.known_as%TYPE;
591: g_dpnt_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
592: g_dpnt_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
593: g_dpnt_prev_last_name per_all_people_f.last_name%TYPE;
594: g_dpnt_prim_address1 per_addresses.address_line1%TYPE;
595: g_dpnt_prim_address2 per_addresses.address_line2%TYPE;

Line 592: g_dpnt_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;

588: g_dpnt_language per_all_people_f.correspondence_language%TYPE;
589: g_dpnt_email_address per_all_people_f.email_address%TYPE;
590: g_dpnt_known_as per_all_people_f.known_as%TYPE;
591: g_dpnt_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
592: g_dpnt_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
593: g_dpnt_prev_last_name per_all_people_f.last_name%TYPE;
594: g_dpnt_prim_address1 per_addresses.address_line1%TYPE;
595: g_dpnt_prim_address2 per_addresses.address_line2%TYPE;
596: g_dpnt_prim_address3 per_addresses.address_line3%TYPE;

Line 593: g_dpnt_prev_last_name per_all_people_f.last_name%TYPE;

589: g_dpnt_email_address per_all_people_f.email_address%TYPE;
590: g_dpnt_known_as per_all_people_f.known_as%TYPE;
591: g_dpnt_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
592: g_dpnt_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
593: g_dpnt_prev_last_name per_all_people_f.last_name%TYPE;
594: g_dpnt_prim_address1 per_addresses.address_line1%TYPE;
595: g_dpnt_prim_address2 per_addresses.address_line2%TYPE;
596: g_dpnt_prim_address3 per_addresses.address_line3%TYPE;
597: g_dpnt_prim_city per_addresses.town_or_city%TYPE;

Line 611: g_elig_dpnt_national_ident per_all_people_f.national_identifier%TYPE;

607: g_dpnt_cvrd_dpnt_id ben_elig_cvrd_dpnt_f.elig_cvrd_dpnt_id%TYPE;
608: --
609: -- detail - eligible dependent
610: --
611: g_elig_dpnt_national_ident per_all_people_f.national_identifier%TYPE;
612: g_elig_dpnt_last_name per_all_people_f.last_name%TYPE;
613: g_elig_dpnt_first_name per_all_people_f.first_name%TYPE;
614: g_elig_dpnt_middle_names per_all_people_f.middle_names%TYPE;
615: g_elig_dpnt_full_name per_all_people_f.full_name%TYPE;

Line 612: g_elig_dpnt_last_name per_all_people_f.last_name%TYPE;

608: --
609: -- detail - eligible dependent
610: --
611: g_elig_dpnt_national_ident per_all_people_f.national_identifier%TYPE;
612: g_elig_dpnt_last_name per_all_people_f.last_name%TYPE;
613: g_elig_dpnt_first_name per_all_people_f.first_name%TYPE;
614: g_elig_dpnt_middle_names per_all_people_f.middle_names%TYPE;
615: g_elig_dpnt_full_name per_all_people_f.full_name%TYPE;
616: g_elig_dpnt_suffix per_all_people_f.suffix%TYPE;

Line 613: g_elig_dpnt_first_name per_all_people_f.first_name%TYPE;

609: -- detail - eligible dependent
610: --
611: g_elig_dpnt_national_ident per_all_people_f.national_identifier%TYPE;
612: g_elig_dpnt_last_name per_all_people_f.last_name%TYPE;
613: g_elig_dpnt_first_name per_all_people_f.first_name%TYPE;
614: g_elig_dpnt_middle_names per_all_people_f.middle_names%TYPE;
615: g_elig_dpnt_full_name per_all_people_f.full_name%TYPE;
616: g_elig_dpnt_suffix per_all_people_f.suffix%TYPE;
617: g_elig_dpnt_prefix per_all_people_f.pre_name_adjunct%TYPE;

Line 614: g_elig_dpnt_middle_names per_all_people_f.middle_names%TYPE;

610: --
611: g_elig_dpnt_national_ident per_all_people_f.national_identifier%TYPE;
612: g_elig_dpnt_last_name per_all_people_f.last_name%TYPE;
613: g_elig_dpnt_first_name per_all_people_f.first_name%TYPE;
614: g_elig_dpnt_middle_names per_all_people_f.middle_names%TYPE;
615: g_elig_dpnt_full_name per_all_people_f.full_name%TYPE;
616: g_elig_dpnt_suffix per_all_people_f.suffix%TYPE;
617: g_elig_dpnt_prefix per_all_people_f.pre_name_adjunct%TYPE;
618: g_elig_dpnt_title per_all_people_f.title%TYPE;

Line 615: g_elig_dpnt_full_name per_all_people_f.full_name%TYPE;

611: g_elig_dpnt_national_ident per_all_people_f.national_identifier%TYPE;
612: g_elig_dpnt_last_name per_all_people_f.last_name%TYPE;
613: g_elig_dpnt_first_name per_all_people_f.first_name%TYPE;
614: g_elig_dpnt_middle_names per_all_people_f.middle_names%TYPE;
615: g_elig_dpnt_full_name per_all_people_f.full_name%TYPE;
616: g_elig_dpnt_suffix per_all_people_f.suffix%TYPE;
617: g_elig_dpnt_prefix per_all_people_f.pre_name_adjunct%TYPE;
618: g_elig_dpnt_title per_all_people_f.title%TYPE;
619: g_elig_dpnt_rlshp_type per_contact_relationships.contact_type%TYPE;

Line 616: g_elig_dpnt_suffix per_all_people_f.suffix%TYPE;

612: g_elig_dpnt_last_name per_all_people_f.last_name%TYPE;
613: g_elig_dpnt_first_name per_all_people_f.first_name%TYPE;
614: g_elig_dpnt_middle_names per_all_people_f.middle_names%TYPE;
615: g_elig_dpnt_full_name per_all_people_f.full_name%TYPE;
616: g_elig_dpnt_suffix per_all_people_f.suffix%TYPE;
617: g_elig_dpnt_prefix per_all_people_f.pre_name_adjunct%TYPE;
618: g_elig_dpnt_title per_all_people_f.title%TYPE;
619: g_elig_dpnt_rlshp_type per_contact_relationships.contact_type%TYPE;
620: g_elig_dpnt_contact_seq_num per_contact_relationships.sequence_number%TYPE;

Line 617: g_elig_dpnt_prefix per_all_people_f.pre_name_adjunct%TYPE;

613: g_elig_dpnt_first_name per_all_people_f.first_name%TYPE;
614: g_elig_dpnt_middle_names per_all_people_f.middle_names%TYPE;
615: g_elig_dpnt_full_name per_all_people_f.full_name%TYPE;
616: g_elig_dpnt_suffix per_all_people_f.suffix%TYPE;
617: g_elig_dpnt_prefix per_all_people_f.pre_name_adjunct%TYPE;
618: g_elig_dpnt_title per_all_people_f.title%TYPE;
619: g_elig_dpnt_rlshp_type per_contact_relationships.contact_type%TYPE;
620: g_elig_dpnt_contact_seq_num per_contact_relationships.sequence_number%TYPE;
621: g_elig_dpnt_shared_resd_flag per_contact_relationships.rltd_per_rsds_w_dsgntr_flag%TYPE;

Line 618: g_elig_dpnt_title per_all_people_f.title%TYPE;

614: g_elig_dpnt_middle_names per_all_people_f.middle_names%TYPE;
615: g_elig_dpnt_full_name per_all_people_f.full_name%TYPE;
616: g_elig_dpnt_suffix per_all_people_f.suffix%TYPE;
617: g_elig_dpnt_prefix per_all_people_f.pre_name_adjunct%TYPE;
618: g_elig_dpnt_title per_all_people_f.title%TYPE;
619: g_elig_dpnt_rlshp_type per_contact_relationships.contact_type%TYPE;
620: g_elig_dpnt_contact_seq_num per_contact_relationships.sequence_number%TYPE;
621: g_elig_dpnt_shared_resd_flag per_contact_relationships.rltd_per_rsds_w_dsgntr_flag%TYPE;
622: g_elig_dpnt_sex per_all_people_f.sex%TYPE;

Line 622: g_elig_dpnt_sex per_all_people_f.sex%TYPE;

618: g_elig_dpnt_title per_all_people_f.title%TYPE;
619: g_elig_dpnt_rlshp_type per_contact_relationships.contact_type%TYPE;
620: g_elig_dpnt_contact_seq_num per_contact_relationships.sequence_number%TYPE;
621: g_elig_dpnt_shared_resd_flag per_contact_relationships.rltd_per_rsds_w_dsgntr_flag%TYPE;
622: g_elig_dpnt_sex per_all_people_f.sex%TYPE;
623: g_elig_dpnt_date_of_birth per_all_people_f.date_of_birth%TYPE;
624: g_elig_dpnt_marital_status per_all_people_f.marital_status%TYPE;
625: g_elig_dpnt_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
626: g_elig_dpnt_student_status per_all_people_f.student_status%TYPE;

Line 623: g_elig_dpnt_date_of_birth per_all_people_f.date_of_birth%TYPE;

619: g_elig_dpnt_rlshp_type per_contact_relationships.contact_type%TYPE;
620: g_elig_dpnt_contact_seq_num per_contact_relationships.sequence_number%TYPE;
621: g_elig_dpnt_shared_resd_flag per_contact_relationships.rltd_per_rsds_w_dsgntr_flag%TYPE;
622: g_elig_dpnt_sex per_all_people_f.sex%TYPE;
623: g_elig_dpnt_date_of_birth per_all_people_f.date_of_birth%TYPE;
624: g_elig_dpnt_marital_status per_all_people_f.marital_status%TYPE;
625: g_elig_dpnt_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
626: g_elig_dpnt_student_status per_all_people_f.student_status%TYPE;
627: g_elig_dpnt_date_of_death per_all_people_f.date_of_death%TYPE;

Line 624: g_elig_dpnt_marital_status per_all_people_f.marital_status%TYPE;

620: g_elig_dpnt_contact_seq_num per_contact_relationships.sequence_number%TYPE;
621: g_elig_dpnt_shared_resd_flag per_contact_relationships.rltd_per_rsds_w_dsgntr_flag%TYPE;
622: g_elig_dpnt_sex per_all_people_f.sex%TYPE;
623: g_elig_dpnt_date_of_birth per_all_people_f.date_of_birth%TYPE;
624: g_elig_dpnt_marital_status per_all_people_f.marital_status%TYPE;
625: g_elig_dpnt_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
626: g_elig_dpnt_student_status per_all_people_f.student_status%TYPE;
627: g_elig_dpnt_date_of_death per_all_people_f.date_of_death%TYPE;
628: g_elig_dpnt_elig_strt_dt ben_elig_dpnt.elig_strt_dt%TYPE;

Line 625: g_elig_dpnt_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;

621: g_elig_dpnt_shared_resd_flag per_contact_relationships.rltd_per_rsds_w_dsgntr_flag%TYPE;
622: g_elig_dpnt_sex per_all_people_f.sex%TYPE;
623: g_elig_dpnt_date_of_birth per_all_people_f.date_of_birth%TYPE;
624: g_elig_dpnt_marital_status per_all_people_f.marital_status%TYPE;
625: g_elig_dpnt_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
626: g_elig_dpnt_student_status per_all_people_f.student_status%TYPE;
627: g_elig_dpnt_date_of_death per_all_people_f.date_of_death%TYPE;
628: g_elig_dpnt_elig_strt_dt ben_elig_dpnt.elig_strt_dt%TYPE;
629: g_elig_dpnt_elig_thru_dt ben_elig_dpnt.elig_thru_dt%TYPE;

Line 626: g_elig_dpnt_student_status per_all_people_f.student_status%TYPE;

622: g_elig_dpnt_sex per_all_people_f.sex%TYPE;
623: g_elig_dpnt_date_of_birth per_all_people_f.date_of_birth%TYPE;
624: g_elig_dpnt_marital_status per_all_people_f.marital_status%TYPE;
625: g_elig_dpnt_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
626: g_elig_dpnt_student_status per_all_people_f.student_status%TYPE;
627: g_elig_dpnt_date_of_death per_all_people_f.date_of_death%TYPE;
628: g_elig_dpnt_elig_strt_dt ben_elig_dpnt.elig_strt_dt%TYPE;
629: g_elig_dpnt_elig_thru_dt ben_elig_dpnt.elig_thru_dt%TYPE;
630: g_elig_dpnt_create_dt ben_elig_dpnt.create_dt%TYPE;

Line 627: g_elig_dpnt_date_of_death per_all_people_f.date_of_death%TYPE;

623: g_elig_dpnt_date_of_birth per_all_people_f.date_of_birth%TYPE;
624: g_elig_dpnt_marital_status per_all_people_f.marital_status%TYPE;
625: g_elig_dpnt_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
626: g_elig_dpnt_student_status per_all_people_f.student_status%TYPE;
627: g_elig_dpnt_date_of_death per_all_people_f.date_of_death%TYPE;
628: g_elig_dpnt_elig_strt_dt ben_elig_dpnt.elig_strt_dt%TYPE;
629: g_elig_dpnt_elig_thru_dt ben_elig_dpnt.elig_thru_dt%TYPE;
630: g_elig_dpnt_create_dt ben_elig_dpnt.create_dt%TYPE;
631: g_elig_dpnt_ovrdn_flag ben_elig_dpnt.ovrdn_flag%TYPE;

Line 633: g_elig_dpnt_nationality per_all_people_f.nationality%TYPE;

629: g_elig_dpnt_elig_thru_dt ben_elig_dpnt.elig_thru_dt%TYPE;
630: g_elig_dpnt_create_dt ben_elig_dpnt.create_dt%TYPE;
631: g_elig_dpnt_ovrdn_flag ben_elig_dpnt.ovrdn_flag%TYPE;
632: g_elig_dpnt_ovrdn_thru_dt ben_elig_dpnt.ovrdn_thru_dt%TYPE;
633: g_elig_dpnt_nationality per_all_people_f.nationality%TYPE;
634: g_elig_dpnt_language per_all_people_f.correspondence_language%TYPE;
635: g_elig_dpnt_email_address per_all_people_f.email_address%TYPE;
636: g_elig_dpnt_known_as per_all_people_f.known_as%TYPE;
637: g_elig_dpnt_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;

Line 634: g_elig_dpnt_language per_all_people_f.correspondence_language%TYPE;

630: g_elig_dpnt_create_dt ben_elig_dpnt.create_dt%TYPE;
631: g_elig_dpnt_ovrdn_flag ben_elig_dpnt.ovrdn_flag%TYPE;
632: g_elig_dpnt_ovrdn_thru_dt ben_elig_dpnt.ovrdn_thru_dt%TYPE;
633: g_elig_dpnt_nationality per_all_people_f.nationality%TYPE;
634: g_elig_dpnt_language per_all_people_f.correspondence_language%TYPE;
635: g_elig_dpnt_email_address per_all_people_f.email_address%TYPE;
636: g_elig_dpnt_known_as per_all_people_f.known_as%TYPE;
637: g_elig_dpnt_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
638: g_elig_dpnt_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;

Line 635: g_elig_dpnt_email_address per_all_people_f.email_address%TYPE;

631: g_elig_dpnt_ovrdn_flag ben_elig_dpnt.ovrdn_flag%TYPE;
632: g_elig_dpnt_ovrdn_thru_dt ben_elig_dpnt.ovrdn_thru_dt%TYPE;
633: g_elig_dpnt_nationality per_all_people_f.nationality%TYPE;
634: g_elig_dpnt_language per_all_people_f.correspondence_language%TYPE;
635: g_elig_dpnt_email_address per_all_people_f.email_address%TYPE;
636: g_elig_dpnt_known_as per_all_people_f.known_as%TYPE;
637: g_elig_dpnt_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
638: g_elig_dpnt_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
639: g_elig_dpnt_prev_last_name per_all_people_f.last_name%TYPE;

Line 636: g_elig_dpnt_known_as per_all_people_f.known_as%TYPE;

632: g_elig_dpnt_ovrdn_thru_dt ben_elig_dpnt.ovrdn_thru_dt%TYPE;
633: g_elig_dpnt_nationality per_all_people_f.nationality%TYPE;
634: g_elig_dpnt_language per_all_people_f.correspondence_language%TYPE;
635: g_elig_dpnt_email_address per_all_people_f.email_address%TYPE;
636: g_elig_dpnt_known_as per_all_people_f.known_as%TYPE;
637: g_elig_dpnt_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
638: g_elig_dpnt_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
639: g_elig_dpnt_prev_last_name per_all_people_f.last_name%TYPE;
640: g_elig_dpnt_prim_address1 per_addresses.address_line1%TYPE;

Line 637: g_elig_dpnt_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;

633: g_elig_dpnt_nationality per_all_people_f.nationality%TYPE;
634: g_elig_dpnt_language per_all_people_f.correspondence_language%TYPE;
635: g_elig_dpnt_email_address per_all_people_f.email_address%TYPE;
636: g_elig_dpnt_known_as per_all_people_f.known_as%TYPE;
637: g_elig_dpnt_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
638: g_elig_dpnt_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
639: g_elig_dpnt_prev_last_name per_all_people_f.last_name%TYPE;
640: g_elig_dpnt_prim_address1 per_addresses.address_line1%TYPE;
641: g_elig_dpnt_prim_address2 per_addresses.address_line2%TYPE;

Line 638: g_elig_dpnt_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;

634: g_elig_dpnt_language per_all_people_f.correspondence_language%TYPE;
635: g_elig_dpnt_email_address per_all_people_f.email_address%TYPE;
636: g_elig_dpnt_known_as per_all_people_f.known_as%TYPE;
637: g_elig_dpnt_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
638: g_elig_dpnt_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
639: g_elig_dpnt_prev_last_name per_all_people_f.last_name%TYPE;
640: g_elig_dpnt_prim_address1 per_addresses.address_line1%TYPE;
641: g_elig_dpnt_prim_address2 per_addresses.address_line2%TYPE;
642: g_elig_dpnt_prim_address3 per_addresses.address_line3%TYPE;

Line 639: g_elig_dpnt_prev_last_name per_all_people_f.last_name%TYPE;

635: g_elig_dpnt_email_address per_all_people_f.email_address%TYPE;
636: g_elig_dpnt_known_as per_all_people_f.known_as%TYPE;
637: g_elig_dpnt_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
638: g_elig_dpnt_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
639: g_elig_dpnt_prev_last_name per_all_people_f.last_name%TYPE;
640: g_elig_dpnt_prim_address1 per_addresses.address_line1%TYPE;
641: g_elig_dpnt_prim_address2 per_addresses.address_line2%TYPE;
642: g_elig_dpnt_prim_address3 per_addresses.address_line3%TYPE;
643: g_elig_dpnt_prim_city per_addresses.town_or_city%TYPE;

Line 657: g_contact_national_ident per_all_people_f.national_identifier%TYPE;

653: g_elig_dpnt_id ben_elig_dpnt.elig_dpnt_id%TYPE;
654: --
655: -- contacts
656: --
657: g_contact_national_ident per_all_people_f.national_identifier%TYPE;
658: g_contact_last_name per_all_people_f.last_name%TYPE;
659: g_contact_first_name per_all_people_f.first_name%TYPE;
660: g_contact_middle_names per_all_people_f.middle_names%TYPE;
661: g_contact_full_name per_all_people_f.full_name%TYPE;

Line 658: g_contact_last_name per_all_people_f.last_name%TYPE;

654: --
655: -- contacts
656: --
657: g_contact_national_ident per_all_people_f.national_identifier%TYPE;
658: g_contact_last_name per_all_people_f.last_name%TYPE;
659: g_contact_first_name per_all_people_f.first_name%TYPE;
660: g_contact_middle_names per_all_people_f.middle_names%TYPE;
661: g_contact_full_name per_all_people_f.full_name%TYPE;
662: g_contact_suffix per_all_people_f.suffix%TYPE;

Line 659: g_contact_first_name per_all_people_f.first_name%TYPE;

655: -- contacts
656: --
657: g_contact_national_ident per_all_people_f.national_identifier%TYPE;
658: g_contact_last_name per_all_people_f.last_name%TYPE;
659: g_contact_first_name per_all_people_f.first_name%TYPE;
660: g_contact_middle_names per_all_people_f.middle_names%TYPE;
661: g_contact_full_name per_all_people_f.full_name%TYPE;
662: g_contact_suffix per_all_people_f.suffix%TYPE;
663: g_contact_prefix per_all_people_f.pre_name_adjunct%TYPE;

Line 660: g_contact_middle_names per_all_people_f.middle_names%TYPE;

656: --
657: g_contact_national_ident per_all_people_f.national_identifier%TYPE;
658: g_contact_last_name per_all_people_f.last_name%TYPE;
659: g_contact_first_name per_all_people_f.first_name%TYPE;
660: g_contact_middle_names per_all_people_f.middle_names%TYPE;
661: g_contact_full_name per_all_people_f.full_name%TYPE;
662: g_contact_suffix per_all_people_f.suffix%TYPE;
663: g_contact_prefix per_all_people_f.pre_name_adjunct%TYPE;
664: g_contact_title per_all_people_f.title%TYPE;

Line 661: g_contact_full_name per_all_people_f.full_name%TYPE;

657: g_contact_national_ident per_all_people_f.national_identifier%TYPE;
658: g_contact_last_name per_all_people_f.last_name%TYPE;
659: g_contact_first_name per_all_people_f.first_name%TYPE;
660: g_contact_middle_names per_all_people_f.middle_names%TYPE;
661: g_contact_full_name per_all_people_f.full_name%TYPE;
662: g_contact_suffix per_all_people_f.suffix%TYPE;
663: g_contact_prefix per_all_people_f.pre_name_adjunct%TYPE;
664: g_contact_title per_all_people_f.title%TYPE;
665: g_contact_sex per_all_people_f.sex%TYPE;

Line 662: g_contact_suffix per_all_people_f.suffix%TYPE;

658: g_contact_last_name per_all_people_f.last_name%TYPE;
659: g_contact_first_name per_all_people_f.first_name%TYPE;
660: g_contact_middle_names per_all_people_f.middle_names%TYPE;
661: g_contact_full_name per_all_people_f.full_name%TYPE;
662: g_contact_suffix per_all_people_f.suffix%TYPE;
663: g_contact_prefix per_all_people_f.pre_name_adjunct%TYPE;
664: g_contact_title per_all_people_f.title%TYPE;
665: g_contact_sex per_all_people_f.sex%TYPE;
666: g_contact_date_of_birth per_all_people_f.date_of_birth%TYPE;

Line 663: g_contact_prefix per_all_people_f.pre_name_adjunct%TYPE;

659: g_contact_first_name per_all_people_f.first_name%TYPE;
660: g_contact_middle_names per_all_people_f.middle_names%TYPE;
661: g_contact_full_name per_all_people_f.full_name%TYPE;
662: g_contact_suffix per_all_people_f.suffix%TYPE;
663: g_contact_prefix per_all_people_f.pre_name_adjunct%TYPE;
664: g_contact_title per_all_people_f.title%TYPE;
665: g_contact_sex per_all_people_f.sex%TYPE;
666: g_contact_date_of_birth per_all_people_f.date_of_birth%TYPE;
667: g_contact_marital_status per_all_people_f.marital_status%TYPE;

Line 664: g_contact_title per_all_people_f.title%TYPE;

660: g_contact_middle_names per_all_people_f.middle_names%TYPE;
661: g_contact_full_name per_all_people_f.full_name%TYPE;
662: g_contact_suffix per_all_people_f.suffix%TYPE;
663: g_contact_prefix per_all_people_f.pre_name_adjunct%TYPE;
664: g_contact_title per_all_people_f.title%TYPE;
665: g_contact_sex per_all_people_f.sex%TYPE;
666: g_contact_date_of_birth per_all_people_f.date_of_birth%TYPE;
667: g_contact_marital_status per_all_people_f.marital_status%TYPE;
668: g_contact_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;

Line 665: g_contact_sex per_all_people_f.sex%TYPE;

661: g_contact_full_name per_all_people_f.full_name%TYPE;
662: g_contact_suffix per_all_people_f.suffix%TYPE;
663: g_contact_prefix per_all_people_f.pre_name_adjunct%TYPE;
664: g_contact_title per_all_people_f.title%TYPE;
665: g_contact_sex per_all_people_f.sex%TYPE;
666: g_contact_date_of_birth per_all_people_f.date_of_birth%TYPE;
667: g_contact_marital_status per_all_people_f.marital_status%TYPE;
668: g_contact_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
669: g_contact_student_status per_all_people_f.student_status%TYPE;

Line 666: g_contact_date_of_birth per_all_people_f.date_of_birth%TYPE;

662: g_contact_suffix per_all_people_f.suffix%TYPE;
663: g_contact_prefix per_all_people_f.pre_name_adjunct%TYPE;
664: g_contact_title per_all_people_f.title%TYPE;
665: g_contact_sex per_all_people_f.sex%TYPE;
666: g_contact_date_of_birth per_all_people_f.date_of_birth%TYPE;
667: g_contact_marital_status per_all_people_f.marital_status%TYPE;
668: g_contact_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
669: g_contact_student_status per_all_people_f.student_status%TYPE;
670: g_contact_date_of_death per_all_people_f.date_of_death%TYPE;

Line 667: g_contact_marital_status per_all_people_f.marital_status%TYPE;

663: g_contact_prefix per_all_people_f.pre_name_adjunct%TYPE;
664: g_contact_title per_all_people_f.title%TYPE;
665: g_contact_sex per_all_people_f.sex%TYPE;
666: g_contact_date_of_birth per_all_people_f.date_of_birth%TYPE;
667: g_contact_marital_status per_all_people_f.marital_status%TYPE;
668: g_contact_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
669: g_contact_student_status per_all_people_f.student_status%TYPE;
670: g_contact_date_of_death per_all_people_f.date_of_death%TYPE;
671: g_contact_nationality per_all_people_f.nationality%TYPE;

Line 668: g_contact_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;

664: g_contact_title per_all_people_f.title%TYPE;
665: g_contact_sex per_all_people_f.sex%TYPE;
666: g_contact_date_of_birth per_all_people_f.date_of_birth%TYPE;
667: g_contact_marital_status per_all_people_f.marital_status%TYPE;
668: g_contact_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
669: g_contact_student_status per_all_people_f.student_status%TYPE;
670: g_contact_date_of_death per_all_people_f.date_of_death%TYPE;
671: g_contact_nationality per_all_people_f.nationality%TYPE;
672: g_contact_language per_all_people_f.correspondence_language%TYPE;

Line 669: g_contact_student_status per_all_people_f.student_status%TYPE;

665: g_contact_sex per_all_people_f.sex%TYPE;
666: g_contact_date_of_birth per_all_people_f.date_of_birth%TYPE;
667: g_contact_marital_status per_all_people_f.marital_status%TYPE;
668: g_contact_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
669: g_contact_student_status per_all_people_f.student_status%TYPE;
670: g_contact_date_of_death per_all_people_f.date_of_death%TYPE;
671: g_contact_nationality per_all_people_f.nationality%TYPE;
672: g_contact_language per_all_people_f.correspondence_language%TYPE;
673: g_contact_email_address per_all_people_f.email_address%TYPE;

Line 670: g_contact_date_of_death per_all_people_f.date_of_death%TYPE;

666: g_contact_date_of_birth per_all_people_f.date_of_birth%TYPE;
667: g_contact_marital_status per_all_people_f.marital_status%TYPE;
668: g_contact_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
669: g_contact_student_status per_all_people_f.student_status%TYPE;
670: g_contact_date_of_death per_all_people_f.date_of_death%TYPE;
671: g_contact_nationality per_all_people_f.nationality%TYPE;
672: g_contact_language per_all_people_f.correspondence_language%TYPE;
673: g_contact_email_address per_all_people_f.email_address%TYPE;
674: g_contact_known_as per_all_people_f.known_as%TYPE;

Line 671: g_contact_nationality per_all_people_f.nationality%TYPE;

667: g_contact_marital_status per_all_people_f.marital_status%TYPE;
668: g_contact_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
669: g_contact_student_status per_all_people_f.student_status%TYPE;
670: g_contact_date_of_death per_all_people_f.date_of_death%TYPE;
671: g_contact_nationality per_all_people_f.nationality%TYPE;
672: g_contact_language per_all_people_f.correspondence_language%TYPE;
673: g_contact_email_address per_all_people_f.email_address%TYPE;
674: g_contact_known_as per_all_people_f.known_as%TYPE;
675: g_contact_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;

Line 672: g_contact_language per_all_people_f.correspondence_language%TYPE;

668: g_contact_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
669: g_contact_student_status per_all_people_f.student_status%TYPE;
670: g_contact_date_of_death per_all_people_f.date_of_death%TYPE;
671: g_contact_nationality per_all_people_f.nationality%TYPE;
672: g_contact_language per_all_people_f.correspondence_language%TYPE;
673: g_contact_email_address per_all_people_f.email_address%TYPE;
674: g_contact_known_as per_all_people_f.known_as%TYPE;
675: g_contact_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
676: g_contact_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;

Line 673: g_contact_email_address per_all_people_f.email_address%TYPE;

669: g_contact_student_status per_all_people_f.student_status%TYPE;
670: g_contact_date_of_death per_all_people_f.date_of_death%TYPE;
671: g_contact_nationality per_all_people_f.nationality%TYPE;
672: g_contact_language per_all_people_f.correspondence_language%TYPE;
673: g_contact_email_address per_all_people_f.email_address%TYPE;
674: g_contact_known_as per_all_people_f.known_as%TYPE;
675: g_contact_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
676: g_contact_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
677: g_contact_prev_last_name per_all_people_f.last_name%TYPE;

Line 674: g_contact_known_as per_all_people_f.known_as%TYPE;

670: g_contact_date_of_death per_all_people_f.date_of_death%TYPE;
671: g_contact_nationality per_all_people_f.nationality%TYPE;
672: g_contact_language per_all_people_f.correspondence_language%TYPE;
673: g_contact_email_address per_all_people_f.email_address%TYPE;
674: g_contact_known_as per_all_people_f.known_as%TYPE;
675: g_contact_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
676: g_contact_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
677: g_contact_prev_last_name per_all_people_f.last_name%TYPE;
678: g_contact_prim_address1 per_addresses.address_line1%TYPE;

Line 675: g_contact_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;

671: g_contact_nationality per_all_people_f.nationality%TYPE;
672: g_contact_language per_all_people_f.correspondence_language%TYPE;
673: g_contact_email_address per_all_people_f.email_address%TYPE;
674: g_contact_known_as per_all_people_f.known_as%TYPE;
675: g_contact_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
676: g_contact_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
677: g_contact_prev_last_name per_all_people_f.last_name%TYPE;
678: g_contact_prim_address1 per_addresses.address_line1%TYPE;
679: g_contact_prim_address2 per_addresses.address_line2%TYPE;

Line 676: g_contact_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;

672: g_contact_language per_all_people_f.correspondence_language%TYPE;
673: g_contact_email_address per_all_people_f.email_address%TYPE;
674: g_contact_known_as per_all_people_f.known_as%TYPE;
675: g_contact_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
676: g_contact_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
677: g_contact_prev_last_name per_all_people_f.last_name%TYPE;
678: g_contact_prim_address1 per_addresses.address_line1%TYPE;
679: g_contact_prim_address2 per_addresses.address_line2%TYPE;
680: g_contact_prim_address3 per_addresses.address_line3%TYPE;

Line 677: g_contact_prev_last_name per_all_people_f.last_name%TYPE;

673: g_contact_email_address per_all_people_f.email_address%TYPE;
674: g_contact_known_as per_all_people_f.known_as%TYPE;
675: g_contact_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
676: g_contact_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
677: g_contact_prev_last_name per_all_people_f.last_name%TYPE;
678: g_contact_prim_address1 per_addresses.address_line1%TYPE;
679: g_contact_prim_address2 per_addresses.address_line2%TYPE;
680: g_contact_prim_address3 per_addresses.address_line3%TYPE;
681: g_contact_prim_city per_addresses.town_or_city%TYPE;

Line 965: g_bnf_ssn per_all_people_f.national_identifier%TYPE;

961:
962: --
963: -- beneficiary
964: --
965: g_bnf_ssn per_all_people_f.national_identifier%TYPE;
966: g_bnf_lst_nm per_all_people_f.last_name%TYPE;
967: g_bnf_fst_nm per_all_people_f.first_name%TYPE;
968: g_bnf_mid_nm per_all_people_f.middle_names%TYPE;
969: g_bnf_fl_nm per_all_people_f.full_name%TYPE;

Line 966: g_bnf_lst_nm per_all_people_f.last_name%TYPE;

962: --
963: -- beneficiary
964: --
965: g_bnf_ssn per_all_people_f.national_identifier%TYPE;
966: g_bnf_lst_nm per_all_people_f.last_name%TYPE;
967: g_bnf_fst_nm per_all_people_f.first_name%TYPE;
968: g_bnf_mid_nm per_all_people_f.middle_names%TYPE;
969: g_bnf_fl_nm per_all_people_f.full_name%TYPE;
970: g_bnf_suffix per_all_people_f.suffix%TYPE;

Line 967: g_bnf_fst_nm per_all_people_f.first_name%TYPE;

963: -- beneficiary
964: --
965: g_bnf_ssn per_all_people_f.national_identifier%TYPE;
966: g_bnf_lst_nm per_all_people_f.last_name%TYPE;
967: g_bnf_fst_nm per_all_people_f.first_name%TYPE;
968: g_bnf_mid_nm per_all_people_f.middle_names%TYPE;
969: g_bnf_fl_nm per_all_people_f.full_name%TYPE;
970: g_bnf_suffix per_all_people_f.suffix%TYPE;
971: g_bnf_prefix per_all_people_f.pre_name_adjunct%TYPE;

Line 968: g_bnf_mid_nm per_all_people_f.middle_names%TYPE;

964: --
965: g_bnf_ssn per_all_people_f.national_identifier%TYPE;
966: g_bnf_lst_nm per_all_people_f.last_name%TYPE;
967: g_bnf_fst_nm per_all_people_f.first_name%TYPE;
968: g_bnf_mid_nm per_all_people_f.middle_names%TYPE;
969: g_bnf_fl_nm per_all_people_f.full_name%TYPE;
970: g_bnf_suffix per_all_people_f.suffix%TYPE;
971: g_bnf_prefix per_all_people_f.pre_name_adjunct%TYPE;
972: g_bnf_title per_all_people_f.title%TYPE;

Line 969: g_bnf_fl_nm per_all_people_f.full_name%TYPE;

965: g_bnf_ssn per_all_people_f.national_identifier%TYPE;
966: g_bnf_lst_nm per_all_people_f.last_name%TYPE;
967: g_bnf_fst_nm per_all_people_f.first_name%TYPE;
968: g_bnf_mid_nm per_all_people_f.middle_names%TYPE;
969: g_bnf_fl_nm per_all_people_f.full_name%TYPE;
970: g_bnf_suffix per_all_people_f.suffix%TYPE;
971: g_bnf_prefix per_all_people_f.pre_name_adjunct%TYPE;
972: g_bnf_title per_all_people_f.title%TYPE;
973: g_bnf_prv_lst_nm per_all_people_f.previous_last_name%TYPE;

Line 970: g_bnf_suffix per_all_people_f.suffix%TYPE;

966: g_bnf_lst_nm per_all_people_f.last_name%TYPE;
967: g_bnf_fst_nm per_all_people_f.first_name%TYPE;
968: g_bnf_mid_nm per_all_people_f.middle_names%TYPE;
969: g_bnf_fl_nm per_all_people_f.full_name%TYPE;
970: g_bnf_suffix per_all_people_f.suffix%TYPE;
971: g_bnf_prefix per_all_people_f.pre_name_adjunct%TYPE;
972: g_bnf_title per_all_people_f.title%TYPE;
973: g_bnf_prv_lst_nm per_all_people_f.previous_last_name%TYPE;
974: g_bnf_pre_nm_adjunct per_all_people_f.pre_name_adjunct%TYPE;

Line 971: g_bnf_prefix per_all_people_f.pre_name_adjunct%TYPE;

967: g_bnf_fst_nm per_all_people_f.first_name%TYPE;
968: g_bnf_mid_nm per_all_people_f.middle_names%TYPE;
969: g_bnf_fl_nm per_all_people_f.full_name%TYPE;
970: g_bnf_suffix per_all_people_f.suffix%TYPE;
971: g_bnf_prefix per_all_people_f.pre_name_adjunct%TYPE;
972: g_bnf_title per_all_people_f.title%TYPE;
973: g_bnf_prv_lst_nm per_all_people_f.previous_last_name%TYPE;
974: g_bnf_pre_nm_adjunct per_all_people_f.pre_name_adjunct%TYPE;
975: g_bnf_email_address per_all_people_f.email_address%TYPE;

Line 972: g_bnf_title per_all_people_f.title%TYPE;

968: g_bnf_mid_nm per_all_people_f.middle_names%TYPE;
969: g_bnf_fl_nm per_all_people_f.full_name%TYPE;
970: g_bnf_suffix per_all_people_f.suffix%TYPE;
971: g_bnf_prefix per_all_people_f.pre_name_adjunct%TYPE;
972: g_bnf_title per_all_people_f.title%TYPE;
973: g_bnf_prv_lst_nm per_all_people_f.previous_last_name%TYPE;
974: g_bnf_pre_nm_adjunct per_all_people_f.pre_name_adjunct%TYPE;
975: g_bnf_email_address per_all_people_f.email_address%TYPE;
976: g_bnf_known_as per_all_people_f.known_as%TYPE;

Line 973: g_bnf_prv_lst_nm per_all_people_f.previous_last_name%TYPE;

969: g_bnf_fl_nm per_all_people_f.full_name%TYPE;
970: g_bnf_suffix per_all_people_f.suffix%TYPE;
971: g_bnf_prefix per_all_people_f.pre_name_adjunct%TYPE;
972: g_bnf_title per_all_people_f.title%TYPE;
973: g_bnf_prv_lst_nm per_all_people_f.previous_last_name%TYPE;
974: g_bnf_pre_nm_adjunct per_all_people_f.pre_name_adjunct%TYPE;
975: g_bnf_email_address per_all_people_f.email_address%TYPE;
976: g_bnf_known_as per_all_people_f.known_as%TYPE;
977: g_bnf_nationality per_all_people_f.nationality%TYPE;

Line 974: g_bnf_pre_nm_adjunct per_all_people_f.pre_name_adjunct%TYPE;

970: g_bnf_suffix per_all_people_f.suffix%TYPE;
971: g_bnf_prefix per_all_people_f.pre_name_adjunct%TYPE;
972: g_bnf_title per_all_people_f.title%TYPE;
973: g_bnf_prv_lst_nm per_all_people_f.previous_last_name%TYPE;
974: g_bnf_pre_nm_adjunct per_all_people_f.pre_name_adjunct%TYPE;
975: g_bnf_email_address per_all_people_f.email_address%TYPE;
976: g_bnf_known_as per_all_people_f.known_as%TYPE;
977: g_bnf_nationality per_all_people_f.nationality%TYPE;
978: g_bnf_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;

Line 975: g_bnf_email_address per_all_people_f.email_address%TYPE;

971: g_bnf_prefix per_all_people_f.pre_name_adjunct%TYPE;
972: g_bnf_title per_all_people_f.title%TYPE;
973: g_bnf_prv_lst_nm per_all_people_f.previous_last_name%TYPE;
974: g_bnf_pre_nm_adjunct per_all_people_f.pre_name_adjunct%TYPE;
975: g_bnf_email_address per_all_people_f.email_address%TYPE;
976: g_bnf_known_as per_all_people_f.known_as%TYPE;
977: g_bnf_nationality per_all_people_f.nationality%TYPE;
978: g_bnf_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
979: g_bnf_language per_all_people_f.correspondence_language%TYPE;

Line 976: g_bnf_known_as per_all_people_f.known_as%TYPE;

972: g_bnf_title per_all_people_f.title%TYPE;
973: g_bnf_prv_lst_nm per_all_people_f.previous_last_name%TYPE;
974: g_bnf_pre_nm_adjunct per_all_people_f.pre_name_adjunct%TYPE;
975: g_bnf_email_address per_all_people_f.email_address%TYPE;
976: g_bnf_known_as per_all_people_f.known_as%TYPE;
977: g_bnf_nationality per_all_people_f.nationality%TYPE;
978: g_bnf_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
979: g_bnf_language per_all_people_f.correspondence_language%TYPE;
980: g_bnf_prim_address1 per_addresses.address_line1%TYPE;

Line 977: g_bnf_nationality per_all_people_f.nationality%TYPE;

973: g_bnf_prv_lst_nm per_all_people_f.previous_last_name%TYPE;
974: g_bnf_pre_nm_adjunct per_all_people_f.pre_name_adjunct%TYPE;
975: g_bnf_email_address per_all_people_f.email_address%TYPE;
976: g_bnf_known_as per_all_people_f.known_as%TYPE;
977: g_bnf_nationality per_all_people_f.nationality%TYPE;
978: g_bnf_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
979: g_bnf_language per_all_people_f.correspondence_language%TYPE;
980: g_bnf_prim_address1 per_addresses.address_line1%TYPE;
981: g_bnf_prim_address2 per_addresses.address_line2%TYPE;

Line 978: g_bnf_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;

974: g_bnf_pre_nm_adjunct per_all_people_f.pre_name_adjunct%TYPE;
975: g_bnf_email_address per_all_people_f.email_address%TYPE;
976: g_bnf_known_as per_all_people_f.known_as%TYPE;
977: g_bnf_nationality per_all_people_f.nationality%TYPE;
978: g_bnf_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
979: g_bnf_language per_all_people_f.correspondence_language%TYPE;
980: g_bnf_prim_address1 per_addresses.address_line1%TYPE;
981: g_bnf_prim_address2 per_addresses.address_line2%TYPE;
982: g_bnf_prim_address3 per_addresses.address_line3%TYPE;

Line 979: g_bnf_language per_all_people_f.correspondence_language%TYPE;

975: g_bnf_email_address per_all_people_f.email_address%TYPE;
976: g_bnf_known_as per_all_people_f.known_as%TYPE;
977: g_bnf_nationality per_all_people_f.nationality%TYPE;
978: g_bnf_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
979: g_bnf_language per_all_people_f.correspondence_language%TYPE;
980: g_bnf_prim_address1 per_addresses.address_line1%TYPE;
981: g_bnf_prim_address2 per_addresses.address_line2%TYPE;
982: g_bnf_prim_address3 per_addresses.address_line3%TYPE;
983: g_bnf_prim_city per_addresses.town_or_city%TYPE;

Line 989: g_bnf_gender per_all_people_f.sex%TYPE;

985: g_bnf_prim_postal_code per_addresses.postal_code%TYPE;
986: g_bnf_prim_country per_addresses.country%TYPE;
987: g_bnf_prim_effect_date per_addresses.date_from%TYPE;
988: g_bnf_prim_region per_addresses.region_3%TYPE;
989: g_bnf_gender per_all_people_f.sex%TYPE;
990: g_bnf_date_of_birth per_all_people_f.date_of_birth%TYPE;
991: g_bnf_marital_status per_all_people_f.marital_status%TYPE;
992: g_bnf_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
993: g_bnf_student_status per_all_people_f.student_status%TYPE;

Line 990: g_bnf_date_of_birth per_all_people_f.date_of_birth%TYPE;

986: g_bnf_prim_country per_addresses.country%TYPE;
987: g_bnf_prim_effect_date per_addresses.date_from%TYPE;
988: g_bnf_prim_region per_addresses.region_3%TYPE;
989: g_bnf_gender per_all_people_f.sex%TYPE;
990: g_bnf_date_of_birth per_all_people_f.date_of_birth%TYPE;
991: g_bnf_marital_status per_all_people_f.marital_status%TYPE;
992: g_bnf_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
993: g_bnf_student_status per_all_people_f.student_status%TYPE;
994: g_bnf_date_of_death per_all_people_f.date_of_death%TYPE;

Line 991: g_bnf_marital_status per_all_people_f.marital_status%TYPE;

987: g_bnf_prim_effect_date per_addresses.date_from%TYPE;
988: g_bnf_prim_region per_addresses.region_3%TYPE;
989: g_bnf_gender per_all_people_f.sex%TYPE;
990: g_bnf_date_of_birth per_all_people_f.date_of_birth%TYPE;
991: g_bnf_marital_status per_all_people_f.marital_status%TYPE;
992: g_bnf_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
993: g_bnf_student_status per_all_people_f.student_status%TYPE;
994: g_bnf_date_of_death per_all_people_f.date_of_death%TYPE;
995: g_bnf_prmy_cont ben_pl_bnf_f.prmry_cntngnt_cd%TYPE;

Line 992: g_bnf_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;

988: g_bnf_prim_region per_addresses.region_3%TYPE;
989: g_bnf_gender per_all_people_f.sex%TYPE;
990: g_bnf_date_of_birth per_all_people_f.date_of_birth%TYPE;
991: g_bnf_marital_status per_all_people_f.marital_status%TYPE;
992: g_bnf_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
993: g_bnf_student_status per_all_people_f.student_status%TYPE;
994: g_bnf_date_of_death per_all_people_f.date_of_death%TYPE;
995: g_bnf_prmy_cont ben_pl_bnf_f.prmry_cntngnt_cd%TYPE;
996: g_bnf_pct_dsgd ben_pl_bnf_f.pct_dsgd_num%TYPE;

Line 993: g_bnf_student_status per_all_people_f.student_status%TYPE;

989: g_bnf_gender per_all_people_f.sex%TYPE;
990: g_bnf_date_of_birth per_all_people_f.date_of_birth%TYPE;
991: g_bnf_marital_status per_all_people_f.marital_status%TYPE;
992: g_bnf_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
993: g_bnf_student_status per_all_people_f.student_status%TYPE;
994: g_bnf_date_of_death per_all_people_f.date_of_death%TYPE;
995: g_bnf_prmy_cont ben_pl_bnf_f.prmry_cntngnt_cd%TYPE;
996: g_bnf_pct_dsgd ben_pl_bnf_f.pct_dsgd_num%TYPE;
997: g_bnf_amt_dsgd ben_pl_bnf_f.amt_dsgd_val%TYPE;

Line 994: g_bnf_date_of_death per_all_people_f.date_of_death%TYPE;

990: g_bnf_date_of_birth per_all_people_f.date_of_birth%TYPE;
991: g_bnf_marital_status per_all_people_f.marital_status%TYPE;
992: g_bnf_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;
993: g_bnf_student_status per_all_people_f.student_status%TYPE;
994: g_bnf_date_of_death per_all_people_f.date_of_death%TYPE;
995: g_bnf_prmy_cont ben_pl_bnf_f.prmry_cntngnt_cd%TYPE;
996: g_bnf_pct_dsgd ben_pl_bnf_f.pct_dsgd_num%TYPE;
997: g_bnf_amt_dsgd ben_pl_bnf_f.amt_dsgd_val%TYPE;
998: g_bnf_amt_uom ben_pl_bnf_f.amt_dsgd_uom%TYPE;