APPS.BEN_EXT_CHLG dependencies on PER_ALL_PEOPLE_F

Line 76: (national_identifier per_all_people_f.national_identifier%type

72: g_prev_upd_adr_address_id per_addresses.address_id%type;
73: -- g_prev_upd_adr_last_update_login
74: --
75: Type g_per_rec_type is RECORD
76: (national_identifier per_all_people_f.national_identifier%type
77: ,full_name per_all_people_f.full_name%type
78: ,last_name per_all_people_f.last_name%type
79: ,first_name per_all_people_f.first_name%type
80: ,middle_names per_all_people_f.middle_names%type

Line 77: ,full_name per_all_people_f.full_name%type

73: -- g_prev_upd_adr_last_update_login
74: --
75: Type g_per_rec_type is RECORD
76: (national_identifier per_all_people_f.national_identifier%type
77: ,full_name per_all_people_f.full_name%type
78: ,last_name per_all_people_f.last_name%type
79: ,first_name per_all_people_f.first_name%type
80: ,middle_names per_all_people_f.middle_names%type
81: ,title per_all_people_f.title%type

Line 78: ,last_name per_all_people_f.last_name%type

74: --
75: Type g_per_rec_type is RECORD
76: (national_identifier per_all_people_f.national_identifier%type
77: ,full_name per_all_people_f.full_name%type
78: ,last_name per_all_people_f.last_name%type
79: ,first_name per_all_people_f.first_name%type
80: ,middle_names per_all_people_f.middle_names%type
81: ,title per_all_people_f.title%type
82: ,pre_name_adjunct per_all_people_f.pre_name_adjunct%type

Line 79: ,first_name per_all_people_f.first_name%type

75: Type g_per_rec_type is RECORD
76: (national_identifier per_all_people_f.national_identifier%type
77: ,full_name per_all_people_f.full_name%type
78: ,last_name per_all_people_f.last_name%type
79: ,first_name per_all_people_f.first_name%type
80: ,middle_names per_all_people_f.middle_names%type
81: ,title per_all_people_f.title%type
82: ,pre_name_adjunct per_all_people_f.pre_name_adjunct%type
83: ,suffix per_all_people_f.suffix%type

Line 80: ,middle_names per_all_people_f.middle_names%type

76: (national_identifier per_all_people_f.national_identifier%type
77: ,full_name per_all_people_f.full_name%type
78: ,last_name per_all_people_f.last_name%type
79: ,first_name per_all_people_f.first_name%type
80: ,middle_names per_all_people_f.middle_names%type
81: ,title per_all_people_f.title%type
82: ,pre_name_adjunct per_all_people_f.pre_name_adjunct%type
83: ,suffix per_all_people_f.suffix%type
84: ,known_as per_all_people_f.known_as%type

Line 81: ,title per_all_people_f.title%type

77: ,full_name per_all_people_f.full_name%type
78: ,last_name per_all_people_f.last_name%type
79: ,first_name per_all_people_f.first_name%type
80: ,middle_names per_all_people_f.middle_names%type
81: ,title per_all_people_f.title%type
82: ,pre_name_adjunct per_all_people_f.pre_name_adjunct%type
83: ,suffix per_all_people_f.suffix%type
84: ,known_as per_all_people_f.known_as%type
85: ,previous_last_name per_all_people_f.previous_last_name%type

Line 82: ,pre_name_adjunct per_all_people_f.pre_name_adjunct%type

78: ,last_name per_all_people_f.last_name%type
79: ,first_name per_all_people_f.first_name%type
80: ,middle_names per_all_people_f.middle_names%type
81: ,title per_all_people_f.title%type
82: ,pre_name_adjunct per_all_people_f.pre_name_adjunct%type
83: ,suffix per_all_people_f.suffix%type
84: ,known_as per_all_people_f.known_as%type
85: ,previous_last_name per_all_people_f.previous_last_name%type
86: ,date_of_birth per_all_people_f.date_of_birth%type

Line 83: ,suffix per_all_people_f.suffix%type

79: ,first_name per_all_people_f.first_name%type
80: ,middle_names per_all_people_f.middle_names%type
81: ,title per_all_people_f.title%type
82: ,pre_name_adjunct per_all_people_f.pre_name_adjunct%type
83: ,suffix per_all_people_f.suffix%type
84: ,known_as per_all_people_f.known_as%type
85: ,previous_last_name per_all_people_f.previous_last_name%type
86: ,date_of_birth per_all_people_f.date_of_birth%type
87: ,sex per_all_people_f.sex%type

Line 84: ,known_as per_all_people_f.known_as%type

80: ,middle_names per_all_people_f.middle_names%type
81: ,title per_all_people_f.title%type
82: ,pre_name_adjunct per_all_people_f.pre_name_adjunct%type
83: ,suffix per_all_people_f.suffix%type
84: ,known_as per_all_people_f.known_as%type
85: ,previous_last_name per_all_people_f.previous_last_name%type
86: ,date_of_birth per_all_people_f.date_of_birth%type
87: ,sex per_all_people_f.sex%type
88: ,marital_status per_all_people_f.marital_status%type

Line 85: ,previous_last_name per_all_people_f.previous_last_name%type

81: ,title per_all_people_f.title%type
82: ,pre_name_adjunct per_all_people_f.pre_name_adjunct%type
83: ,suffix per_all_people_f.suffix%type
84: ,known_as per_all_people_f.known_as%type
85: ,previous_last_name per_all_people_f.previous_last_name%type
86: ,date_of_birth per_all_people_f.date_of_birth%type
87: ,sex per_all_people_f.sex%type
88: ,marital_status per_all_people_f.marital_status%type
89: ,business_group_id per_all_people_f.business_group_id%type

Line 86: ,date_of_birth per_all_people_f.date_of_birth%type

82: ,pre_name_adjunct per_all_people_f.pre_name_adjunct%type
83: ,suffix per_all_people_f.suffix%type
84: ,known_as per_all_people_f.known_as%type
85: ,previous_last_name per_all_people_f.previous_last_name%type
86: ,date_of_birth per_all_people_f.date_of_birth%type
87: ,sex per_all_people_f.sex%type
88: ,marital_status per_all_people_f.marital_status%type
89: ,business_group_id per_all_people_f.business_group_id%type
90: ,person_id per_all_people_f.person_id%type

Line 87: ,sex per_all_people_f.sex%type

83: ,suffix per_all_people_f.suffix%type
84: ,known_as per_all_people_f.known_as%type
85: ,previous_last_name per_all_people_f.previous_last_name%type
86: ,date_of_birth per_all_people_f.date_of_birth%type
87: ,sex per_all_people_f.sex%type
88: ,marital_status per_all_people_f.marital_status%type
89: ,business_group_id per_all_people_f.business_group_id%type
90: ,person_id per_all_people_f.person_id%type
91: ,person_type_id per_all_people_f.person_type_id%type

Line 88: ,marital_status per_all_people_f.marital_status%type

84: ,known_as per_all_people_f.known_as%type
85: ,previous_last_name per_all_people_f.previous_last_name%type
86: ,date_of_birth per_all_people_f.date_of_birth%type
87: ,sex per_all_people_f.sex%type
88: ,marital_status per_all_people_f.marital_status%type
89: ,business_group_id per_all_people_f.business_group_id%type
90: ,person_id per_all_people_f.person_id%type
91: ,person_type_id per_all_people_f.person_type_id%type
92: ,registered_disabled_flag per_all_people_f.registered_disabled_flag%type

Line 89: ,business_group_id per_all_people_f.business_group_id%type

85: ,previous_last_name per_all_people_f.previous_last_name%type
86: ,date_of_birth per_all_people_f.date_of_birth%type
87: ,sex per_all_people_f.sex%type
88: ,marital_status per_all_people_f.marital_status%type
89: ,business_group_id per_all_people_f.business_group_id%type
90: ,person_id per_all_people_f.person_id%type
91: ,person_type_id per_all_people_f.person_type_id%type
92: ,registered_disabled_flag per_all_people_f.registered_disabled_flag%type
93: ,benefit_group_id per_all_people_f.benefit_group_id%type

Line 90: ,person_id per_all_people_f.person_id%type

86: ,date_of_birth per_all_people_f.date_of_birth%type
87: ,sex per_all_people_f.sex%type
88: ,marital_status per_all_people_f.marital_status%type
89: ,business_group_id per_all_people_f.business_group_id%type
90: ,person_id per_all_people_f.person_id%type
91: ,person_type_id per_all_people_f.person_type_id%type
92: ,registered_disabled_flag per_all_people_f.registered_disabled_flag%type
93: ,benefit_group_id per_all_people_f.benefit_group_id%type
94: ,student_status per_all_people_f.student_status%type

Line 91: ,person_type_id per_all_people_f.person_type_id%type

87: ,sex per_all_people_f.sex%type
88: ,marital_status per_all_people_f.marital_status%type
89: ,business_group_id per_all_people_f.business_group_id%type
90: ,person_id per_all_people_f.person_id%type
91: ,person_type_id per_all_people_f.person_type_id%type
92: ,registered_disabled_flag per_all_people_f.registered_disabled_flag%type
93: ,benefit_group_id per_all_people_f.benefit_group_id%type
94: ,student_status per_all_people_f.student_status%type
95: ,date_of_death per_all_people_f.date_of_death%type

Line 92: ,registered_disabled_flag per_all_people_f.registered_disabled_flag%type

88: ,marital_status per_all_people_f.marital_status%type
89: ,business_group_id per_all_people_f.business_group_id%type
90: ,person_id per_all_people_f.person_id%type
91: ,person_type_id per_all_people_f.person_type_id%type
92: ,registered_disabled_flag per_all_people_f.registered_disabled_flag%type
93: ,benefit_group_id per_all_people_f.benefit_group_id%type
94: ,student_status per_all_people_f.student_status%type
95: ,date_of_death per_all_people_f.date_of_death%type
96: ,date_employee_data_verified per_all_people_f.date_employee_data_verified%type

Line 93: ,benefit_group_id per_all_people_f.benefit_group_id%type

89: ,business_group_id per_all_people_f.business_group_id%type
90: ,person_id per_all_people_f.person_id%type
91: ,person_type_id per_all_people_f.person_type_id%type
92: ,registered_disabled_flag per_all_people_f.registered_disabled_flag%type
93: ,benefit_group_id per_all_people_f.benefit_group_id%type
94: ,student_status per_all_people_f.student_status%type
95: ,date_of_death per_all_people_f.date_of_death%type
96: ,date_employee_data_verified per_all_people_f.date_employee_data_verified%type
97: ,effective_start_date per_all_people_f.effective_start_date%type

Line 94: ,student_status per_all_people_f.student_status%type

90: ,person_id per_all_people_f.person_id%type
91: ,person_type_id per_all_people_f.person_type_id%type
92: ,registered_disabled_flag per_all_people_f.registered_disabled_flag%type
93: ,benefit_group_id per_all_people_f.benefit_group_id%type
94: ,student_status per_all_people_f.student_status%type
95: ,date_of_death per_all_people_f.date_of_death%type
96: ,date_employee_data_verified per_all_people_f.date_employee_data_verified%type
97: ,effective_start_date per_all_people_f.effective_start_date%type
98: ,effective_end_date per_all_people_f.effective_end_date%type

Line 95: ,date_of_death per_all_people_f.date_of_death%type

91: ,person_type_id per_all_people_f.person_type_id%type
92: ,registered_disabled_flag per_all_people_f.registered_disabled_flag%type
93: ,benefit_group_id per_all_people_f.benefit_group_id%type
94: ,student_status per_all_people_f.student_status%type
95: ,date_of_death per_all_people_f.date_of_death%type
96: ,date_employee_data_verified per_all_people_f.date_employee_data_verified%type
97: ,effective_start_date per_all_people_f.effective_start_date%type
98: ,effective_end_date per_all_people_f.effective_end_date%type
99: ,attribute1 per_all_people_f.attribute1%type

Line 96: ,date_employee_data_verified per_all_people_f.date_employee_data_verified%type

92: ,registered_disabled_flag per_all_people_f.registered_disabled_flag%type
93: ,benefit_group_id per_all_people_f.benefit_group_id%type
94: ,student_status per_all_people_f.student_status%type
95: ,date_of_death per_all_people_f.date_of_death%type
96: ,date_employee_data_verified per_all_people_f.date_employee_data_verified%type
97: ,effective_start_date per_all_people_f.effective_start_date%type
98: ,effective_end_date per_all_people_f.effective_end_date%type
99: ,attribute1 per_all_people_f.attribute1%type
100: ,attribute2 per_all_people_f.attribute2%type

Line 97: ,effective_start_date per_all_people_f.effective_start_date%type

93: ,benefit_group_id per_all_people_f.benefit_group_id%type
94: ,student_status per_all_people_f.student_status%type
95: ,date_of_death per_all_people_f.date_of_death%type
96: ,date_employee_data_verified per_all_people_f.date_employee_data_verified%type
97: ,effective_start_date per_all_people_f.effective_start_date%type
98: ,effective_end_date per_all_people_f.effective_end_date%type
99: ,attribute1 per_all_people_f.attribute1%type
100: ,attribute2 per_all_people_f.attribute2%type
101: ,attribute3 per_all_people_f.attribute3%type

Line 98: ,effective_end_date per_all_people_f.effective_end_date%type

94: ,student_status per_all_people_f.student_status%type
95: ,date_of_death per_all_people_f.date_of_death%type
96: ,date_employee_data_verified per_all_people_f.date_employee_data_verified%type
97: ,effective_start_date per_all_people_f.effective_start_date%type
98: ,effective_end_date per_all_people_f.effective_end_date%type
99: ,attribute1 per_all_people_f.attribute1%type
100: ,attribute2 per_all_people_f.attribute2%type
101: ,attribute3 per_all_people_f.attribute3%type
102: ,attribute4 per_all_people_f.attribute4%type

Line 99: ,attribute1 per_all_people_f.attribute1%type

95: ,date_of_death per_all_people_f.date_of_death%type
96: ,date_employee_data_verified per_all_people_f.date_employee_data_verified%type
97: ,effective_start_date per_all_people_f.effective_start_date%type
98: ,effective_end_date per_all_people_f.effective_end_date%type
99: ,attribute1 per_all_people_f.attribute1%type
100: ,attribute2 per_all_people_f.attribute2%type
101: ,attribute3 per_all_people_f.attribute3%type
102: ,attribute4 per_all_people_f.attribute4%type
103: ,attribute5 per_all_people_f.attribute5%type

Line 100: ,attribute2 per_all_people_f.attribute2%type

96: ,date_employee_data_verified per_all_people_f.date_employee_data_verified%type
97: ,effective_start_date per_all_people_f.effective_start_date%type
98: ,effective_end_date per_all_people_f.effective_end_date%type
99: ,attribute1 per_all_people_f.attribute1%type
100: ,attribute2 per_all_people_f.attribute2%type
101: ,attribute3 per_all_people_f.attribute3%type
102: ,attribute4 per_all_people_f.attribute4%type
103: ,attribute5 per_all_people_f.attribute5%type
104: ,attribute6 per_all_people_f.attribute6%type

Line 101: ,attribute3 per_all_people_f.attribute3%type

97: ,effective_start_date per_all_people_f.effective_start_date%type
98: ,effective_end_date per_all_people_f.effective_end_date%type
99: ,attribute1 per_all_people_f.attribute1%type
100: ,attribute2 per_all_people_f.attribute2%type
101: ,attribute3 per_all_people_f.attribute3%type
102: ,attribute4 per_all_people_f.attribute4%type
103: ,attribute5 per_all_people_f.attribute5%type
104: ,attribute6 per_all_people_f.attribute6%type
105: ,attribute7 per_all_people_f.attribute7%type

Line 102: ,attribute4 per_all_people_f.attribute4%type

98: ,effective_end_date per_all_people_f.effective_end_date%type
99: ,attribute1 per_all_people_f.attribute1%type
100: ,attribute2 per_all_people_f.attribute2%type
101: ,attribute3 per_all_people_f.attribute3%type
102: ,attribute4 per_all_people_f.attribute4%type
103: ,attribute5 per_all_people_f.attribute5%type
104: ,attribute6 per_all_people_f.attribute6%type
105: ,attribute7 per_all_people_f.attribute7%type
106: ,attribute8 per_all_people_f.attribute8%type

Line 103: ,attribute5 per_all_people_f.attribute5%type

99: ,attribute1 per_all_people_f.attribute1%type
100: ,attribute2 per_all_people_f.attribute2%type
101: ,attribute3 per_all_people_f.attribute3%type
102: ,attribute4 per_all_people_f.attribute4%type
103: ,attribute5 per_all_people_f.attribute5%type
104: ,attribute6 per_all_people_f.attribute6%type
105: ,attribute7 per_all_people_f.attribute7%type
106: ,attribute8 per_all_people_f.attribute8%type
107: ,attribute9 per_all_people_f.attribute9%type

Line 104: ,attribute6 per_all_people_f.attribute6%type

100: ,attribute2 per_all_people_f.attribute2%type
101: ,attribute3 per_all_people_f.attribute3%type
102: ,attribute4 per_all_people_f.attribute4%type
103: ,attribute5 per_all_people_f.attribute5%type
104: ,attribute6 per_all_people_f.attribute6%type
105: ,attribute7 per_all_people_f.attribute7%type
106: ,attribute8 per_all_people_f.attribute8%type
107: ,attribute9 per_all_people_f.attribute9%type
108: ,attribute10 per_all_people_f.attribute10%type

Line 105: ,attribute7 per_all_people_f.attribute7%type

101: ,attribute3 per_all_people_f.attribute3%type
102: ,attribute4 per_all_people_f.attribute4%type
103: ,attribute5 per_all_people_f.attribute5%type
104: ,attribute6 per_all_people_f.attribute6%type
105: ,attribute7 per_all_people_f.attribute7%type
106: ,attribute8 per_all_people_f.attribute8%type
107: ,attribute9 per_all_people_f.attribute9%type
108: ,attribute10 per_all_people_f.attribute10%type
109: ,email_address per_all_people_f.email_address%type

Line 106: ,attribute8 per_all_people_f.attribute8%type

102: ,attribute4 per_all_people_f.attribute4%type
103: ,attribute5 per_all_people_f.attribute5%type
104: ,attribute6 per_all_people_f.attribute6%type
105: ,attribute7 per_all_people_f.attribute7%type
106: ,attribute8 per_all_people_f.attribute8%type
107: ,attribute9 per_all_people_f.attribute9%type
108: ,attribute10 per_all_people_f.attribute10%type
109: ,email_address per_all_people_f.email_address%type
110: ,employee_number per_all_people_f.employee_number%type

Line 107: ,attribute9 per_all_people_f.attribute9%type

103: ,attribute5 per_all_people_f.attribute5%type
104: ,attribute6 per_all_people_f.attribute6%type
105: ,attribute7 per_all_people_f.attribute7%type
106: ,attribute8 per_all_people_f.attribute8%type
107: ,attribute9 per_all_people_f.attribute9%type
108: ,attribute10 per_all_people_f.attribute10%type
109: ,email_address per_all_people_f.email_address%type
110: ,employee_number per_all_people_f.employee_number%type
111: ,per_information1 per_all_people_f.per_information1%type

Line 108: ,attribute10 per_all_people_f.attribute10%type

104: ,attribute6 per_all_people_f.attribute6%type
105: ,attribute7 per_all_people_f.attribute7%type
106: ,attribute8 per_all_people_f.attribute8%type
107: ,attribute9 per_all_people_f.attribute9%type
108: ,attribute10 per_all_people_f.attribute10%type
109: ,email_address per_all_people_f.email_address%type
110: ,employee_number per_all_people_f.employee_number%type
111: ,per_information1 per_all_people_f.per_information1%type
112: ,per_information2 per_all_people_f.per_information2%type

Line 109: ,email_address per_all_people_f.email_address%type

105: ,attribute7 per_all_people_f.attribute7%type
106: ,attribute8 per_all_people_f.attribute8%type
107: ,attribute9 per_all_people_f.attribute9%type
108: ,attribute10 per_all_people_f.attribute10%type
109: ,email_address per_all_people_f.email_address%type
110: ,employee_number per_all_people_f.employee_number%type
111: ,per_information1 per_all_people_f.per_information1%type
112: ,per_information2 per_all_people_f.per_information2%type
113: ,per_information3 per_all_people_f.per_information3%type

Line 110: ,employee_number per_all_people_f.employee_number%type

106: ,attribute8 per_all_people_f.attribute8%type
107: ,attribute9 per_all_people_f.attribute9%type
108: ,attribute10 per_all_people_f.attribute10%type
109: ,email_address per_all_people_f.email_address%type
110: ,employee_number per_all_people_f.employee_number%type
111: ,per_information1 per_all_people_f.per_information1%type
112: ,per_information2 per_all_people_f.per_information2%type
113: ,per_information3 per_all_people_f.per_information3%type
114: ,per_information4 per_all_people_f.per_information4%type

Line 111: ,per_information1 per_all_people_f.per_information1%type

107: ,attribute9 per_all_people_f.attribute9%type
108: ,attribute10 per_all_people_f.attribute10%type
109: ,email_address per_all_people_f.email_address%type
110: ,employee_number per_all_people_f.employee_number%type
111: ,per_information1 per_all_people_f.per_information1%type
112: ,per_information2 per_all_people_f.per_information2%type
113: ,per_information3 per_all_people_f.per_information3%type
114: ,per_information4 per_all_people_f.per_information4%type
115: ,per_information5 per_all_people_f.per_information5%type

Line 112: ,per_information2 per_all_people_f.per_information2%type

108: ,attribute10 per_all_people_f.attribute10%type
109: ,email_address per_all_people_f.email_address%type
110: ,employee_number per_all_people_f.employee_number%type
111: ,per_information1 per_all_people_f.per_information1%type
112: ,per_information2 per_all_people_f.per_information2%type
113: ,per_information3 per_all_people_f.per_information3%type
114: ,per_information4 per_all_people_f.per_information4%type
115: ,per_information5 per_all_people_f.per_information5%type
116: ,per_information6 per_all_people_f.per_information6%type

Line 113: ,per_information3 per_all_people_f.per_information3%type

109: ,email_address per_all_people_f.email_address%type
110: ,employee_number per_all_people_f.employee_number%type
111: ,per_information1 per_all_people_f.per_information1%type
112: ,per_information2 per_all_people_f.per_information2%type
113: ,per_information3 per_all_people_f.per_information3%type
114: ,per_information4 per_all_people_f.per_information4%type
115: ,per_information5 per_all_people_f.per_information5%type
116: ,per_information6 per_all_people_f.per_information6%type
117: ,per_information7 per_all_people_f.per_information7%type

Line 114: ,per_information4 per_all_people_f.per_information4%type

110: ,employee_number per_all_people_f.employee_number%type
111: ,per_information1 per_all_people_f.per_information1%type
112: ,per_information2 per_all_people_f.per_information2%type
113: ,per_information3 per_all_people_f.per_information3%type
114: ,per_information4 per_all_people_f.per_information4%type
115: ,per_information5 per_all_people_f.per_information5%type
116: ,per_information6 per_all_people_f.per_information6%type
117: ,per_information7 per_all_people_f.per_information7%type
118: ,per_information8 per_all_people_f.per_information8%type

Line 115: ,per_information5 per_all_people_f.per_information5%type

111: ,per_information1 per_all_people_f.per_information1%type
112: ,per_information2 per_all_people_f.per_information2%type
113: ,per_information3 per_all_people_f.per_information3%type
114: ,per_information4 per_all_people_f.per_information4%type
115: ,per_information5 per_all_people_f.per_information5%type
116: ,per_information6 per_all_people_f.per_information6%type
117: ,per_information7 per_all_people_f.per_information7%type
118: ,per_information8 per_all_people_f.per_information8%type
119: ,per_information9 per_all_people_f.per_information9%type

Line 116: ,per_information6 per_all_people_f.per_information6%type

112: ,per_information2 per_all_people_f.per_information2%type
113: ,per_information3 per_all_people_f.per_information3%type
114: ,per_information4 per_all_people_f.per_information4%type
115: ,per_information5 per_all_people_f.per_information5%type
116: ,per_information6 per_all_people_f.per_information6%type
117: ,per_information7 per_all_people_f.per_information7%type
118: ,per_information8 per_all_people_f.per_information8%type
119: ,per_information9 per_all_people_f.per_information9%type
120: ,per_information10 per_all_people_f.per_information10%type

Line 117: ,per_information7 per_all_people_f.per_information7%type

113: ,per_information3 per_all_people_f.per_information3%type
114: ,per_information4 per_all_people_f.per_information4%type
115: ,per_information5 per_all_people_f.per_information5%type
116: ,per_information6 per_all_people_f.per_information6%type
117: ,per_information7 per_all_people_f.per_information7%type
118: ,per_information8 per_all_people_f.per_information8%type
119: ,per_information9 per_all_people_f.per_information9%type
120: ,per_information10 per_all_people_f.per_information10%type
121: ,per_information11 per_all_people_f.per_information11%type

Line 118: ,per_information8 per_all_people_f.per_information8%type

114: ,per_information4 per_all_people_f.per_information4%type
115: ,per_information5 per_all_people_f.per_information5%type
116: ,per_information6 per_all_people_f.per_information6%type
117: ,per_information7 per_all_people_f.per_information7%type
118: ,per_information8 per_all_people_f.per_information8%type
119: ,per_information9 per_all_people_f.per_information9%type
120: ,per_information10 per_all_people_f.per_information10%type
121: ,per_information11 per_all_people_f.per_information11%type
122: ,per_information12 per_all_people_f.per_information12%type

Line 119: ,per_information9 per_all_people_f.per_information9%type

115: ,per_information5 per_all_people_f.per_information5%type
116: ,per_information6 per_all_people_f.per_information6%type
117: ,per_information7 per_all_people_f.per_information7%type
118: ,per_information8 per_all_people_f.per_information8%type
119: ,per_information9 per_all_people_f.per_information9%type
120: ,per_information10 per_all_people_f.per_information10%type
121: ,per_information11 per_all_people_f.per_information11%type
122: ,per_information12 per_all_people_f.per_information12%type
123: ,per_information13 per_all_people_f.per_information13%type

Line 120: ,per_information10 per_all_people_f.per_information10%type

116: ,per_information6 per_all_people_f.per_information6%type
117: ,per_information7 per_all_people_f.per_information7%type
118: ,per_information8 per_all_people_f.per_information8%type
119: ,per_information9 per_all_people_f.per_information9%type
120: ,per_information10 per_all_people_f.per_information10%type
121: ,per_information11 per_all_people_f.per_information11%type
122: ,per_information12 per_all_people_f.per_information12%type
123: ,per_information13 per_all_people_f.per_information13%type
124: ,per_information14 per_all_people_f.per_information14%type

Line 121: ,per_information11 per_all_people_f.per_information11%type

117: ,per_information7 per_all_people_f.per_information7%type
118: ,per_information8 per_all_people_f.per_information8%type
119: ,per_information9 per_all_people_f.per_information9%type
120: ,per_information10 per_all_people_f.per_information10%type
121: ,per_information11 per_all_people_f.per_information11%type
122: ,per_information12 per_all_people_f.per_information12%type
123: ,per_information13 per_all_people_f.per_information13%type
124: ,per_information14 per_all_people_f.per_information14%type
125: ,per_information15 per_all_people_f.per_information15%type

Line 122: ,per_information12 per_all_people_f.per_information12%type

118: ,per_information8 per_all_people_f.per_information8%type
119: ,per_information9 per_all_people_f.per_information9%type
120: ,per_information10 per_all_people_f.per_information10%type
121: ,per_information11 per_all_people_f.per_information11%type
122: ,per_information12 per_all_people_f.per_information12%type
123: ,per_information13 per_all_people_f.per_information13%type
124: ,per_information14 per_all_people_f.per_information14%type
125: ,per_information15 per_all_people_f.per_information15%type
126: ,per_information16 per_all_people_f.per_information16%type

Line 123: ,per_information13 per_all_people_f.per_information13%type

119: ,per_information9 per_all_people_f.per_information9%type
120: ,per_information10 per_all_people_f.per_information10%type
121: ,per_information11 per_all_people_f.per_information11%type
122: ,per_information12 per_all_people_f.per_information12%type
123: ,per_information13 per_all_people_f.per_information13%type
124: ,per_information14 per_all_people_f.per_information14%type
125: ,per_information15 per_all_people_f.per_information15%type
126: ,per_information16 per_all_people_f.per_information16%type
127: ,per_information17 per_all_people_f.per_information17%type

Line 124: ,per_information14 per_all_people_f.per_information14%type

120: ,per_information10 per_all_people_f.per_information10%type
121: ,per_information11 per_all_people_f.per_information11%type
122: ,per_information12 per_all_people_f.per_information12%type
123: ,per_information13 per_all_people_f.per_information13%type
124: ,per_information14 per_all_people_f.per_information14%type
125: ,per_information15 per_all_people_f.per_information15%type
126: ,per_information16 per_all_people_f.per_information16%type
127: ,per_information17 per_all_people_f.per_information17%type
128: ,per_information18 per_all_people_f.per_information18%type

Line 125: ,per_information15 per_all_people_f.per_information15%type

121: ,per_information11 per_all_people_f.per_information11%type
122: ,per_information12 per_all_people_f.per_information12%type
123: ,per_information13 per_all_people_f.per_information13%type
124: ,per_information14 per_all_people_f.per_information14%type
125: ,per_information15 per_all_people_f.per_information15%type
126: ,per_information16 per_all_people_f.per_information16%type
127: ,per_information17 per_all_people_f.per_information17%type
128: ,per_information18 per_all_people_f.per_information18%type
129: ,per_information19 per_all_people_f.per_information19%type

Line 126: ,per_information16 per_all_people_f.per_information16%type

122: ,per_information12 per_all_people_f.per_information12%type
123: ,per_information13 per_all_people_f.per_information13%type
124: ,per_information14 per_all_people_f.per_information14%type
125: ,per_information15 per_all_people_f.per_information15%type
126: ,per_information16 per_all_people_f.per_information16%type
127: ,per_information17 per_all_people_f.per_information17%type
128: ,per_information18 per_all_people_f.per_information18%type
129: ,per_information19 per_all_people_f.per_information19%type
130: ,per_information20 per_all_people_f.per_information20%type

Line 127: ,per_information17 per_all_people_f.per_information17%type

123: ,per_information13 per_all_people_f.per_information13%type
124: ,per_information14 per_all_people_f.per_information14%type
125: ,per_information15 per_all_people_f.per_information15%type
126: ,per_information16 per_all_people_f.per_information16%type
127: ,per_information17 per_all_people_f.per_information17%type
128: ,per_information18 per_all_people_f.per_information18%type
129: ,per_information19 per_all_people_f.per_information19%type
130: ,per_information20 per_all_people_f.per_information20%type
131: ,per_information21 per_all_people_f.per_information21%type

Line 128: ,per_information18 per_all_people_f.per_information18%type

124: ,per_information14 per_all_people_f.per_information14%type
125: ,per_information15 per_all_people_f.per_information15%type
126: ,per_information16 per_all_people_f.per_information16%type
127: ,per_information17 per_all_people_f.per_information17%type
128: ,per_information18 per_all_people_f.per_information18%type
129: ,per_information19 per_all_people_f.per_information19%type
130: ,per_information20 per_all_people_f.per_information20%type
131: ,per_information21 per_all_people_f.per_information21%type
132: ,per_information22 per_all_people_f.per_information22%type

Line 129: ,per_information19 per_all_people_f.per_information19%type

125: ,per_information15 per_all_people_f.per_information15%type
126: ,per_information16 per_all_people_f.per_information16%type
127: ,per_information17 per_all_people_f.per_information17%type
128: ,per_information18 per_all_people_f.per_information18%type
129: ,per_information19 per_all_people_f.per_information19%type
130: ,per_information20 per_all_people_f.per_information20%type
131: ,per_information21 per_all_people_f.per_information21%type
132: ,per_information22 per_all_people_f.per_information22%type
133: ,per_information23 per_all_people_f.per_information23%type

Line 130: ,per_information20 per_all_people_f.per_information20%type

126: ,per_information16 per_all_people_f.per_information16%type
127: ,per_information17 per_all_people_f.per_information17%type
128: ,per_information18 per_all_people_f.per_information18%type
129: ,per_information19 per_all_people_f.per_information19%type
130: ,per_information20 per_all_people_f.per_information20%type
131: ,per_information21 per_all_people_f.per_information21%type
132: ,per_information22 per_all_people_f.per_information22%type
133: ,per_information23 per_all_people_f.per_information23%type
134: ,per_information24 per_all_people_f.per_information24%type

Line 131: ,per_information21 per_all_people_f.per_information21%type

127: ,per_information17 per_all_people_f.per_information17%type
128: ,per_information18 per_all_people_f.per_information18%type
129: ,per_information19 per_all_people_f.per_information19%type
130: ,per_information20 per_all_people_f.per_information20%type
131: ,per_information21 per_all_people_f.per_information21%type
132: ,per_information22 per_all_people_f.per_information22%type
133: ,per_information23 per_all_people_f.per_information23%type
134: ,per_information24 per_all_people_f.per_information24%type
135: ,per_information25 per_all_people_f.per_information25%type

Line 132: ,per_information22 per_all_people_f.per_information22%type

128: ,per_information18 per_all_people_f.per_information18%type
129: ,per_information19 per_all_people_f.per_information19%type
130: ,per_information20 per_all_people_f.per_information20%type
131: ,per_information21 per_all_people_f.per_information21%type
132: ,per_information22 per_all_people_f.per_information22%type
133: ,per_information23 per_all_people_f.per_information23%type
134: ,per_information24 per_all_people_f.per_information24%type
135: ,per_information25 per_all_people_f.per_information25%type
136: ,per_information26 per_all_people_f.per_information26%type

Line 133: ,per_information23 per_all_people_f.per_information23%type

129: ,per_information19 per_all_people_f.per_information19%type
130: ,per_information20 per_all_people_f.per_information20%type
131: ,per_information21 per_all_people_f.per_information21%type
132: ,per_information22 per_all_people_f.per_information22%type
133: ,per_information23 per_all_people_f.per_information23%type
134: ,per_information24 per_all_people_f.per_information24%type
135: ,per_information25 per_all_people_f.per_information25%type
136: ,per_information26 per_all_people_f.per_information26%type
137: ,per_information27 per_all_people_f.per_information27%type

Line 134: ,per_information24 per_all_people_f.per_information24%type

130: ,per_information20 per_all_people_f.per_information20%type
131: ,per_information21 per_all_people_f.per_information21%type
132: ,per_information22 per_all_people_f.per_information22%type
133: ,per_information23 per_all_people_f.per_information23%type
134: ,per_information24 per_all_people_f.per_information24%type
135: ,per_information25 per_all_people_f.per_information25%type
136: ,per_information26 per_all_people_f.per_information26%type
137: ,per_information27 per_all_people_f.per_information27%type
138: ,per_information28 per_all_people_f.per_information28%type

Line 135: ,per_information25 per_all_people_f.per_information25%type

131: ,per_information21 per_all_people_f.per_information21%type
132: ,per_information22 per_all_people_f.per_information22%type
133: ,per_information23 per_all_people_f.per_information23%type
134: ,per_information24 per_all_people_f.per_information24%type
135: ,per_information25 per_all_people_f.per_information25%type
136: ,per_information26 per_all_people_f.per_information26%type
137: ,per_information27 per_all_people_f.per_information27%type
138: ,per_information28 per_all_people_f.per_information28%type
139: ,per_information29 per_all_people_f.per_information29%type

Line 136: ,per_information26 per_all_people_f.per_information26%type

132: ,per_information22 per_all_people_f.per_information22%type
133: ,per_information23 per_all_people_f.per_information23%type
134: ,per_information24 per_all_people_f.per_information24%type
135: ,per_information25 per_all_people_f.per_information25%type
136: ,per_information26 per_all_people_f.per_information26%type
137: ,per_information27 per_all_people_f.per_information27%type
138: ,per_information28 per_all_people_f.per_information28%type
139: ,per_information29 per_all_people_f.per_information29%type
140: ,per_information30 per_all_people_f.per_information30%type

Line 137: ,per_information27 per_all_people_f.per_information27%type

133: ,per_information23 per_all_people_f.per_information23%type
134: ,per_information24 per_all_people_f.per_information24%type
135: ,per_information25 per_all_people_f.per_information25%type
136: ,per_information26 per_all_people_f.per_information26%type
137: ,per_information27 per_all_people_f.per_information27%type
138: ,per_information28 per_all_people_f.per_information28%type
139: ,per_information29 per_all_people_f.per_information29%type
140: ,per_information30 per_all_people_f.per_information30%type
141: ,correspondence_language per_all_people_f.correspondence_language%type

Line 138: ,per_information28 per_all_people_f.per_information28%type

134: ,per_information24 per_all_people_f.per_information24%type
135: ,per_information25 per_all_people_f.per_information25%type
136: ,per_information26 per_all_people_f.per_information26%type
137: ,per_information27 per_all_people_f.per_information27%type
138: ,per_information28 per_all_people_f.per_information28%type
139: ,per_information29 per_all_people_f.per_information29%type
140: ,per_information30 per_all_people_f.per_information30%type
141: ,correspondence_language per_all_people_f.correspondence_language%type
142: ,uses_tobacco_flag per_all_people_f.uses_tobacco_flag%type

Line 139: ,per_information29 per_all_people_f.per_information29%type

135: ,per_information25 per_all_people_f.per_information25%type
136: ,per_information26 per_all_people_f.per_information26%type
137: ,per_information27 per_all_people_f.per_information27%type
138: ,per_information28 per_all_people_f.per_information28%type
139: ,per_information29 per_all_people_f.per_information29%type
140: ,per_information30 per_all_people_f.per_information30%type
141: ,correspondence_language per_all_people_f.correspondence_language%type
142: ,uses_tobacco_flag per_all_people_f.uses_tobacco_flag%type
143: ,update_mode varchar2(20)

Line 140: ,per_information30 per_all_people_f.per_information30%type

136: ,per_information26 per_all_people_f.per_information26%type
137: ,per_information27 per_all_people_f.per_information27%type
138: ,per_information28 per_all_people_f.per_information28%type
139: ,per_information29 per_all_people_f.per_information29%type
140: ,per_information30 per_all_people_f.per_information30%type
141: ,correspondence_language per_all_people_f.correspondence_language%type
142: ,uses_tobacco_flag per_all_people_f.uses_tobacco_flag%type
143: ,update_mode varchar2(20)
144: );

Line 141: ,correspondence_language per_all_people_f.correspondence_language%type

137: ,per_information27 per_all_people_f.per_information27%type
138: ,per_information28 per_all_people_f.per_information28%type
139: ,per_information29 per_all_people_f.per_information29%type
140: ,per_information30 per_all_people_f.per_information30%type
141: ,correspondence_language per_all_people_f.correspondence_language%type
142: ,uses_tobacco_flag per_all_people_f.uses_tobacco_flag%type
143: ,update_mode varchar2(20)
144: );
145: --

Line 142: ,uses_tobacco_flag per_all_people_f.uses_tobacco_flag%type

138: ,per_information28 per_all_people_f.per_information28%type
139: ,per_information29 per_all_people_f.per_information29%type
140: ,per_information30 per_all_people_f.per_information30%type
141: ,correspondence_language per_all_people_f.correspondence_language%type
142: ,uses_tobacco_flag per_all_people_f.uses_tobacco_flag%type
143: ,update_mode varchar2(20)
144: );
145: --
146: Type g_cont_rec_type is RECORD

Line 261: (PERSON_ID per_all_people_f.person_id%type

257: ,update_mode varchar2(20)
258: );
259: ---
260: Type g_per_pay_rec_type is RECORD
261: (PERSON_ID per_all_people_f.person_id%type
262: ,BUSINESS_GROUP_ID per_pay_proposals.BUSINESS_GROUP_ID%type
263: ,PAY_PROPOSAL_ID per_pay_proposals.assignment_id%type
264: ,OBJECT_VERSION_NUMBER per_pay_proposals.OBJECT_VERSION_NUMBER%type
265: ,ASSIGNMENT_ID per_pay_proposals.ASSIGNMENT_ID%type

Line 333: ,business_group_id per_all_people_f.business_group_id%type

329: Type per_dis_rec_type is RECORD
330: (person_id per_disabilities_f.person_id%type
331: ,effective_start_date per_disabilities_f.effective_start_date%type
332: ,effective_end_date per_disabilities_f.effective_end_date%type
333: ,business_group_id per_all_people_f.business_group_id%type
334: ,incident_id per_disabilities_f.incident_id%type
335: ,organization_id per_disabilities_f.organization_id%type
336: ,registration_id per_disabilities_f.registration_id%type
337: ,registration_date per_disabilities_f.registration_date%type