200: g_phone_fax per_phones.phone_number%TYPE;
201: g_phone_mobile per_phones.phone_number%TYPE;
202: g_phone_pager per_phones.phone_number%TYPE;
203: --
204: g_last_hire_date per_periods_of_service.date_start%TYPE;
205: g_actual_term_date per_periods_of_service.actual_termination_date%TYPE;
206: g_adjusted_svc_date per_periods_of_service.adjusted_svc_date%TYPE;
207: g_term_reason per_periods_of_service.leaving_reason%TYPE;
208: g_pos_last_update_date per_periods_of_service.last_update_date%TYPE;
201: g_phone_mobile per_phones.phone_number%TYPE;
202: g_phone_pager per_phones.phone_number%TYPE;
203: --
204: g_last_hire_date per_periods_of_service.date_start%TYPE;
205: g_actual_term_date per_periods_of_service.actual_termination_date%TYPE;
206: g_adjusted_svc_date per_periods_of_service.adjusted_svc_date%TYPE;
207: g_term_reason per_periods_of_service.leaving_reason%TYPE;
208: g_pos_last_update_date per_periods_of_service.last_update_date%TYPE;
209: g_pos_last_updated_by per_periods_of_service.last_updated_by%TYPE;
202: g_phone_pager per_phones.phone_number%TYPE;
203: --
204: g_last_hire_date per_periods_of_service.date_start%TYPE;
205: g_actual_term_date per_periods_of_service.actual_termination_date%TYPE;
206: g_adjusted_svc_date per_periods_of_service.adjusted_svc_date%TYPE;
207: g_term_reason per_periods_of_service.leaving_reason%TYPE;
208: g_pos_last_update_date per_periods_of_service.last_update_date%TYPE;
209: g_pos_last_updated_by per_periods_of_service.last_updated_by%TYPE;
210: g_pos_last_update_login per_periods_of_service.last_update_login%TYPE;
203: --
204: g_last_hire_date per_periods_of_service.date_start%TYPE;
205: g_actual_term_date per_periods_of_service.actual_termination_date%TYPE;
206: g_adjusted_svc_date per_periods_of_service.adjusted_svc_date%TYPE;
207: g_term_reason per_periods_of_service.leaving_reason%TYPE;
208: g_pos_last_update_date per_periods_of_service.last_update_date%TYPE;
209: g_pos_last_updated_by per_periods_of_service.last_updated_by%TYPE;
210: g_pos_last_update_login per_periods_of_service.last_update_login%TYPE;
211: g_pos_created_by per_periods_of_service.created_by%TYPE;
204: g_last_hire_date per_periods_of_service.date_start%TYPE;
205: g_actual_term_date per_periods_of_service.actual_termination_date%TYPE;
206: g_adjusted_svc_date per_periods_of_service.adjusted_svc_date%TYPE;
207: g_term_reason per_periods_of_service.leaving_reason%TYPE;
208: g_pos_last_update_date per_periods_of_service.last_update_date%TYPE;
209: g_pos_last_updated_by per_periods_of_service.last_updated_by%TYPE;
210: g_pos_last_update_login per_periods_of_service.last_update_login%TYPE;
211: g_pos_created_by per_periods_of_service.created_by%TYPE;
212: g_pos_creation_date per_periods_of_service.creation_date%TYPE;
205: g_actual_term_date per_periods_of_service.actual_termination_date%TYPE;
206: g_adjusted_svc_date per_periods_of_service.adjusted_svc_date%TYPE;
207: g_term_reason per_periods_of_service.leaving_reason%TYPE;
208: g_pos_last_update_date per_periods_of_service.last_update_date%TYPE;
209: g_pos_last_updated_by per_periods_of_service.last_updated_by%TYPE;
210: g_pos_last_update_login per_periods_of_service.last_update_login%TYPE;
211: g_pos_created_by per_periods_of_service.created_by%TYPE;
212: g_pos_creation_date per_periods_of_service.creation_date%TYPE;
213: g_prs_flex_01 per_periods_of_service.attribute1%TYPE;
206: g_adjusted_svc_date per_periods_of_service.adjusted_svc_date%TYPE;
207: g_term_reason per_periods_of_service.leaving_reason%TYPE;
208: g_pos_last_update_date per_periods_of_service.last_update_date%TYPE;
209: g_pos_last_updated_by per_periods_of_service.last_updated_by%TYPE;
210: g_pos_last_update_login per_periods_of_service.last_update_login%TYPE;
211: g_pos_created_by per_periods_of_service.created_by%TYPE;
212: g_pos_creation_date per_periods_of_service.creation_date%TYPE;
213: g_prs_flex_01 per_periods_of_service.attribute1%TYPE;
214: g_prs_flex_02 per_periods_of_service.attribute2%TYPE;
207: g_term_reason per_periods_of_service.leaving_reason%TYPE;
208: g_pos_last_update_date per_periods_of_service.last_update_date%TYPE;
209: g_pos_last_updated_by per_periods_of_service.last_updated_by%TYPE;
210: g_pos_last_update_login per_periods_of_service.last_update_login%TYPE;
211: g_pos_created_by per_periods_of_service.created_by%TYPE;
212: g_pos_creation_date per_periods_of_service.creation_date%TYPE;
213: g_prs_flex_01 per_periods_of_service.attribute1%TYPE;
214: g_prs_flex_02 per_periods_of_service.attribute2%TYPE;
215: g_prs_flex_03 per_periods_of_service.attribute3%TYPE;
208: g_pos_last_update_date per_periods_of_service.last_update_date%TYPE;
209: g_pos_last_updated_by per_periods_of_service.last_updated_by%TYPE;
210: g_pos_last_update_login per_periods_of_service.last_update_login%TYPE;
211: g_pos_created_by per_periods_of_service.created_by%TYPE;
212: g_pos_creation_date per_periods_of_service.creation_date%TYPE;
213: g_prs_flex_01 per_periods_of_service.attribute1%TYPE;
214: g_prs_flex_02 per_periods_of_service.attribute2%TYPE;
215: g_prs_flex_03 per_periods_of_service.attribute3%TYPE;
216: g_prs_flex_04 per_periods_of_service.attribute4%TYPE;
209: g_pos_last_updated_by per_periods_of_service.last_updated_by%TYPE;
210: g_pos_last_update_login per_periods_of_service.last_update_login%TYPE;
211: g_pos_created_by per_periods_of_service.created_by%TYPE;
212: g_pos_creation_date per_periods_of_service.creation_date%TYPE;
213: g_prs_flex_01 per_periods_of_service.attribute1%TYPE;
214: g_prs_flex_02 per_periods_of_service.attribute2%TYPE;
215: g_prs_flex_03 per_periods_of_service.attribute3%TYPE;
216: g_prs_flex_04 per_periods_of_service.attribute4%TYPE;
217: g_prs_flex_05 per_periods_of_service.attribute5%TYPE;
210: g_pos_last_update_login per_periods_of_service.last_update_login%TYPE;
211: g_pos_created_by per_periods_of_service.created_by%TYPE;
212: g_pos_creation_date per_periods_of_service.creation_date%TYPE;
213: g_prs_flex_01 per_periods_of_service.attribute1%TYPE;
214: g_prs_flex_02 per_periods_of_service.attribute2%TYPE;
215: g_prs_flex_03 per_periods_of_service.attribute3%TYPE;
216: g_prs_flex_04 per_periods_of_service.attribute4%TYPE;
217: g_prs_flex_05 per_periods_of_service.attribute5%TYPE;
218: g_prs_flex_06 per_periods_of_service.attribute6%TYPE;
211: g_pos_created_by per_periods_of_service.created_by%TYPE;
212: g_pos_creation_date per_periods_of_service.creation_date%TYPE;
213: g_prs_flex_01 per_periods_of_service.attribute1%TYPE;
214: g_prs_flex_02 per_periods_of_service.attribute2%TYPE;
215: g_prs_flex_03 per_periods_of_service.attribute3%TYPE;
216: g_prs_flex_04 per_periods_of_service.attribute4%TYPE;
217: g_prs_flex_05 per_periods_of_service.attribute5%TYPE;
218: g_prs_flex_06 per_periods_of_service.attribute6%TYPE;
219: g_prs_flex_07 per_periods_of_service.attribute7%TYPE;
212: g_pos_creation_date per_periods_of_service.creation_date%TYPE;
213: g_prs_flex_01 per_periods_of_service.attribute1%TYPE;
214: g_prs_flex_02 per_periods_of_service.attribute2%TYPE;
215: g_prs_flex_03 per_periods_of_service.attribute3%TYPE;
216: g_prs_flex_04 per_periods_of_service.attribute4%TYPE;
217: g_prs_flex_05 per_periods_of_service.attribute5%TYPE;
218: g_prs_flex_06 per_periods_of_service.attribute6%TYPE;
219: g_prs_flex_07 per_periods_of_service.attribute7%TYPE;
220: g_prs_flex_08 per_periods_of_service.attribute8%TYPE;
213: g_prs_flex_01 per_periods_of_service.attribute1%TYPE;
214: g_prs_flex_02 per_periods_of_service.attribute2%TYPE;
215: g_prs_flex_03 per_periods_of_service.attribute3%TYPE;
216: g_prs_flex_04 per_periods_of_service.attribute4%TYPE;
217: g_prs_flex_05 per_periods_of_service.attribute5%TYPE;
218: g_prs_flex_06 per_periods_of_service.attribute6%TYPE;
219: g_prs_flex_07 per_periods_of_service.attribute7%TYPE;
220: g_prs_flex_08 per_periods_of_service.attribute8%TYPE;
221: g_prs_flex_09 per_periods_of_service.attribute9%TYPE;
214: g_prs_flex_02 per_periods_of_service.attribute2%TYPE;
215: g_prs_flex_03 per_periods_of_service.attribute3%TYPE;
216: g_prs_flex_04 per_periods_of_service.attribute4%TYPE;
217: g_prs_flex_05 per_periods_of_service.attribute5%TYPE;
218: g_prs_flex_06 per_periods_of_service.attribute6%TYPE;
219: g_prs_flex_07 per_periods_of_service.attribute7%TYPE;
220: g_prs_flex_08 per_periods_of_service.attribute8%TYPE;
221: g_prs_flex_09 per_periods_of_service.attribute9%TYPE;
222: g_prs_flex_10 per_periods_of_service.attribute10%TYPE;
215: g_prs_flex_03 per_periods_of_service.attribute3%TYPE;
216: g_prs_flex_04 per_periods_of_service.attribute4%TYPE;
217: g_prs_flex_05 per_periods_of_service.attribute5%TYPE;
218: g_prs_flex_06 per_periods_of_service.attribute6%TYPE;
219: g_prs_flex_07 per_periods_of_service.attribute7%TYPE;
220: g_prs_flex_08 per_periods_of_service.attribute8%TYPE;
221: g_prs_flex_09 per_periods_of_service.attribute9%TYPE;
222: g_prs_flex_10 per_periods_of_service.attribute10%TYPE;
223: --
216: g_prs_flex_04 per_periods_of_service.attribute4%TYPE;
217: g_prs_flex_05 per_periods_of_service.attribute5%TYPE;
218: g_prs_flex_06 per_periods_of_service.attribute6%TYPE;
219: g_prs_flex_07 per_periods_of_service.attribute7%TYPE;
220: g_prs_flex_08 per_periods_of_service.attribute8%TYPE;
221: g_prs_flex_09 per_periods_of_service.attribute9%TYPE;
222: g_prs_flex_10 per_periods_of_service.attribute10%TYPE;
223: --
224: g_person_types per_person_types.user_person_type%type ;
217: g_prs_flex_05 per_periods_of_service.attribute5%TYPE;
218: g_prs_flex_06 per_periods_of_service.attribute6%TYPE;
219: g_prs_flex_07 per_periods_of_service.attribute7%TYPE;
220: g_prs_flex_08 per_periods_of_service.attribute8%TYPE;
221: g_prs_flex_09 per_periods_of_service.attribute9%TYPE;
222: g_prs_flex_10 per_periods_of_service.attribute10%TYPE;
223: --
224: g_person_types per_person_types.user_person_type%type ;
225: g_person_type_id per_person_types.person_type_id%type ;
218: g_prs_flex_06 per_periods_of_service.attribute6%TYPE;
219: g_prs_flex_07 per_periods_of_service.attribute7%TYPE;
220: g_prs_flex_08 per_periods_of_service.attribute8%TYPE;
221: g_prs_flex_09 per_periods_of_service.attribute9%TYPE;
222: g_prs_flex_10 per_periods_of_service.attribute10%TYPE;
223: --
224: g_person_types per_person_types.user_person_type%type ;
225: g_person_type_id per_person_types.person_type_id%type ;
226: --