8: */
9:
10: -- Record for search criteria
11: Type srch_criteria_record is RECORD
12: (p_person_id per_all_people_f.person_id%type default null,
13: p_start_person_id per_all_people_f.person_id%type default null,
14: p_end_person_id per_all_people_f.person_id%type default null,
15: p_assignment_id per_all_assignments_f.assignment_id%type default null,
16: p_first_name per_all_people_f.first_name%type default null,
9:
10: -- Record for search criteria
11: Type srch_criteria_record is RECORD
12: (p_person_id per_all_people_f.person_id%type default null,
13: p_start_person_id per_all_people_f.person_id%type default null,
14: p_end_person_id per_all_people_f.person_id%type default null,
15: p_assignment_id per_all_assignments_f.assignment_id%type default null,
16: p_first_name per_all_people_f.first_name%type default null,
17: p_last_name per_all_people_f.last_name%type default null,
10: -- Record for search criteria
11: Type srch_criteria_record is RECORD
12: (p_person_id per_all_people_f.person_id%type default null,
13: p_start_person_id per_all_people_f.person_id%type default null,
14: p_end_person_id per_all_people_f.person_id%type default null,
15: p_assignment_id per_all_assignments_f.assignment_id%type default null,
16: p_first_name per_all_people_f.first_name%type default null,
17: p_last_name per_all_people_f.last_name%type default null,
18: p_bgrp_name hr_all_organization_units.name%type default null,
12: (p_person_id per_all_people_f.person_id%type default null,
13: p_start_person_id per_all_people_f.person_id%type default null,
14: p_end_person_id per_all_people_f.person_id%type default null,
15: p_assignment_id per_all_assignments_f.assignment_id%type default null,
16: p_first_name per_all_people_f.first_name%type default null,
17: p_last_name per_all_people_f.last_name%type default null,
18: p_bgrp_name hr_all_organization_units.name%type default null,
19: p_bgrp_id hr_all_organization_units.business_group_id%type default null,
20: p_effective_date date,
13: p_start_person_id per_all_people_f.person_id%type default null,
14: p_end_person_id per_all_people_f.person_id%type default null,
15: p_assignment_id per_all_assignments_f.assignment_id%type default null,
16: p_first_name per_all_people_f.first_name%type default null,
17: p_last_name per_all_people_f.last_name%type default null,
18: p_bgrp_name hr_all_organization_units.name%type default null,
19: p_bgrp_id hr_all_organization_units.business_group_id%type default null,
20: p_effective_date date,
21: p_employee_no per_all_people_f.employee_number%type default null,
17: p_last_name per_all_people_f.last_name%type default null,
18: p_bgrp_name hr_all_organization_units.name%type default null,
19: p_bgrp_id hr_all_organization_units.business_group_id%type default null,
20: p_effective_date date,
21: p_employee_no per_all_people_f.employee_number%type default null,
22: p_applicant_no per_all_people_f.applicant_number%type default null,
23: p_cwk_no per_all_people_f.npw_number%type default null,
24: p_person_type PER_PERSON_TYPES_TL.user_person_type%TYPE default null,
25: p_employee_category hr_lookups.meaning%type default null,
18: p_bgrp_name hr_all_organization_units.name%type default null,
19: p_bgrp_id hr_all_organization_units.business_group_id%type default null,
20: p_effective_date date,
21: p_employee_no per_all_people_f.employee_number%type default null,
22: p_applicant_no per_all_people_f.applicant_number%type default null,
23: p_cwk_no per_all_people_f.npw_number%type default null,
24: p_person_type PER_PERSON_TYPES_TL.user_person_type%TYPE default null,
25: p_employee_category hr_lookups.meaning%type default null,
26: p_employment_category hr_lookups.meaning%type default null,
19: p_bgrp_id hr_all_organization_units.business_group_id%type default null,
20: p_effective_date date,
21: p_employee_no per_all_people_f.employee_number%type default null,
22: p_applicant_no per_all_people_f.applicant_number%type default null,
23: p_cwk_no per_all_people_f.npw_number%type default null,
24: p_person_type PER_PERSON_TYPES_TL.user_person_type%TYPE default null,
25: p_employee_category hr_lookups.meaning%type default null,
26: p_employment_category hr_lookups.meaning%type default null,
27: p_phone_id per_phones.phone_id%type default null,
38:
39: /*Record type for person details*/
40: TYPE person_details IS RECORD
41: (
42: PERSON_ID PER_ALL_PEOPLE_F.PERSON_ID%TYPE,
43: EFFECTIVE_START_DATE varchar2(10),
44: EFFECTIVE_END_DATE varchar2(10),
45: BUSINESS_GROUP_ID PER_ALL_PEOPLE_F.BUSINESS_GROUP_ID%TYPE,
46: BUSINESS_GROUP_DESC HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE, -- (BASED ON LANG)
41: (
42: PERSON_ID PER_ALL_PEOPLE_F.PERSON_ID%TYPE,
43: EFFECTIVE_START_DATE varchar2(10),
44: EFFECTIVE_END_DATE varchar2(10),
45: BUSINESS_GROUP_ID PER_ALL_PEOPLE_F.BUSINESS_GROUP_ID%TYPE,
46: BUSINESS_GROUP_DESC HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE, -- (BASED ON LANG)
47: PERSON_TYPE_ID PER_ALL_PEOPLE_F.PERSON_TYPE_ID%TYPE,
48: USER_PERSN_TYPE PER_PERSON_TYPES_TL.user_person_type%TYPE,
49: SYSTEM_PERSON_TYPE PER_PERSON_TYPES.system_person_type%TYPE,
43: EFFECTIVE_START_DATE varchar2(10),
44: EFFECTIVE_END_DATE varchar2(10),
45: BUSINESS_GROUP_ID PER_ALL_PEOPLE_F.BUSINESS_GROUP_ID%TYPE,
46: BUSINESS_GROUP_DESC HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE, -- (BASED ON LANG)
47: PERSON_TYPE_ID PER_ALL_PEOPLE_F.PERSON_TYPE_ID%TYPE,
48: USER_PERSN_TYPE PER_PERSON_TYPES_TL.user_person_type%TYPE,
49: SYSTEM_PERSON_TYPE PER_PERSON_TYPES.system_person_type%TYPE,
50: LAST_NAME PER_ALL_PEOPLE_F.LAST_NAME%TYPE,
51: START_DATE varchar2(10),
46: BUSINESS_GROUP_DESC HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE, -- (BASED ON LANG)
47: PERSON_TYPE_ID PER_ALL_PEOPLE_F.PERSON_TYPE_ID%TYPE,
48: USER_PERSN_TYPE PER_PERSON_TYPES_TL.user_person_type%TYPE,
49: SYSTEM_PERSON_TYPE PER_PERSON_TYPES.system_person_type%TYPE,
50: LAST_NAME PER_ALL_PEOPLE_F.LAST_NAME%TYPE,
51: START_DATE varchar2(10),
52: APPLICANT_NUMBER PER_ALL_PEOPLE_F.APPLICANT_NUMBER%TYPE,
53: BACKGROUND_CHECK_STATUS PER_ALL_PEOPLE_F.BACKGROUND_CHECK_STATUS%TYPE,
54: BACKGROUND_DATE_CHECK varchar2(10),
48: USER_PERSN_TYPE PER_PERSON_TYPES_TL.user_person_type%TYPE,
49: SYSTEM_PERSON_TYPE PER_PERSON_TYPES.system_person_type%TYPE,
50: LAST_NAME PER_ALL_PEOPLE_F.LAST_NAME%TYPE,
51: START_DATE varchar2(10),
52: APPLICANT_NUMBER PER_ALL_PEOPLE_F.APPLICANT_NUMBER%TYPE,
53: BACKGROUND_CHECK_STATUS PER_ALL_PEOPLE_F.BACKGROUND_CHECK_STATUS%TYPE,
54: BACKGROUND_DATE_CHECK varchar2(10),
55: BLOOD_TYPE PER_ALL_PEOPLE_F.BLOOD_TYPE%TYPE,
56: BLOOD_TYPE_DESC FND_LOOKUP_VALUES.MEANING%TYPE, -- (BASED ON LANG /'BLOOD_TYPE')
49: SYSTEM_PERSON_TYPE PER_PERSON_TYPES.system_person_type%TYPE,
50: LAST_NAME PER_ALL_PEOPLE_F.LAST_NAME%TYPE,
51: START_DATE varchar2(10),
52: APPLICANT_NUMBER PER_ALL_PEOPLE_F.APPLICANT_NUMBER%TYPE,
53: BACKGROUND_CHECK_STATUS PER_ALL_PEOPLE_F.BACKGROUND_CHECK_STATUS%TYPE,
54: BACKGROUND_DATE_CHECK varchar2(10),
55: BLOOD_TYPE PER_ALL_PEOPLE_F.BLOOD_TYPE%TYPE,
56: BLOOD_TYPE_DESC FND_LOOKUP_VALUES.MEANING%TYPE, -- (BASED ON LANG /'BLOOD_TYPE')
57: COMMENT_ID PER_ALL_PEOPLE_F.COMMENT_ID%TYPE,
51: START_DATE varchar2(10),
52: APPLICANT_NUMBER PER_ALL_PEOPLE_F.APPLICANT_NUMBER%TYPE,
53: BACKGROUND_CHECK_STATUS PER_ALL_PEOPLE_F.BACKGROUND_CHECK_STATUS%TYPE,
54: BACKGROUND_DATE_CHECK varchar2(10),
55: BLOOD_TYPE PER_ALL_PEOPLE_F.BLOOD_TYPE%TYPE,
56: BLOOD_TYPE_DESC FND_LOOKUP_VALUES.MEANING%TYPE, -- (BASED ON LANG /'BLOOD_TYPE')
57: COMMENT_ID PER_ALL_PEOPLE_F.COMMENT_ID%TYPE,
58: CORRESPONDENCE_LANGUAGE PER_ALL_PEOPLE_F.CORRESPONDENCE_LANGUAGE%TYPE,
59: CORRESPONDENCE_LANGUAGE_DESC FND_LANGUAGES_VL.DESCRIPTION%TYPE,
53: BACKGROUND_CHECK_STATUS PER_ALL_PEOPLE_F.BACKGROUND_CHECK_STATUS%TYPE,
54: BACKGROUND_DATE_CHECK varchar2(10),
55: BLOOD_TYPE PER_ALL_PEOPLE_F.BLOOD_TYPE%TYPE,
56: BLOOD_TYPE_DESC FND_LOOKUP_VALUES.MEANING%TYPE, -- (BASED ON LANG /'BLOOD_TYPE')
57: COMMENT_ID PER_ALL_PEOPLE_F.COMMENT_ID%TYPE,
58: CORRESPONDENCE_LANGUAGE PER_ALL_PEOPLE_F.CORRESPONDENCE_LANGUAGE%TYPE,
59: CORRESPONDENCE_LANGUAGE_DESC FND_LANGUAGES_VL.DESCRIPTION%TYPE,
60: CURRENT_APPLICANT_FLAG PER_ALL_PEOPLE_F.CURRENT_APPLICANT_FLAG%TYPE,
61: CURRENT_EMP_OR_APL_FLAG PER_ALL_PEOPLE_F.CURRENT_EMP_OR_APL_FLAG%TYPE,
54: BACKGROUND_DATE_CHECK varchar2(10),
55: BLOOD_TYPE PER_ALL_PEOPLE_F.BLOOD_TYPE%TYPE,
56: BLOOD_TYPE_DESC FND_LOOKUP_VALUES.MEANING%TYPE, -- (BASED ON LANG /'BLOOD_TYPE')
57: COMMENT_ID PER_ALL_PEOPLE_F.COMMENT_ID%TYPE,
58: CORRESPONDENCE_LANGUAGE PER_ALL_PEOPLE_F.CORRESPONDENCE_LANGUAGE%TYPE,
59: CORRESPONDENCE_LANGUAGE_DESC FND_LANGUAGES_VL.DESCRIPTION%TYPE,
60: CURRENT_APPLICANT_FLAG PER_ALL_PEOPLE_F.CURRENT_APPLICANT_FLAG%TYPE,
61: CURRENT_EMP_OR_APL_FLAG PER_ALL_PEOPLE_F.CURRENT_EMP_OR_APL_FLAG%TYPE,
62: CURRENT_EMPLOYEE_FLAG PER_ALL_PEOPLE_F.CURRENT_EMPLOYEE_FLAG%TYPE,
56: BLOOD_TYPE_DESC FND_LOOKUP_VALUES.MEANING%TYPE, -- (BASED ON LANG /'BLOOD_TYPE')
57: COMMENT_ID PER_ALL_PEOPLE_F.COMMENT_ID%TYPE,
58: CORRESPONDENCE_LANGUAGE PER_ALL_PEOPLE_F.CORRESPONDENCE_LANGUAGE%TYPE,
59: CORRESPONDENCE_LANGUAGE_DESC FND_LANGUAGES_VL.DESCRIPTION%TYPE,
60: CURRENT_APPLICANT_FLAG PER_ALL_PEOPLE_F.CURRENT_APPLICANT_FLAG%TYPE,
61: CURRENT_EMP_OR_APL_FLAG PER_ALL_PEOPLE_F.CURRENT_EMP_OR_APL_FLAG%TYPE,
62: CURRENT_EMPLOYEE_FLAG PER_ALL_PEOPLE_F.CURRENT_EMPLOYEE_FLAG%TYPE,
63: DATE_EMPLOYEE_DATA_VERIFIED varchar2(10),
64: DATE_OF_BIRTH varchar2(10),
57: COMMENT_ID PER_ALL_PEOPLE_F.COMMENT_ID%TYPE,
58: CORRESPONDENCE_LANGUAGE PER_ALL_PEOPLE_F.CORRESPONDENCE_LANGUAGE%TYPE,
59: CORRESPONDENCE_LANGUAGE_DESC FND_LANGUAGES_VL.DESCRIPTION%TYPE,
60: CURRENT_APPLICANT_FLAG PER_ALL_PEOPLE_F.CURRENT_APPLICANT_FLAG%TYPE,
61: CURRENT_EMP_OR_APL_FLAG PER_ALL_PEOPLE_F.CURRENT_EMP_OR_APL_FLAG%TYPE,
62: CURRENT_EMPLOYEE_FLAG PER_ALL_PEOPLE_F.CURRENT_EMPLOYEE_FLAG%TYPE,
63: DATE_EMPLOYEE_DATA_VERIFIED varchar2(10),
64: DATE_OF_BIRTH varchar2(10),
65: EMAIL_ADDRESS PER_ALL_PEOPLE_F.EMAIL_ADDRESS%TYPE,
58: CORRESPONDENCE_LANGUAGE PER_ALL_PEOPLE_F.CORRESPONDENCE_LANGUAGE%TYPE,
59: CORRESPONDENCE_LANGUAGE_DESC FND_LANGUAGES_VL.DESCRIPTION%TYPE,
60: CURRENT_APPLICANT_FLAG PER_ALL_PEOPLE_F.CURRENT_APPLICANT_FLAG%TYPE,
61: CURRENT_EMP_OR_APL_FLAG PER_ALL_PEOPLE_F.CURRENT_EMP_OR_APL_FLAG%TYPE,
62: CURRENT_EMPLOYEE_FLAG PER_ALL_PEOPLE_F.CURRENT_EMPLOYEE_FLAG%TYPE,
63: DATE_EMPLOYEE_DATA_VERIFIED varchar2(10),
64: DATE_OF_BIRTH varchar2(10),
65: EMAIL_ADDRESS PER_ALL_PEOPLE_F.EMAIL_ADDRESS%TYPE,
66: EMPLOYEE_NUMBER PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%TYPE,
61: CURRENT_EMP_OR_APL_FLAG PER_ALL_PEOPLE_F.CURRENT_EMP_OR_APL_FLAG%TYPE,
62: CURRENT_EMPLOYEE_FLAG PER_ALL_PEOPLE_F.CURRENT_EMPLOYEE_FLAG%TYPE,
63: DATE_EMPLOYEE_DATA_VERIFIED varchar2(10),
64: DATE_OF_BIRTH varchar2(10),
65: EMAIL_ADDRESS PER_ALL_PEOPLE_F.EMAIL_ADDRESS%TYPE,
66: EMPLOYEE_NUMBER PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%TYPE,
67: EXPENSE_CHECK_SEND_TO_ADDRESS PER_ALL_PEOPLE_F.EXPENSE_CHECK_SEND_TO_ADDRESS%TYPE,
68: FAST_PATH_EMPLOYEE PER_ALL_PEOPLE_F.FAST_PATH_EMPLOYEE%TYPE,
69: FIRST_NAME PER_ALL_PEOPLE_F.FIRST_NAME%TYPE,
62: CURRENT_EMPLOYEE_FLAG PER_ALL_PEOPLE_F.CURRENT_EMPLOYEE_FLAG%TYPE,
63: DATE_EMPLOYEE_DATA_VERIFIED varchar2(10),
64: DATE_OF_BIRTH varchar2(10),
65: EMAIL_ADDRESS PER_ALL_PEOPLE_F.EMAIL_ADDRESS%TYPE,
66: EMPLOYEE_NUMBER PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%TYPE,
67: EXPENSE_CHECK_SEND_TO_ADDRESS PER_ALL_PEOPLE_F.EXPENSE_CHECK_SEND_TO_ADDRESS%TYPE,
68: FAST_PATH_EMPLOYEE PER_ALL_PEOPLE_F.FAST_PATH_EMPLOYEE%TYPE,
69: FIRST_NAME PER_ALL_PEOPLE_F.FIRST_NAME%TYPE,
70: FTE_CAPACITY PER_ALL_PEOPLE_F.FTE_CAPACITY%TYPE,
63: DATE_EMPLOYEE_DATA_VERIFIED varchar2(10),
64: DATE_OF_BIRTH varchar2(10),
65: EMAIL_ADDRESS PER_ALL_PEOPLE_F.EMAIL_ADDRESS%TYPE,
66: EMPLOYEE_NUMBER PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%TYPE,
67: EXPENSE_CHECK_SEND_TO_ADDRESS PER_ALL_PEOPLE_F.EXPENSE_CHECK_SEND_TO_ADDRESS%TYPE,
68: FAST_PATH_EMPLOYEE PER_ALL_PEOPLE_F.FAST_PATH_EMPLOYEE%TYPE,
69: FIRST_NAME PER_ALL_PEOPLE_F.FIRST_NAME%TYPE,
70: FTE_CAPACITY PER_ALL_PEOPLE_F.FTE_CAPACITY%TYPE,
71: FULL_NAME PER_ALL_PEOPLE_F.FULL_NAME%TYPE,
64: DATE_OF_BIRTH varchar2(10),
65: EMAIL_ADDRESS PER_ALL_PEOPLE_F.EMAIL_ADDRESS%TYPE,
66: EMPLOYEE_NUMBER PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%TYPE,
67: EXPENSE_CHECK_SEND_TO_ADDRESS PER_ALL_PEOPLE_F.EXPENSE_CHECK_SEND_TO_ADDRESS%TYPE,
68: FAST_PATH_EMPLOYEE PER_ALL_PEOPLE_F.FAST_PATH_EMPLOYEE%TYPE,
69: FIRST_NAME PER_ALL_PEOPLE_F.FIRST_NAME%TYPE,
70: FTE_CAPACITY PER_ALL_PEOPLE_F.FTE_CAPACITY%TYPE,
71: FULL_NAME PER_ALL_PEOPLE_F.FULL_NAME%TYPE,
72: HOLD_APPLICANT_DATE_UNTIL varchar2(10),
65: EMAIL_ADDRESS PER_ALL_PEOPLE_F.EMAIL_ADDRESS%TYPE,
66: EMPLOYEE_NUMBER PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%TYPE,
67: EXPENSE_CHECK_SEND_TO_ADDRESS PER_ALL_PEOPLE_F.EXPENSE_CHECK_SEND_TO_ADDRESS%TYPE,
68: FAST_PATH_EMPLOYEE PER_ALL_PEOPLE_F.FAST_PATH_EMPLOYEE%TYPE,
69: FIRST_NAME PER_ALL_PEOPLE_F.FIRST_NAME%TYPE,
70: FTE_CAPACITY PER_ALL_PEOPLE_F.FTE_CAPACITY%TYPE,
71: FULL_NAME PER_ALL_PEOPLE_F.FULL_NAME%TYPE,
72: HOLD_APPLICANT_DATE_UNTIL varchar2(10),
73: HONORS PER_ALL_PEOPLE_F.HONORS%TYPE,
66: EMPLOYEE_NUMBER PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%TYPE,
67: EXPENSE_CHECK_SEND_TO_ADDRESS PER_ALL_PEOPLE_F.EXPENSE_CHECK_SEND_TO_ADDRESS%TYPE,
68: FAST_PATH_EMPLOYEE PER_ALL_PEOPLE_F.FAST_PATH_EMPLOYEE%TYPE,
69: FIRST_NAME PER_ALL_PEOPLE_F.FIRST_NAME%TYPE,
70: FTE_CAPACITY PER_ALL_PEOPLE_F.FTE_CAPACITY%TYPE,
71: FULL_NAME PER_ALL_PEOPLE_F.FULL_NAME%TYPE,
72: HOLD_APPLICANT_DATE_UNTIL varchar2(10),
73: HONORS PER_ALL_PEOPLE_F.HONORS%TYPE,
74: INTERNAL_LOCATION PER_ALL_PEOPLE_F.INTERNAL_LOCATION%TYPE,
67: EXPENSE_CHECK_SEND_TO_ADDRESS PER_ALL_PEOPLE_F.EXPENSE_CHECK_SEND_TO_ADDRESS%TYPE,
68: FAST_PATH_EMPLOYEE PER_ALL_PEOPLE_F.FAST_PATH_EMPLOYEE%TYPE,
69: FIRST_NAME PER_ALL_PEOPLE_F.FIRST_NAME%TYPE,
70: FTE_CAPACITY PER_ALL_PEOPLE_F.FTE_CAPACITY%TYPE,
71: FULL_NAME PER_ALL_PEOPLE_F.FULL_NAME%TYPE,
72: HOLD_APPLICANT_DATE_UNTIL varchar2(10),
73: HONORS PER_ALL_PEOPLE_F.HONORS%TYPE,
74: INTERNAL_LOCATION PER_ALL_PEOPLE_F.INTERNAL_LOCATION%TYPE,
75: KNOWN_AS PER_ALL_PEOPLE_F.KNOWN_AS%TYPE,
69: FIRST_NAME PER_ALL_PEOPLE_F.FIRST_NAME%TYPE,
70: FTE_CAPACITY PER_ALL_PEOPLE_F.FTE_CAPACITY%TYPE,
71: FULL_NAME PER_ALL_PEOPLE_F.FULL_NAME%TYPE,
72: HOLD_APPLICANT_DATE_UNTIL varchar2(10),
73: HONORS PER_ALL_PEOPLE_F.HONORS%TYPE,
74: INTERNAL_LOCATION PER_ALL_PEOPLE_F.INTERNAL_LOCATION%TYPE,
75: KNOWN_AS PER_ALL_PEOPLE_F.KNOWN_AS%TYPE,
76: LAST_MEDICAL_TEST_BY PER_ALL_PEOPLE_F.LAST_MEDICAL_TEST_BY%TYPE,
77: LAST_MEDICAL_TEST_DATE varchar2(10),
70: FTE_CAPACITY PER_ALL_PEOPLE_F.FTE_CAPACITY%TYPE,
71: FULL_NAME PER_ALL_PEOPLE_F.FULL_NAME%TYPE,
72: HOLD_APPLICANT_DATE_UNTIL varchar2(10),
73: HONORS PER_ALL_PEOPLE_F.HONORS%TYPE,
74: INTERNAL_LOCATION PER_ALL_PEOPLE_F.INTERNAL_LOCATION%TYPE,
75: KNOWN_AS PER_ALL_PEOPLE_F.KNOWN_AS%TYPE,
76: LAST_MEDICAL_TEST_BY PER_ALL_PEOPLE_F.LAST_MEDICAL_TEST_BY%TYPE,
77: LAST_MEDICAL_TEST_DATE varchar2(10),
78: MAILSTOP PER_ALL_PEOPLE_F.MAILSTOP%TYPE,
71: FULL_NAME PER_ALL_PEOPLE_F.FULL_NAME%TYPE,
72: HOLD_APPLICANT_DATE_UNTIL varchar2(10),
73: HONORS PER_ALL_PEOPLE_F.HONORS%TYPE,
74: INTERNAL_LOCATION PER_ALL_PEOPLE_F.INTERNAL_LOCATION%TYPE,
75: KNOWN_AS PER_ALL_PEOPLE_F.KNOWN_AS%TYPE,
76: LAST_MEDICAL_TEST_BY PER_ALL_PEOPLE_F.LAST_MEDICAL_TEST_BY%TYPE,
77: LAST_MEDICAL_TEST_DATE varchar2(10),
78: MAILSTOP PER_ALL_PEOPLE_F.MAILSTOP%TYPE,
79: MARITAL_STATUS PER_ALL_PEOPLE_F.MARITAL_STATUS%TYPE,
72: HOLD_APPLICANT_DATE_UNTIL varchar2(10),
73: HONORS PER_ALL_PEOPLE_F.HONORS%TYPE,
74: INTERNAL_LOCATION PER_ALL_PEOPLE_F.INTERNAL_LOCATION%TYPE,
75: KNOWN_AS PER_ALL_PEOPLE_F.KNOWN_AS%TYPE,
76: LAST_MEDICAL_TEST_BY PER_ALL_PEOPLE_F.LAST_MEDICAL_TEST_BY%TYPE,
77: LAST_MEDICAL_TEST_DATE varchar2(10),
78: MAILSTOP PER_ALL_PEOPLE_F.MAILSTOP%TYPE,
79: MARITAL_STATUS PER_ALL_PEOPLE_F.MARITAL_STATUS%TYPE,
80: MARITAL_STATUS_DESC FND_LOOKUP_VALUES.MEANING%TYPE,-- (BASED ON LANG /'MARITAL_STATUS')
74: INTERNAL_LOCATION PER_ALL_PEOPLE_F.INTERNAL_LOCATION%TYPE,
75: KNOWN_AS PER_ALL_PEOPLE_F.KNOWN_AS%TYPE,
76: LAST_MEDICAL_TEST_BY PER_ALL_PEOPLE_F.LAST_MEDICAL_TEST_BY%TYPE,
77: LAST_MEDICAL_TEST_DATE varchar2(10),
78: MAILSTOP PER_ALL_PEOPLE_F.MAILSTOP%TYPE,
79: MARITAL_STATUS PER_ALL_PEOPLE_F.MARITAL_STATUS%TYPE,
80: MARITAL_STATUS_DESC FND_LOOKUP_VALUES.MEANING%TYPE,-- (BASED ON LANG /'MARITAL_STATUS')
81: MIDDLE_NAMES PER_ALL_PEOPLE_F.MIDDLE_NAMES%TYPE,
82: NATIONALITY PER_ALL_PEOPLE_F.NATIONALITY%TYPE,
75: KNOWN_AS PER_ALL_PEOPLE_F.KNOWN_AS%TYPE,
76: LAST_MEDICAL_TEST_BY PER_ALL_PEOPLE_F.LAST_MEDICAL_TEST_BY%TYPE,
77: LAST_MEDICAL_TEST_DATE varchar2(10),
78: MAILSTOP PER_ALL_PEOPLE_F.MAILSTOP%TYPE,
79: MARITAL_STATUS PER_ALL_PEOPLE_F.MARITAL_STATUS%TYPE,
80: MARITAL_STATUS_DESC FND_LOOKUP_VALUES.MEANING%TYPE,-- (BASED ON LANG /'MARITAL_STATUS')
81: MIDDLE_NAMES PER_ALL_PEOPLE_F.MIDDLE_NAMES%TYPE,
82: NATIONALITY PER_ALL_PEOPLE_F.NATIONALITY%TYPE,
83: NATIONALITY_DESC FND_LOOKUP_VALUES.MEANING%TYPE,-- (BASED ON LANG /'NATIONALITY')
77: LAST_MEDICAL_TEST_DATE varchar2(10),
78: MAILSTOP PER_ALL_PEOPLE_F.MAILSTOP%TYPE,
79: MARITAL_STATUS PER_ALL_PEOPLE_F.MARITAL_STATUS%TYPE,
80: MARITAL_STATUS_DESC FND_LOOKUP_VALUES.MEANING%TYPE,-- (BASED ON LANG /'MARITAL_STATUS')
81: MIDDLE_NAMES PER_ALL_PEOPLE_F.MIDDLE_NAMES%TYPE,
82: NATIONALITY PER_ALL_PEOPLE_F.NATIONALITY%TYPE,
83: NATIONALITY_DESC FND_LOOKUP_VALUES.MEANING%TYPE,-- (BASED ON LANG /'NATIONALITY')
84: NATIONAL_IDENTIFIER PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER%TYPE,
85: NATIONAL_ID_LABEL VARCHAR2(200),
78: MAILSTOP PER_ALL_PEOPLE_F.MAILSTOP%TYPE,
79: MARITAL_STATUS PER_ALL_PEOPLE_F.MARITAL_STATUS%TYPE,
80: MARITAL_STATUS_DESC FND_LOOKUP_VALUES.MEANING%TYPE,-- (BASED ON LANG /'MARITAL_STATUS')
81: MIDDLE_NAMES PER_ALL_PEOPLE_F.MIDDLE_NAMES%TYPE,
82: NATIONALITY PER_ALL_PEOPLE_F.NATIONALITY%TYPE,
83: NATIONALITY_DESC FND_LOOKUP_VALUES.MEANING%TYPE,-- (BASED ON LANG /'NATIONALITY')
84: NATIONAL_IDENTIFIER PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER%TYPE,
85: NATIONAL_ID_LABEL VARCHAR2(200),
86: OFFICE_NUMBER PER_ALL_PEOPLE_F.OFFICE_NUMBER%TYPE,
80: MARITAL_STATUS_DESC FND_LOOKUP_VALUES.MEANING%TYPE,-- (BASED ON LANG /'MARITAL_STATUS')
81: MIDDLE_NAMES PER_ALL_PEOPLE_F.MIDDLE_NAMES%TYPE,
82: NATIONALITY PER_ALL_PEOPLE_F.NATIONALITY%TYPE,
83: NATIONALITY_DESC FND_LOOKUP_VALUES.MEANING%TYPE,-- (BASED ON LANG /'NATIONALITY')
84: NATIONAL_IDENTIFIER PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER%TYPE,
85: NATIONAL_ID_LABEL VARCHAR2(200),
86: OFFICE_NUMBER PER_ALL_PEOPLE_F.OFFICE_NUMBER%TYPE,
87: ON_MILITARY_SERVICE PER_ALL_PEOPLE_F.ON_MILITARY_SERVICE%TYPE,
88: ORDER_NAME PER_ALL_PEOPLE_F.ORDER_NAME%TYPE,
82: NATIONALITY PER_ALL_PEOPLE_F.NATIONALITY%TYPE,
83: NATIONALITY_DESC FND_LOOKUP_VALUES.MEANING%TYPE,-- (BASED ON LANG /'NATIONALITY')
84: NATIONAL_IDENTIFIER PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER%TYPE,
85: NATIONAL_ID_LABEL VARCHAR2(200),
86: OFFICE_NUMBER PER_ALL_PEOPLE_F.OFFICE_NUMBER%TYPE,
87: ON_MILITARY_SERVICE PER_ALL_PEOPLE_F.ON_MILITARY_SERVICE%TYPE,
88: ORDER_NAME PER_ALL_PEOPLE_F.ORDER_NAME%TYPE,
89: PRE_NAME_ADJUNCT PER_ALL_PEOPLE_F.PRE_NAME_ADJUNCT%TYPE,
90: PREVIOUS_LAST_NAME PER_ALL_PEOPLE_F.PREVIOUS_LAST_NAME%TYPE,
83: NATIONALITY_DESC FND_LOOKUP_VALUES.MEANING%TYPE,-- (BASED ON LANG /'NATIONALITY')
84: NATIONAL_IDENTIFIER PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER%TYPE,
85: NATIONAL_ID_LABEL VARCHAR2(200),
86: OFFICE_NUMBER PER_ALL_PEOPLE_F.OFFICE_NUMBER%TYPE,
87: ON_MILITARY_SERVICE PER_ALL_PEOPLE_F.ON_MILITARY_SERVICE%TYPE,
88: ORDER_NAME PER_ALL_PEOPLE_F.ORDER_NAME%TYPE,
89: PRE_NAME_ADJUNCT PER_ALL_PEOPLE_F.PRE_NAME_ADJUNCT%TYPE,
90: PREVIOUS_LAST_NAME PER_ALL_PEOPLE_F.PREVIOUS_LAST_NAME%TYPE,
91: PROJECTED_START_DATE varchar2(10),
84: NATIONAL_IDENTIFIER PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER%TYPE,
85: NATIONAL_ID_LABEL VARCHAR2(200),
86: OFFICE_NUMBER PER_ALL_PEOPLE_F.OFFICE_NUMBER%TYPE,
87: ON_MILITARY_SERVICE PER_ALL_PEOPLE_F.ON_MILITARY_SERVICE%TYPE,
88: ORDER_NAME PER_ALL_PEOPLE_F.ORDER_NAME%TYPE,
89: PRE_NAME_ADJUNCT PER_ALL_PEOPLE_F.PRE_NAME_ADJUNCT%TYPE,
90: PREVIOUS_LAST_NAME PER_ALL_PEOPLE_F.PREVIOUS_LAST_NAME%TYPE,
91: PROJECTED_START_DATE varchar2(10),
92: REHIRE_AUTHORIZOR PER_ALL_PEOPLE_F.REHIRE_AUTHORIZOR%TYPE,
85: NATIONAL_ID_LABEL VARCHAR2(200),
86: OFFICE_NUMBER PER_ALL_PEOPLE_F.OFFICE_NUMBER%TYPE,
87: ON_MILITARY_SERVICE PER_ALL_PEOPLE_F.ON_MILITARY_SERVICE%TYPE,
88: ORDER_NAME PER_ALL_PEOPLE_F.ORDER_NAME%TYPE,
89: PRE_NAME_ADJUNCT PER_ALL_PEOPLE_F.PRE_NAME_ADJUNCT%TYPE,
90: PREVIOUS_LAST_NAME PER_ALL_PEOPLE_F.PREVIOUS_LAST_NAME%TYPE,
91: PROJECTED_START_DATE varchar2(10),
92: REHIRE_AUTHORIZOR PER_ALL_PEOPLE_F.REHIRE_AUTHORIZOR%TYPE,
93: REHIRE_REASON PER_ALL_PEOPLE_F.REHIRE_REASON%TYPE,
86: OFFICE_NUMBER PER_ALL_PEOPLE_F.OFFICE_NUMBER%TYPE,
87: ON_MILITARY_SERVICE PER_ALL_PEOPLE_F.ON_MILITARY_SERVICE%TYPE,
88: ORDER_NAME PER_ALL_PEOPLE_F.ORDER_NAME%TYPE,
89: PRE_NAME_ADJUNCT PER_ALL_PEOPLE_F.PRE_NAME_ADJUNCT%TYPE,
90: PREVIOUS_LAST_NAME PER_ALL_PEOPLE_F.PREVIOUS_LAST_NAME%TYPE,
91: PROJECTED_START_DATE varchar2(10),
92: REHIRE_AUTHORIZOR PER_ALL_PEOPLE_F.REHIRE_AUTHORIZOR%TYPE,
93: REHIRE_REASON PER_ALL_PEOPLE_F.REHIRE_REASON%TYPE,
94: REHIRE_RECOMMENDATION PER_ALL_PEOPLE_F.REHIRE_RECOMMENDATION%TYPE, -- CHECK BOX
88: ORDER_NAME PER_ALL_PEOPLE_F.ORDER_NAME%TYPE,
89: PRE_NAME_ADJUNCT PER_ALL_PEOPLE_F.PRE_NAME_ADJUNCT%TYPE,
90: PREVIOUS_LAST_NAME PER_ALL_PEOPLE_F.PREVIOUS_LAST_NAME%TYPE,
91: PROJECTED_START_DATE varchar2(10),
92: REHIRE_AUTHORIZOR PER_ALL_PEOPLE_F.REHIRE_AUTHORIZOR%TYPE,
93: REHIRE_REASON PER_ALL_PEOPLE_F.REHIRE_REASON%TYPE,
94: REHIRE_RECOMMENDATION PER_ALL_PEOPLE_F.REHIRE_RECOMMENDATION%TYPE, -- CHECK BOX
95: RESUME_EXISTS PER_ALL_PEOPLE_F.RESUME_EXISTS%TYPE, -- (CHECK BOX)
96: RESUME_LAST_UPDATED varchar2(10),
89: PRE_NAME_ADJUNCT PER_ALL_PEOPLE_F.PRE_NAME_ADJUNCT%TYPE,
90: PREVIOUS_LAST_NAME PER_ALL_PEOPLE_F.PREVIOUS_LAST_NAME%TYPE,
91: PROJECTED_START_DATE varchar2(10),
92: REHIRE_AUTHORIZOR PER_ALL_PEOPLE_F.REHIRE_AUTHORIZOR%TYPE,
93: REHIRE_REASON PER_ALL_PEOPLE_F.REHIRE_REASON%TYPE,
94: REHIRE_RECOMMENDATION PER_ALL_PEOPLE_F.REHIRE_RECOMMENDATION%TYPE, -- CHECK BOX
95: RESUME_EXISTS PER_ALL_PEOPLE_F.RESUME_EXISTS%TYPE, -- (CHECK BOX)
96: RESUME_LAST_UPDATED varchar2(10),
97: REGISTERED_DISABLED_FLAG PER_ALL_PEOPLE_F.REGISTERED_DISABLED_FLAG%TYPE,
90: PREVIOUS_LAST_NAME PER_ALL_PEOPLE_F.PREVIOUS_LAST_NAME%TYPE,
91: PROJECTED_START_DATE varchar2(10),
92: REHIRE_AUTHORIZOR PER_ALL_PEOPLE_F.REHIRE_AUTHORIZOR%TYPE,
93: REHIRE_REASON PER_ALL_PEOPLE_F.REHIRE_REASON%TYPE,
94: REHIRE_RECOMMENDATION PER_ALL_PEOPLE_F.REHIRE_RECOMMENDATION%TYPE, -- CHECK BOX
95: RESUME_EXISTS PER_ALL_PEOPLE_F.RESUME_EXISTS%TYPE, -- (CHECK BOX)
96: RESUME_LAST_UPDATED varchar2(10),
97: REGISTERED_DISABLED_FLAG PER_ALL_PEOPLE_F.REGISTERED_DISABLED_FLAG%TYPE,
98: SECOND_PASSPORT_EXISTS PER_ALL_PEOPLE_F.SECOND_PASSPORT_EXISTS%TYPE, -- CHECK BOX
91: PROJECTED_START_DATE varchar2(10),
92: REHIRE_AUTHORIZOR PER_ALL_PEOPLE_F.REHIRE_AUTHORIZOR%TYPE,
93: REHIRE_REASON PER_ALL_PEOPLE_F.REHIRE_REASON%TYPE,
94: REHIRE_RECOMMENDATION PER_ALL_PEOPLE_F.REHIRE_RECOMMENDATION%TYPE, -- CHECK BOX
95: RESUME_EXISTS PER_ALL_PEOPLE_F.RESUME_EXISTS%TYPE, -- (CHECK BOX)
96: RESUME_LAST_UPDATED varchar2(10),
97: REGISTERED_DISABLED_FLAG PER_ALL_PEOPLE_F.REGISTERED_DISABLED_FLAG%TYPE,
98: SECOND_PASSPORT_EXISTS PER_ALL_PEOPLE_F.SECOND_PASSPORT_EXISTS%TYPE, -- CHECK BOX
99: SEX PER_ALL_PEOPLE_F.SEX%TYPE,
93: REHIRE_REASON PER_ALL_PEOPLE_F.REHIRE_REASON%TYPE,
94: REHIRE_RECOMMENDATION PER_ALL_PEOPLE_F.REHIRE_RECOMMENDATION%TYPE, -- CHECK BOX
95: RESUME_EXISTS PER_ALL_PEOPLE_F.RESUME_EXISTS%TYPE, -- (CHECK BOX)
96: RESUME_LAST_UPDATED varchar2(10),
97: REGISTERED_DISABLED_FLAG PER_ALL_PEOPLE_F.REGISTERED_DISABLED_FLAG%TYPE,
98: SECOND_PASSPORT_EXISTS PER_ALL_PEOPLE_F.SECOND_PASSPORT_EXISTS%TYPE, -- CHECK BOX
99: SEX PER_ALL_PEOPLE_F.SEX%TYPE,
100: SEX_DESC FND_LOOKUP_VALUES.MEANING%TYPE,-- (BASED ON LANG /'SEX')
101: STUDENT_STATUS PER_ALL_PEOPLE_F.STUDENT_STATUS%TYPE,
94: REHIRE_RECOMMENDATION PER_ALL_PEOPLE_F.REHIRE_RECOMMENDATION%TYPE, -- CHECK BOX
95: RESUME_EXISTS PER_ALL_PEOPLE_F.RESUME_EXISTS%TYPE, -- (CHECK BOX)
96: RESUME_LAST_UPDATED varchar2(10),
97: REGISTERED_DISABLED_FLAG PER_ALL_PEOPLE_F.REGISTERED_DISABLED_FLAG%TYPE,
98: SECOND_PASSPORT_EXISTS PER_ALL_PEOPLE_F.SECOND_PASSPORT_EXISTS%TYPE, -- CHECK BOX
99: SEX PER_ALL_PEOPLE_F.SEX%TYPE,
100: SEX_DESC FND_LOOKUP_VALUES.MEANING%TYPE,-- (BASED ON LANG /'SEX')
101: STUDENT_STATUS PER_ALL_PEOPLE_F.STUDENT_STATUS%TYPE,
102: STUDENT_STATUS_DESC FND_LOOKUP_VALUES.MEANING%TYPE,-- (BASED ON LANG /'STUDENT_STATUS')
95: RESUME_EXISTS PER_ALL_PEOPLE_F.RESUME_EXISTS%TYPE, -- (CHECK BOX)
96: RESUME_LAST_UPDATED varchar2(10),
97: REGISTERED_DISABLED_FLAG PER_ALL_PEOPLE_F.REGISTERED_DISABLED_FLAG%TYPE,
98: SECOND_PASSPORT_EXISTS PER_ALL_PEOPLE_F.SECOND_PASSPORT_EXISTS%TYPE, -- CHECK BOX
99: SEX PER_ALL_PEOPLE_F.SEX%TYPE,
100: SEX_DESC FND_LOOKUP_VALUES.MEANING%TYPE,-- (BASED ON LANG /'SEX')
101: STUDENT_STATUS PER_ALL_PEOPLE_F.STUDENT_STATUS%TYPE,
102: STUDENT_STATUS_DESC FND_LOOKUP_VALUES.MEANING%TYPE,-- (BASED ON LANG /'STUDENT_STATUS')
103: SUFFIX PER_ALL_PEOPLE_F.SUFFIX%TYPE,
97: REGISTERED_DISABLED_FLAG PER_ALL_PEOPLE_F.REGISTERED_DISABLED_FLAG%TYPE,
98: SECOND_PASSPORT_EXISTS PER_ALL_PEOPLE_F.SECOND_PASSPORT_EXISTS%TYPE, -- CHECK BOX
99: SEX PER_ALL_PEOPLE_F.SEX%TYPE,
100: SEX_DESC FND_LOOKUP_VALUES.MEANING%TYPE,-- (BASED ON LANG /'SEX')
101: STUDENT_STATUS PER_ALL_PEOPLE_F.STUDENT_STATUS%TYPE,
102: STUDENT_STATUS_DESC FND_LOOKUP_VALUES.MEANING%TYPE,-- (BASED ON LANG /'STUDENT_STATUS')
103: SUFFIX PER_ALL_PEOPLE_F.SUFFIX%TYPE,
104: TITLE PER_ALL_PEOPLE_F.TITLE%TYPE,
105: TITLE_DESC FND_LOOKUP_VALUES.MEANING%TYPE,-- (BASED ON LANG /'TITLE')
99: SEX PER_ALL_PEOPLE_F.SEX%TYPE,
100: SEX_DESC FND_LOOKUP_VALUES.MEANING%TYPE,-- (BASED ON LANG /'SEX')
101: STUDENT_STATUS PER_ALL_PEOPLE_F.STUDENT_STATUS%TYPE,
102: STUDENT_STATUS_DESC FND_LOOKUP_VALUES.MEANING%TYPE,-- (BASED ON LANG /'STUDENT_STATUS')
103: SUFFIX PER_ALL_PEOPLE_F.SUFFIX%TYPE,
104: TITLE PER_ALL_PEOPLE_F.TITLE%TYPE,
105: TITLE_DESC FND_LOOKUP_VALUES.MEANING%TYPE,-- (BASED ON LANG /'TITLE')
106: VENDOR_ID PER_ALL_PEOPLE_F.VENDOR_ID%TYPE,
107: WORK_SCHEDULE PER_ALL_PEOPLE_F.WORK_SCHEDULE%TYPE,
100: SEX_DESC FND_LOOKUP_VALUES.MEANING%TYPE,-- (BASED ON LANG /'SEX')
101: STUDENT_STATUS PER_ALL_PEOPLE_F.STUDENT_STATUS%TYPE,
102: STUDENT_STATUS_DESC FND_LOOKUP_VALUES.MEANING%TYPE,-- (BASED ON LANG /'STUDENT_STATUS')
103: SUFFIX PER_ALL_PEOPLE_F.SUFFIX%TYPE,
104: TITLE PER_ALL_PEOPLE_F.TITLE%TYPE,
105: TITLE_DESC FND_LOOKUP_VALUES.MEANING%TYPE,-- (BASED ON LANG /'TITLE')
106: VENDOR_ID PER_ALL_PEOPLE_F.VENDOR_ID%TYPE,
107: WORK_SCHEDULE PER_ALL_PEOPLE_F.WORK_SCHEDULE%TYPE,
108: WORK_SCHEDULE_DESC FND_LOOKUP_VALUES.MEANING%TYPE,-- (BASED ON LANG /'WORK_SCHEDULE')
102: STUDENT_STATUS_DESC FND_LOOKUP_VALUES.MEANING%TYPE,-- (BASED ON LANG /'STUDENT_STATUS')
103: SUFFIX PER_ALL_PEOPLE_F.SUFFIX%TYPE,
104: TITLE PER_ALL_PEOPLE_F.TITLE%TYPE,
105: TITLE_DESC FND_LOOKUP_VALUES.MEANING%TYPE,-- (BASED ON LANG /'TITLE')
106: VENDOR_ID PER_ALL_PEOPLE_F.VENDOR_ID%TYPE,
107: WORK_SCHEDULE PER_ALL_PEOPLE_F.WORK_SCHEDULE%TYPE,
108: WORK_SCHEDULE_DESC FND_LOOKUP_VALUES.MEANING%TYPE,-- (BASED ON LANG /'WORK_SCHEDULE')
109: WORK_TELEPHONE PER_ALL_PEOPLE_F.WORK_TELEPHONE%TYPE,
110: COORD_BEN_MED_PLN_NO PER_ALL_PEOPLE_F.COORD_BEN_MED_PLN_NO%TYPE,
103: SUFFIX PER_ALL_PEOPLE_F.SUFFIX%TYPE,
104: TITLE PER_ALL_PEOPLE_F.TITLE%TYPE,
105: TITLE_DESC FND_LOOKUP_VALUES.MEANING%TYPE,-- (BASED ON LANG /'TITLE')
106: VENDOR_ID PER_ALL_PEOPLE_F.VENDOR_ID%TYPE,
107: WORK_SCHEDULE PER_ALL_PEOPLE_F.WORK_SCHEDULE%TYPE,
108: WORK_SCHEDULE_DESC FND_LOOKUP_VALUES.MEANING%TYPE,-- (BASED ON LANG /'WORK_SCHEDULE')
109: WORK_TELEPHONE PER_ALL_PEOPLE_F.WORK_TELEPHONE%TYPE,
110: COORD_BEN_MED_PLN_NO PER_ALL_PEOPLE_F.COORD_BEN_MED_PLN_NO%TYPE,
111: COORD_BEN_NO_CVG_FLAG PER_ALL_PEOPLE_F.COORD_BEN_NO_CVG_FLAG%TYPE, -- CHECK BOX
105: TITLE_DESC FND_LOOKUP_VALUES.MEANING%TYPE,-- (BASED ON LANG /'TITLE')
106: VENDOR_ID PER_ALL_PEOPLE_F.VENDOR_ID%TYPE,
107: WORK_SCHEDULE PER_ALL_PEOPLE_F.WORK_SCHEDULE%TYPE,
108: WORK_SCHEDULE_DESC FND_LOOKUP_VALUES.MEANING%TYPE,-- (BASED ON LANG /'WORK_SCHEDULE')
109: WORK_TELEPHONE PER_ALL_PEOPLE_F.WORK_TELEPHONE%TYPE,
110: COORD_BEN_MED_PLN_NO PER_ALL_PEOPLE_F.COORD_BEN_MED_PLN_NO%TYPE,
111: COORD_BEN_NO_CVG_FLAG PER_ALL_PEOPLE_F.COORD_BEN_NO_CVG_FLAG%TYPE, -- CHECK BOX
112: DPDNT_ADOPTION_DATE varchar2(10),
113: DPDNT_VLNTRY_SVCE_FLAG PER_ALL_PEOPLE_F.DPDNT_VLNTRY_SVCE_FLAG%TYPE, -- CHECK BOX
106: VENDOR_ID PER_ALL_PEOPLE_F.VENDOR_ID%TYPE,
107: WORK_SCHEDULE PER_ALL_PEOPLE_F.WORK_SCHEDULE%TYPE,
108: WORK_SCHEDULE_DESC FND_LOOKUP_VALUES.MEANING%TYPE,-- (BASED ON LANG /'WORK_SCHEDULE')
109: WORK_TELEPHONE PER_ALL_PEOPLE_F.WORK_TELEPHONE%TYPE,
110: COORD_BEN_MED_PLN_NO PER_ALL_PEOPLE_F.COORD_BEN_MED_PLN_NO%TYPE,
111: COORD_BEN_NO_CVG_FLAG PER_ALL_PEOPLE_F.COORD_BEN_NO_CVG_FLAG%TYPE, -- CHECK BOX
112: DPDNT_ADOPTION_DATE varchar2(10),
113: DPDNT_VLNTRY_SVCE_FLAG PER_ALL_PEOPLE_F.DPDNT_VLNTRY_SVCE_FLAG%TYPE, -- CHECK BOX
114: RECEIPT_OF_DEATH_CERT_DATE varchar2(10),
107: WORK_SCHEDULE PER_ALL_PEOPLE_F.WORK_SCHEDULE%TYPE,
108: WORK_SCHEDULE_DESC FND_LOOKUP_VALUES.MEANING%TYPE,-- (BASED ON LANG /'WORK_SCHEDULE')
109: WORK_TELEPHONE PER_ALL_PEOPLE_F.WORK_TELEPHONE%TYPE,
110: COORD_BEN_MED_PLN_NO PER_ALL_PEOPLE_F.COORD_BEN_MED_PLN_NO%TYPE,
111: COORD_BEN_NO_CVG_FLAG PER_ALL_PEOPLE_F.COORD_BEN_NO_CVG_FLAG%TYPE, -- CHECK BOX
112: DPDNT_ADOPTION_DATE varchar2(10),
113: DPDNT_VLNTRY_SVCE_FLAG PER_ALL_PEOPLE_F.DPDNT_VLNTRY_SVCE_FLAG%TYPE, -- CHECK BOX
114: RECEIPT_OF_DEATH_CERT_DATE varchar2(10),
115: USES_TOBACCO_FLAG PER_ALL_PEOPLE_F.USES_TOBACCO_FLAG%TYPE,
109: WORK_TELEPHONE PER_ALL_PEOPLE_F.WORK_TELEPHONE%TYPE,
110: COORD_BEN_MED_PLN_NO PER_ALL_PEOPLE_F.COORD_BEN_MED_PLN_NO%TYPE,
111: COORD_BEN_NO_CVG_FLAG PER_ALL_PEOPLE_F.COORD_BEN_NO_CVG_FLAG%TYPE, -- CHECK BOX
112: DPDNT_ADOPTION_DATE varchar2(10),
113: DPDNT_VLNTRY_SVCE_FLAG PER_ALL_PEOPLE_F.DPDNT_VLNTRY_SVCE_FLAG%TYPE, -- CHECK BOX
114: RECEIPT_OF_DEATH_CERT_DATE varchar2(10),
115: USES_TOBACCO_FLAG PER_ALL_PEOPLE_F.USES_TOBACCO_FLAG%TYPE,
116: USES_TOBACCO_FLAG_DESC FND_LOOKUP_VALUES.MEANING%TYPE, -- (BASED ON LANG /'TOBACCO_USER')
117: BENEFIT_GROUP_ID PER_ALL_PEOPLE_F.BENEFIT_GROUP_ID%TYPE,
111: COORD_BEN_NO_CVG_FLAG PER_ALL_PEOPLE_F.COORD_BEN_NO_CVG_FLAG%TYPE, -- CHECK BOX
112: DPDNT_ADOPTION_DATE varchar2(10),
113: DPDNT_VLNTRY_SVCE_FLAG PER_ALL_PEOPLE_F.DPDNT_VLNTRY_SVCE_FLAG%TYPE, -- CHECK BOX
114: RECEIPT_OF_DEATH_CERT_DATE varchar2(10),
115: USES_TOBACCO_FLAG PER_ALL_PEOPLE_F.USES_TOBACCO_FLAG%TYPE,
116: USES_TOBACCO_FLAG_DESC FND_LOOKUP_VALUES.MEANING%TYPE, -- (BASED ON LANG /'TOBACCO_USER')
117: BENEFIT_GROUP_ID PER_ALL_PEOPLE_F.BENEFIT_GROUP_ID%TYPE,
118: BENEFIT_GROUP_NAME BEN_BENFTS_GRP.NAME%TYPE,
119: ATTRIBUTE_CATEGORY PER_ALL_PEOPLE_F.ATTRIBUTE_CATEGORY%TYPE,
113: DPDNT_VLNTRY_SVCE_FLAG PER_ALL_PEOPLE_F.DPDNT_VLNTRY_SVCE_FLAG%TYPE, -- CHECK BOX
114: RECEIPT_OF_DEATH_CERT_DATE varchar2(10),
115: USES_TOBACCO_FLAG PER_ALL_PEOPLE_F.USES_TOBACCO_FLAG%TYPE,
116: USES_TOBACCO_FLAG_DESC FND_LOOKUP_VALUES.MEANING%TYPE, -- (BASED ON LANG /'TOBACCO_USER')
117: BENEFIT_GROUP_ID PER_ALL_PEOPLE_F.BENEFIT_GROUP_ID%TYPE,
118: BENEFIT_GROUP_NAME BEN_BENFTS_GRP.NAME%TYPE,
119: ATTRIBUTE_CATEGORY PER_ALL_PEOPLE_F.ATTRIBUTE_CATEGORY%TYPE,
120: ATTRIBUTE1 PER_ALL_PEOPLE_F.ATTRIBUTE1%TYPE,
121: ATTRIBUTE2 PER_ALL_PEOPLE_F.ATTRIBUTE2%TYPE,
115: USES_TOBACCO_FLAG PER_ALL_PEOPLE_F.USES_TOBACCO_FLAG%TYPE,
116: USES_TOBACCO_FLAG_DESC FND_LOOKUP_VALUES.MEANING%TYPE, -- (BASED ON LANG /'TOBACCO_USER')
117: BENEFIT_GROUP_ID PER_ALL_PEOPLE_F.BENEFIT_GROUP_ID%TYPE,
118: BENEFIT_GROUP_NAME BEN_BENFTS_GRP.NAME%TYPE,
119: ATTRIBUTE_CATEGORY PER_ALL_PEOPLE_F.ATTRIBUTE_CATEGORY%TYPE,
120: ATTRIBUTE1 PER_ALL_PEOPLE_F.ATTRIBUTE1%TYPE,
121: ATTRIBUTE2 PER_ALL_PEOPLE_F.ATTRIBUTE2%TYPE,
122: ATTRIBUTE3 PER_ALL_PEOPLE_F.ATTRIBUTE3%TYPE,
123: ATTRIBUTE4 PER_ALL_PEOPLE_F.ATTRIBUTE4%TYPE,
116: USES_TOBACCO_FLAG_DESC FND_LOOKUP_VALUES.MEANING%TYPE, -- (BASED ON LANG /'TOBACCO_USER')
117: BENEFIT_GROUP_ID PER_ALL_PEOPLE_F.BENEFIT_GROUP_ID%TYPE,
118: BENEFIT_GROUP_NAME BEN_BENFTS_GRP.NAME%TYPE,
119: ATTRIBUTE_CATEGORY PER_ALL_PEOPLE_F.ATTRIBUTE_CATEGORY%TYPE,
120: ATTRIBUTE1 PER_ALL_PEOPLE_F.ATTRIBUTE1%TYPE,
121: ATTRIBUTE2 PER_ALL_PEOPLE_F.ATTRIBUTE2%TYPE,
122: ATTRIBUTE3 PER_ALL_PEOPLE_F.ATTRIBUTE3%TYPE,
123: ATTRIBUTE4 PER_ALL_PEOPLE_F.ATTRIBUTE4%TYPE,
124: ATTRIBUTE5 PER_ALL_PEOPLE_F.ATTRIBUTE5%TYPE,
117: BENEFIT_GROUP_ID PER_ALL_PEOPLE_F.BENEFIT_GROUP_ID%TYPE,
118: BENEFIT_GROUP_NAME BEN_BENFTS_GRP.NAME%TYPE,
119: ATTRIBUTE_CATEGORY PER_ALL_PEOPLE_F.ATTRIBUTE_CATEGORY%TYPE,
120: ATTRIBUTE1 PER_ALL_PEOPLE_F.ATTRIBUTE1%TYPE,
121: ATTRIBUTE2 PER_ALL_PEOPLE_F.ATTRIBUTE2%TYPE,
122: ATTRIBUTE3 PER_ALL_PEOPLE_F.ATTRIBUTE3%TYPE,
123: ATTRIBUTE4 PER_ALL_PEOPLE_F.ATTRIBUTE4%TYPE,
124: ATTRIBUTE5 PER_ALL_PEOPLE_F.ATTRIBUTE5%TYPE,
125: ATTRIBUTE6 PER_ALL_PEOPLE_F.ATTRIBUTE6%TYPE,
118: BENEFIT_GROUP_NAME BEN_BENFTS_GRP.NAME%TYPE,
119: ATTRIBUTE_CATEGORY PER_ALL_PEOPLE_F.ATTRIBUTE_CATEGORY%TYPE,
120: ATTRIBUTE1 PER_ALL_PEOPLE_F.ATTRIBUTE1%TYPE,
121: ATTRIBUTE2 PER_ALL_PEOPLE_F.ATTRIBUTE2%TYPE,
122: ATTRIBUTE3 PER_ALL_PEOPLE_F.ATTRIBUTE3%TYPE,
123: ATTRIBUTE4 PER_ALL_PEOPLE_F.ATTRIBUTE4%TYPE,
124: ATTRIBUTE5 PER_ALL_PEOPLE_F.ATTRIBUTE5%TYPE,
125: ATTRIBUTE6 PER_ALL_PEOPLE_F.ATTRIBUTE6%TYPE,
126: ATTRIBUTE7 PER_ALL_PEOPLE_F.ATTRIBUTE7%TYPE,
119: ATTRIBUTE_CATEGORY PER_ALL_PEOPLE_F.ATTRIBUTE_CATEGORY%TYPE,
120: ATTRIBUTE1 PER_ALL_PEOPLE_F.ATTRIBUTE1%TYPE,
121: ATTRIBUTE2 PER_ALL_PEOPLE_F.ATTRIBUTE2%TYPE,
122: ATTRIBUTE3 PER_ALL_PEOPLE_F.ATTRIBUTE3%TYPE,
123: ATTRIBUTE4 PER_ALL_PEOPLE_F.ATTRIBUTE4%TYPE,
124: ATTRIBUTE5 PER_ALL_PEOPLE_F.ATTRIBUTE5%TYPE,
125: ATTRIBUTE6 PER_ALL_PEOPLE_F.ATTRIBUTE6%TYPE,
126: ATTRIBUTE7 PER_ALL_PEOPLE_F.ATTRIBUTE7%TYPE,
127: ATTRIBUTE8 PER_ALL_PEOPLE_F.ATTRIBUTE8%TYPE,
120: ATTRIBUTE1 PER_ALL_PEOPLE_F.ATTRIBUTE1%TYPE,
121: ATTRIBUTE2 PER_ALL_PEOPLE_F.ATTRIBUTE2%TYPE,
122: ATTRIBUTE3 PER_ALL_PEOPLE_F.ATTRIBUTE3%TYPE,
123: ATTRIBUTE4 PER_ALL_PEOPLE_F.ATTRIBUTE4%TYPE,
124: ATTRIBUTE5 PER_ALL_PEOPLE_F.ATTRIBUTE5%TYPE,
125: ATTRIBUTE6 PER_ALL_PEOPLE_F.ATTRIBUTE6%TYPE,
126: ATTRIBUTE7 PER_ALL_PEOPLE_F.ATTRIBUTE7%TYPE,
127: ATTRIBUTE8 PER_ALL_PEOPLE_F.ATTRIBUTE8%TYPE,
128: ATTRIBUTE9 PER_ALL_PEOPLE_F.ATTRIBUTE9%TYPE,
121: ATTRIBUTE2 PER_ALL_PEOPLE_F.ATTRIBUTE2%TYPE,
122: ATTRIBUTE3 PER_ALL_PEOPLE_F.ATTRIBUTE3%TYPE,
123: ATTRIBUTE4 PER_ALL_PEOPLE_F.ATTRIBUTE4%TYPE,
124: ATTRIBUTE5 PER_ALL_PEOPLE_F.ATTRIBUTE5%TYPE,
125: ATTRIBUTE6 PER_ALL_PEOPLE_F.ATTRIBUTE6%TYPE,
126: ATTRIBUTE7 PER_ALL_PEOPLE_F.ATTRIBUTE7%TYPE,
127: ATTRIBUTE8 PER_ALL_PEOPLE_F.ATTRIBUTE8%TYPE,
128: ATTRIBUTE9 PER_ALL_PEOPLE_F.ATTRIBUTE9%TYPE,
129: ATTRIBUTE10 PER_ALL_PEOPLE_F.ATTRIBUTE10%TYPE,
122: ATTRIBUTE3 PER_ALL_PEOPLE_F.ATTRIBUTE3%TYPE,
123: ATTRIBUTE4 PER_ALL_PEOPLE_F.ATTRIBUTE4%TYPE,
124: ATTRIBUTE5 PER_ALL_PEOPLE_F.ATTRIBUTE5%TYPE,
125: ATTRIBUTE6 PER_ALL_PEOPLE_F.ATTRIBUTE6%TYPE,
126: ATTRIBUTE7 PER_ALL_PEOPLE_F.ATTRIBUTE7%TYPE,
127: ATTRIBUTE8 PER_ALL_PEOPLE_F.ATTRIBUTE8%TYPE,
128: ATTRIBUTE9 PER_ALL_PEOPLE_F.ATTRIBUTE9%TYPE,
129: ATTRIBUTE10 PER_ALL_PEOPLE_F.ATTRIBUTE10%TYPE,
130: ATTRIBUTE11 PER_ALL_PEOPLE_F.ATTRIBUTE11%TYPE,
123: ATTRIBUTE4 PER_ALL_PEOPLE_F.ATTRIBUTE4%TYPE,
124: ATTRIBUTE5 PER_ALL_PEOPLE_F.ATTRIBUTE5%TYPE,
125: ATTRIBUTE6 PER_ALL_PEOPLE_F.ATTRIBUTE6%TYPE,
126: ATTRIBUTE7 PER_ALL_PEOPLE_F.ATTRIBUTE7%TYPE,
127: ATTRIBUTE8 PER_ALL_PEOPLE_F.ATTRIBUTE8%TYPE,
128: ATTRIBUTE9 PER_ALL_PEOPLE_F.ATTRIBUTE9%TYPE,
129: ATTRIBUTE10 PER_ALL_PEOPLE_F.ATTRIBUTE10%TYPE,
130: ATTRIBUTE11 PER_ALL_PEOPLE_F.ATTRIBUTE11%TYPE,
131: ATTRIBUTE12 PER_ALL_PEOPLE_F.ATTRIBUTE12%TYPE,
124: ATTRIBUTE5 PER_ALL_PEOPLE_F.ATTRIBUTE5%TYPE,
125: ATTRIBUTE6 PER_ALL_PEOPLE_F.ATTRIBUTE6%TYPE,
126: ATTRIBUTE7 PER_ALL_PEOPLE_F.ATTRIBUTE7%TYPE,
127: ATTRIBUTE8 PER_ALL_PEOPLE_F.ATTRIBUTE8%TYPE,
128: ATTRIBUTE9 PER_ALL_PEOPLE_F.ATTRIBUTE9%TYPE,
129: ATTRIBUTE10 PER_ALL_PEOPLE_F.ATTRIBUTE10%TYPE,
130: ATTRIBUTE11 PER_ALL_PEOPLE_F.ATTRIBUTE11%TYPE,
131: ATTRIBUTE12 PER_ALL_PEOPLE_F.ATTRIBUTE12%TYPE,
132: ATTRIBUTE13 PER_ALL_PEOPLE_F.ATTRIBUTE13%TYPE,
125: ATTRIBUTE6 PER_ALL_PEOPLE_F.ATTRIBUTE6%TYPE,
126: ATTRIBUTE7 PER_ALL_PEOPLE_F.ATTRIBUTE7%TYPE,
127: ATTRIBUTE8 PER_ALL_PEOPLE_F.ATTRIBUTE8%TYPE,
128: ATTRIBUTE9 PER_ALL_PEOPLE_F.ATTRIBUTE9%TYPE,
129: ATTRIBUTE10 PER_ALL_PEOPLE_F.ATTRIBUTE10%TYPE,
130: ATTRIBUTE11 PER_ALL_PEOPLE_F.ATTRIBUTE11%TYPE,
131: ATTRIBUTE12 PER_ALL_PEOPLE_F.ATTRIBUTE12%TYPE,
132: ATTRIBUTE13 PER_ALL_PEOPLE_F.ATTRIBUTE13%TYPE,
133: ATTRIBUTE14 PER_ALL_PEOPLE_F.ATTRIBUTE14%TYPE,
126: ATTRIBUTE7 PER_ALL_PEOPLE_F.ATTRIBUTE7%TYPE,
127: ATTRIBUTE8 PER_ALL_PEOPLE_F.ATTRIBUTE8%TYPE,
128: ATTRIBUTE9 PER_ALL_PEOPLE_F.ATTRIBUTE9%TYPE,
129: ATTRIBUTE10 PER_ALL_PEOPLE_F.ATTRIBUTE10%TYPE,
130: ATTRIBUTE11 PER_ALL_PEOPLE_F.ATTRIBUTE11%TYPE,
131: ATTRIBUTE12 PER_ALL_PEOPLE_F.ATTRIBUTE12%TYPE,
132: ATTRIBUTE13 PER_ALL_PEOPLE_F.ATTRIBUTE13%TYPE,
133: ATTRIBUTE14 PER_ALL_PEOPLE_F.ATTRIBUTE14%TYPE,
134: ATTRIBUTE15 PER_ALL_PEOPLE_F.ATTRIBUTE15%TYPE,
127: ATTRIBUTE8 PER_ALL_PEOPLE_F.ATTRIBUTE8%TYPE,
128: ATTRIBUTE9 PER_ALL_PEOPLE_F.ATTRIBUTE9%TYPE,
129: ATTRIBUTE10 PER_ALL_PEOPLE_F.ATTRIBUTE10%TYPE,
130: ATTRIBUTE11 PER_ALL_PEOPLE_F.ATTRIBUTE11%TYPE,
131: ATTRIBUTE12 PER_ALL_PEOPLE_F.ATTRIBUTE12%TYPE,
132: ATTRIBUTE13 PER_ALL_PEOPLE_F.ATTRIBUTE13%TYPE,
133: ATTRIBUTE14 PER_ALL_PEOPLE_F.ATTRIBUTE14%TYPE,
134: ATTRIBUTE15 PER_ALL_PEOPLE_F.ATTRIBUTE15%TYPE,
135: ATTRIBUTE16 PER_ALL_PEOPLE_F.ATTRIBUTE16%TYPE,
128: ATTRIBUTE9 PER_ALL_PEOPLE_F.ATTRIBUTE9%TYPE,
129: ATTRIBUTE10 PER_ALL_PEOPLE_F.ATTRIBUTE10%TYPE,
130: ATTRIBUTE11 PER_ALL_PEOPLE_F.ATTRIBUTE11%TYPE,
131: ATTRIBUTE12 PER_ALL_PEOPLE_F.ATTRIBUTE12%TYPE,
132: ATTRIBUTE13 PER_ALL_PEOPLE_F.ATTRIBUTE13%TYPE,
133: ATTRIBUTE14 PER_ALL_PEOPLE_F.ATTRIBUTE14%TYPE,
134: ATTRIBUTE15 PER_ALL_PEOPLE_F.ATTRIBUTE15%TYPE,
135: ATTRIBUTE16 PER_ALL_PEOPLE_F.ATTRIBUTE16%TYPE,
136: ATTRIBUTE17 PER_ALL_PEOPLE_F.ATTRIBUTE17%TYPE,
129: ATTRIBUTE10 PER_ALL_PEOPLE_F.ATTRIBUTE10%TYPE,
130: ATTRIBUTE11 PER_ALL_PEOPLE_F.ATTRIBUTE11%TYPE,
131: ATTRIBUTE12 PER_ALL_PEOPLE_F.ATTRIBUTE12%TYPE,
132: ATTRIBUTE13 PER_ALL_PEOPLE_F.ATTRIBUTE13%TYPE,
133: ATTRIBUTE14 PER_ALL_PEOPLE_F.ATTRIBUTE14%TYPE,
134: ATTRIBUTE15 PER_ALL_PEOPLE_F.ATTRIBUTE15%TYPE,
135: ATTRIBUTE16 PER_ALL_PEOPLE_F.ATTRIBUTE16%TYPE,
136: ATTRIBUTE17 PER_ALL_PEOPLE_F.ATTRIBUTE17%TYPE,
137: ATTRIBUTE18 PER_ALL_PEOPLE_F.ATTRIBUTE18%TYPE,
130: ATTRIBUTE11 PER_ALL_PEOPLE_F.ATTRIBUTE11%TYPE,
131: ATTRIBUTE12 PER_ALL_PEOPLE_F.ATTRIBUTE12%TYPE,
132: ATTRIBUTE13 PER_ALL_PEOPLE_F.ATTRIBUTE13%TYPE,
133: ATTRIBUTE14 PER_ALL_PEOPLE_F.ATTRIBUTE14%TYPE,
134: ATTRIBUTE15 PER_ALL_PEOPLE_F.ATTRIBUTE15%TYPE,
135: ATTRIBUTE16 PER_ALL_PEOPLE_F.ATTRIBUTE16%TYPE,
136: ATTRIBUTE17 PER_ALL_PEOPLE_F.ATTRIBUTE17%TYPE,
137: ATTRIBUTE18 PER_ALL_PEOPLE_F.ATTRIBUTE18%TYPE,
138: ATTRIBUTE19 PER_ALL_PEOPLE_F.ATTRIBUTE19%TYPE,
131: ATTRIBUTE12 PER_ALL_PEOPLE_F.ATTRIBUTE12%TYPE,
132: ATTRIBUTE13 PER_ALL_PEOPLE_F.ATTRIBUTE13%TYPE,
133: ATTRIBUTE14 PER_ALL_PEOPLE_F.ATTRIBUTE14%TYPE,
134: ATTRIBUTE15 PER_ALL_PEOPLE_F.ATTRIBUTE15%TYPE,
135: ATTRIBUTE16 PER_ALL_PEOPLE_F.ATTRIBUTE16%TYPE,
136: ATTRIBUTE17 PER_ALL_PEOPLE_F.ATTRIBUTE17%TYPE,
137: ATTRIBUTE18 PER_ALL_PEOPLE_F.ATTRIBUTE18%TYPE,
138: ATTRIBUTE19 PER_ALL_PEOPLE_F.ATTRIBUTE19%TYPE,
139: ATTRIBUTE20 PER_ALL_PEOPLE_F.ATTRIBUTE20%TYPE,
132: ATTRIBUTE13 PER_ALL_PEOPLE_F.ATTRIBUTE13%TYPE,
133: ATTRIBUTE14 PER_ALL_PEOPLE_F.ATTRIBUTE14%TYPE,
134: ATTRIBUTE15 PER_ALL_PEOPLE_F.ATTRIBUTE15%TYPE,
135: ATTRIBUTE16 PER_ALL_PEOPLE_F.ATTRIBUTE16%TYPE,
136: ATTRIBUTE17 PER_ALL_PEOPLE_F.ATTRIBUTE17%TYPE,
137: ATTRIBUTE18 PER_ALL_PEOPLE_F.ATTRIBUTE18%TYPE,
138: ATTRIBUTE19 PER_ALL_PEOPLE_F.ATTRIBUTE19%TYPE,
139: ATTRIBUTE20 PER_ALL_PEOPLE_F.ATTRIBUTE20%TYPE,
140: ATTRIBUTE21 PER_ALL_PEOPLE_F.ATTRIBUTE21%TYPE,
133: ATTRIBUTE14 PER_ALL_PEOPLE_F.ATTRIBUTE14%TYPE,
134: ATTRIBUTE15 PER_ALL_PEOPLE_F.ATTRIBUTE15%TYPE,
135: ATTRIBUTE16 PER_ALL_PEOPLE_F.ATTRIBUTE16%TYPE,
136: ATTRIBUTE17 PER_ALL_PEOPLE_F.ATTRIBUTE17%TYPE,
137: ATTRIBUTE18 PER_ALL_PEOPLE_F.ATTRIBUTE18%TYPE,
138: ATTRIBUTE19 PER_ALL_PEOPLE_F.ATTRIBUTE19%TYPE,
139: ATTRIBUTE20 PER_ALL_PEOPLE_F.ATTRIBUTE20%TYPE,
140: ATTRIBUTE21 PER_ALL_PEOPLE_F.ATTRIBUTE21%TYPE,
141: ATTRIBUTE22 PER_ALL_PEOPLE_F.ATTRIBUTE22%TYPE,
134: ATTRIBUTE15 PER_ALL_PEOPLE_F.ATTRIBUTE15%TYPE,
135: ATTRIBUTE16 PER_ALL_PEOPLE_F.ATTRIBUTE16%TYPE,
136: ATTRIBUTE17 PER_ALL_PEOPLE_F.ATTRIBUTE17%TYPE,
137: ATTRIBUTE18 PER_ALL_PEOPLE_F.ATTRIBUTE18%TYPE,
138: ATTRIBUTE19 PER_ALL_PEOPLE_F.ATTRIBUTE19%TYPE,
139: ATTRIBUTE20 PER_ALL_PEOPLE_F.ATTRIBUTE20%TYPE,
140: ATTRIBUTE21 PER_ALL_PEOPLE_F.ATTRIBUTE21%TYPE,
141: ATTRIBUTE22 PER_ALL_PEOPLE_F.ATTRIBUTE22%TYPE,
142: ATTRIBUTE23 PER_ALL_PEOPLE_F.ATTRIBUTE23%TYPE,
135: ATTRIBUTE16 PER_ALL_PEOPLE_F.ATTRIBUTE16%TYPE,
136: ATTRIBUTE17 PER_ALL_PEOPLE_F.ATTRIBUTE17%TYPE,
137: ATTRIBUTE18 PER_ALL_PEOPLE_F.ATTRIBUTE18%TYPE,
138: ATTRIBUTE19 PER_ALL_PEOPLE_F.ATTRIBUTE19%TYPE,
139: ATTRIBUTE20 PER_ALL_PEOPLE_F.ATTRIBUTE20%TYPE,
140: ATTRIBUTE21 PER_ALL_PEOPLE_F.ATTRIBUTE21%TYPE,
141: ATTRIBUTE22 PER_ALL_PEOPLE_F.ATTRIBUTE22%TYPE,
142: ATTRIBUTE23 PER_ALL_PEOPLE_F.ATTRIBUTE23%TYPE,
143: ATTRIBUTE24 PER_ALL_PEOPLE_F.ATTRIBUTE24%TYPE,
136: ATTRIBUTE17 PER_ALL_PEOPLE_F.ATTRIBUTE17%TYPE,
137: ATTRIBUTE18 PER_ALL_PEOPLE_F.ATTRIBUTE18%TYPE,
138: ATTRIBUTE19 PER_ALL_PEOPLE_F.ATTRIBUTE19%TYPE,
139: ATTRIBUTE20 PER_ALL_PEOPLE_F.ATTRIBUTE20%TYPE,
140: ATTRIBUTE21 PER_ALL_PEOPLE_F.ATTRIBUTE21%TYPE,
141: ATTRIBUTE22 PER_ALL_PEOPLE_F.ATTRIBUTE22%TYPE,
142: ATTRIBUTE23 PER_ALL_PEOPLE_F.ATTRIBUTE23%TYPE,
143: ATTRIBUTE24 PER_ALL_PEOPLE_F.ATTRIBUTE24%TYPE,
144: ATTRIBUTE25 PER_ALL_PEOPLE_F.ATTRIBUTE25%TYPE,
137: ATTRIBUTE18 PER_ALL_PEOPLE_F.ATTRIBUTE18%TYPE,
138: ATTRIBUTE19 PER_ALL_PEOPLE_F.ATTRIBUTE19%TYPE,
139: ATTRIBUTE20 PER_ALL_PEOPLE_F.ATTRIBUTE20%TYPE,
140: ATTRIBUTE21 PER_ALL_PEOPLE_F.ATTRIBUTE21%TYPE,
141: ATTRIBUTE22 PER_ALL_PEOPLE_F.ATTRIBUTE22%TYPE,
142: ATTRIBUTE23 PER_ALL_PEOPLE_F.ATTRIBUTE23%TYPE,
143: ATTRIBUTE24 PER_ALL_PEOPLE_F.ATTRIBUTE24%TYPE,
144: ATTRIBUTE25 PER_ALL_PEOPLE_F.ATTRIBUTE25%TYPE,
145: ATTRIBUTE26 PER_ALL_PEOPLE_F.ATTRIBUTE26%TYPE,
138: ATTRIBUTE19 PER_ALL_PEOPLE_F.ATTRIBUTE19%TYPE,
139: ATTRIBUTE20 PER_ALL_PEOPLE_F.ATTRIBUTE20%TYPE,
140: ATTRIBUTE21 PER_ALL_PEOPLE_F.ATTRIBUTE21%TYPE,
141: ATTRIBUTE22 PER_ALL_PEOPLE_F.ATTRIBUTE22%TYPE,
142: ATTRIBUTE23 PER_ALL_PEOPLE_F.ATTRIBUTE23%TYPE,
143: ATTRIBUTE24 PER_ALL_PEOPLE_F.ATTRIBUTE24%TYPE,
144: ATTRIBUTE25 PER_ALL_PEOPLE_F.ATTRIBUTE25%TYPE,
145: ATTRIBUTE26 PER_ALL_PEOPLE_F.ATTRIBUTE26%TYPE,
146: ATTRIBUTE27 PER_ALL_PEOPLE_F.ATTRIBUTE27%TYPE,
139: ATTRIBUTE20 PER_ALL_PEOPLE_F.ATTRIBUTE20%TYPE,
140: ATTRIBUTE21 PER_ALL_PEOPLE_F.ATTRIBUTE21%TYPE,
141: ATTRIBUTE22 PER_ALL_PEOPLE_F.ATTRIBUTE22%TYPE,
142: ATTRIBUTE23 PER_ALL_PEOPLE_F.ATTRIBUTE23%TYPE,
143: ATTRIBUTE24 PER_ALL_PEOPLE_F.ATTRIBUTE24%TYPE,
144: ATTRIBUTE25 PER_ALL_PEOPLE_F.ATTRIBUTE25%TYPE,
145: ATTRIBUTE26 PER_ALL_PEOPLE_F.ATTRIBUTE26%TYPE,
146: ATTRIBUTE27 PER_ALL_PEOPLE_F.ATTRIBUTE27%TYPE,
147: ATTRIBUTE28 PER_ALL_PEOPLE_F.ATTRIBUTE28%TYPE,
140: ATTRIBUTE21 PER_ALL_PEOPLE_F.ATTRIBUTE21%TYPE,
141: ATTRIBUTE22 PER_ALL_PEOPLE_F.ATTRIBUTE22%TYPE,
142: ATTRIBUTE23 PER_ALL_PEOPLE_F.ATTRIBUTE23%TYPE,
143: ATTRIBUTE24 PER_ALL_PEOPLE_F.ATTRIBUTE24%TYPE,
144: ATTRIBUTE25 PER_ALL_PEOPLE_F.ATTRIBUTE25%TYPE,
145: ATTRIBUTE26 PER_ALL_PEOPLE_F.ATTRIBUTE26%TYPE,
146: ATTRIBUTE27 PER_ALL_PEOPLE_F.ATTRIBUTE27%TYPE,
147: ATTRIBUTE28 PER_ALL_PEOPLE_F.ATTRIBUTE28%TYPE,
148: ATTRIBUTE29 PER_ALL_PEOPLE_F.ATTRIBUTE29%TYPE,
141: ATTRIBUTE22 PER_ALL_PEOPLE_F.ATTRIBUTE22%TYPE,
142: ATTRIBUTE23 PER_ALL_PEOPLE_F.ATTRIBUTE23%TYPE,
143: ATTRIBUTE24 PER_ALL_PEOPLE_F.ATTRIBUTE24%TYPE,
144: ATTRIBUTE25 PER_ALL_PEOPLE_F.ATTRIBUTE25%TYPE,
145: ATTRIBUTE26 PER_ALL_PEOPLE_F.ATTRIBUTE26%TYPE,
146: ATTRIBUTE27 PER_ALL_PEOPLE_F.ATTRIBUTE27%TYPE,
147: ATTRIBUTE28 PER_ALL_PEOPLE_F.ATTRIBUTE28%TYPE,
148: ATTRIBUTE29 PER_ALL_PEOPLE_F.ATTRIBUTE29%TYPE,
149: ATTRIBUTE30 PER_ALL_PEOPLE_F.ATTRIBUTE30%TYPE,
142: ATTRIBUTE23 PER_ALL_PEOPLE_F.ATTRIBUTE23%TYPE,
143: ATTRIBUTE24 PER_ALL_PEOPLE_F.ATTRIBUTE24%TYPE,
144: ATTRIBUTE25 PER_ALL_PEOPLE_F.ATTRIBUTE25%TYPE,
145: ATTRIBUTE26 PER_ALL_PEOPLE_F.ATTRIBUTE26%TYPE,
146: ATTRIBUTE27 PER_ALL_PEOPLE_F.ATTRIBUTE27%TYPE,
147: ATTRIBUTE28 PER_ALL_PEOPLE_F.ATTRIBUTE28%TYPE,
148: ATTRIBUTE29 PER_ALL_PEOPLE_F.ATTRIBUTE29%TYPE,
149: ATTRIBUTE30 PER_ALL_PEOPLE_F.ATTRIBUTE30%TYPE,
150: PER_INFORMATION_CATEGORY PER_ALL_PEOPLE_F.PER_INFORMATION_CATEGORY%TYPE,
143: ATTRIBUTE24 PER_ALL_PEOPLE_F.ATTRIBUTE24%TYPE,
144: ATTRIBUTE25 PER_ALL_PEOPLE_F.ATTRIBUTE25%TYPE,
145: ATTRIBUTE26 PER_ALL_PEOPLE_F.ATTRIBUTE26%TYPE,
146: ATTRIBUTE27 PER_ALL_PEOPLE_F.ATTRIBUTE27%TYPE,
147: ATTRIBUTE28 PER_ALL_PEOPLE_F.ATTRIBUTE28%TYPE,
148: ATTRIBUTE29 PER_ALL_PEOPLE_F.ATTRIBUTE29%TYPE,
149: ATTRIBUTE30 PER_ALL_PEOPLE_F.ATTRIBUTE30%TYPE,
150: PER_INFORMATION_CATEGORY PER_ALL_PEOPLE_F.PER_INFORMATION_CATEGORY%TYPE,
151: PER_INFORMATION1 PER_ALL_PEOPLE_F.PER_INFORMATION1%TYPE,
144: ATTRIBUTE25 PER_ALL_PEOPLE_F.ATTRIBUTE25%TYPE,
145: ATTRIBUTE26 PER_ALL_PEOPLE_F.ATTRIBUTE26%TYPE,
146: ATTRIBUTE27 PER_ALL_PEOPLE_F.ATTRIBUTE27%TYPE,
147: ATTRIBUTE28 PER_ALL_PEOPLE_F.ATTRIBUTE28%TYPE,
148: ATTRIBUTE29 PER_ALL_PEOPLE_F.ATTRIBUTE29%TYPE,
149: ATTRIBUTE30 PER_ALL_PEOPLE_F.ATTRIBUTE30%TYPE,
150: PER_INFORMATION_CATEGORY PER_ALL_PEOPLE_F.PER_INFORMATION_CATEGORY%TYPE,
151: PER_INFORMATION1 PER_ALL_PEOPLE_F.PER_INFORMATION1%TYPE,
152: PER_INFORMATION2 PER_ALL_PEOPLE_F.PER_INFORMATION2%TYPE,
145: ATTRIBUTE26 PER_ALL_PEOPLE_F.ATTRIBUTE26%TYPE,
146: ATTRIBUTE27 PER_ALL_PEOPLE_F.ATTRIBUTE27%TYPE,
147: ATTRIBUTE28 PER_ALL_PEOPLE_F.ATTRIBUTE28%TYPE,
148: ATTRIBUTE29 PER_ALL_PEOPLE_F.ATTRIBUTE29%TYPE,
149: ATTRIBUTE30 PER_ALL_PEOPLE_F.ATTRIBUTE30%TYPE,
150: PER_INFORMATION_CATEGORY PER_ALL_PEOPLE_F.PER_INFORMATION_CATEGORY%TYPE,
151: PER_INFORMATION1 PER_ALL_PEOPLE_F.PER_INFORMATION1%TYPE,
152: PER_INFORMATION2 PER_ALL_PEOPLE_F.PER_INFORMATION2%TYPE,
153: PER_INFORMATION3 PER_ALL_PEOPLE_F.PER_INFORMATION3%TYPE,
146: ATTRIBUTE27 PER_ALL_PEOPLE_F.ATTRIBUTE27%TYPE,
147: ATTRIBUTE28 PER_ALL_PEOPLE_F.ATTRIBUTE28%TYPE,
148: ATTRIBUTE29 PER_ALL_PEOPLE_F.ATTRIBUTE29%TYPE,
149: ATTRIBUTE30 PER_ALL_PEOPLE_F.ATTRIBUTE30%TYPE,
150: PER_INFORMATION_CATEGORY PER_ALL_PEOPLE_F.PER_INFORMATION_CATEGORY%TYPE,
151: PER_INFORMATION1 PER_ALL_PEOPLE_F.PER_INFORMATION1%TYPE,
152: PER_INFORMATION2 PER_ALL_PEOPLE_F.PER_INFORMATION2%TYPE,
153: PER_INFORMATION3 PER_ALL_PEOPLE_F.PER_INFORMATION3%TYPE,
154: PER_INFORMATION4 PER_ALL_PEOPLE_F.PER_INFORMATION4%TYPE,
147: ATTRIBUTE28 PER_ALL_PEOPLE_F.ATTRIBUTE28%TYPE,
148: ATTRIBUTE29 PER_ALL_PEOPLE_F.ATTRIBUTE29%TYPE,
149: ATTRIBUTE30 PER_ALL_PEOPLE_F.ATTRIBUTE30%TYPE,
150: PER_INFORMATION_CATEGORY PER_ALL_PEOPLE_F.PER_INFORMATION_CATEGORY%TYPE,
151: PER_INFORMATION1 PER_ALL_PEOPLE_F.PER_INFORMATION1%TYPE,
152: PER_INFORMATION2 PER_ALL_PEOPLE_F.PER_INFORMATION2%TYPE,
153: PER_INFORMATION3 PER_ALL_PEOPLE_F.PER_INFORMATION3%TYPE,
154: PER_INFORMATION4 PER_ALL_PEOPLE_F.PER_INFORMATION4%TYPE,
155: PER_INFORMATION5 PER_ALL_PEOPLE_F.PER_INFORMATION5%TYPE,
148: ATTRIBUTE29 PER_ALL_PEOPLE_F.ATTRIBUTE29%TYPE,
149: ATTRIBUTE30 PER_ALL_PEOPLE_F.ATTRIBUTE30%TYPE,
150: PER_INFORMATION_CATEGORY PER_ALL_PEOPLE_F.PER_INFORMATION_CATEGORY%TYPE,
151: PER_INFORMATION1 PER_ALL_PEOPLE_F.PER_INFORMATION1%TYPE,
152: PER_INFORMATION2 PER_ALL_PEOPLE_F.PER_INFORMATION2%TYPE,
153: PER_INFORMATION3 PER_ALL_PEOPLE_F.PER_INFORMATION3%TYPE,
154: PER_INFORMATION4 PER_ALL_PEOPLE_F.PER_INFORMATION4%TYPE,
155: PER_INFORMATION5 PER_ALL_PEOPLE_F.PER_INFORMATION5%TYPE,
156: PER_INFORMATION6 PER_ALL_PEOPLE_F.PER_INFORMATION6%TYPE,
149: ATTRIBUTE30 PER_ALL_PEOPLE_F.ATTRIBUTE30%TYPE,
150: PER_INFORMATION_CATEGORY PER_ALL_PEOPLE_F.PER_INFORMATION_CATEGORY%TYPE,
151: PER_INFORMATION1 PER_ALL_PEOPLE_F.PER_INFORMATION1%TYPE,
152: PER_INFORMATION2 PER_ALL_PEOPLE_F.PER_INFORMATION2%TYPE,
153: PER_INFORMATION3 PER_ALL_PEOPLE_F.PER_INFORMATION3%TYPE,
154: PER_INFORMATION4 PER_ALL_PEOPLE_F.PER_INFORMATION4%TYPE,
155: PER_INFORMATION5 PER_ALL_PEOPLE_F.PER_INFORMATION5%TYPE,
156: PER_INFORMATION6 PER_ALL_PEOPLE_F.PER_INFORMATION6%TYPE,
157: PER_INFORMATION7 PER_ALL_PEOPLE_F.PER_INFORMATION7%TYPE,
150: PER_INFORMATION_CATEGORY PER_ALL_PEOPLE_F.PER_INFORMATION_CATEGORY%TYPE,
151: PER_INFORMATION1 PER_ALL_PEOPLE_F.PER_INFORMATION1%TYPE,
152: PER_INFORMATION2 PER_ALL_PEOPLE_F.PER_INFORMATION2%TYPE,
153: PER_INFORMATION3 PER_ALL_PEOPLE_F.PER_INFORMATION3%TYPE,
154: PER_INFORMATION4 PER_ALL_PEOPLE_F.PER_INFORMATION4%TYPE,
155: PER_INFORMATION5 PER_ALL_PEOPLE_F.PER_INFORMATION5%TYPE,
156: PER_INFORMATION6 PER_ALL_PEOPLE_F.PER_INFORMATION6%TYPE,
157: PER_INFORMATION7 PER_ALL_PEOPLE_F.PER_INFORMATION7%TYPE,
158: PER_INFORMATION8 PER_ALL_PEOPLE_F.PER_INFORMATION8%TYPE,
151: PER_INFORMATION1 PER_ALL_PEOPLE_F.PER_INFORMATION1%TYPE,
152: PER_INFORMATION2 PER_ALL_PEOPLE_F.PER_INFORMATION2%TYPE,
153: PER_INFORMATION3 PER_ALL_PEOPLE_F.PER_INFORMATION3%TYPE,
154: PER_INFORMATION4 PER_ALL_PEOPLE_F.PER_INFORMATION4%TYPE,
155: PER_INFORMATION5 PER_ALL_PEOPLE_F.PER_INFORMATION5%TYPE,
156: PER_INFORMATION6 PER_ALL_PEOPLE_F.PER_INFORMATION6%TYPE,
157: PER_INFORMATION7 PER_ALL_PEOPLE_F.PER_INFORMATION7%TYPE,
158: PER_INFORMATION8 PER_ALL_PEOPLE_F.PER_INFORMATION8%TYPE,
159: PER_INFORMATION9 PER_ALL_PEOPLE_F.PER_INFORMATION9%TYPE,
152: PER_INFORMATION2 PER_ALL_PEOPLE_F.PER_INFORMATION2%TYPE,
153: PER_INFORMATION3 PER_ALL_PEOPLE_F.PER_INFORMATION3%TYPE,
154: PER_INFORMATION4 PER_ALL_PEOPLE_F.PER_INFORMATION4%TYPE,
155: PER_INFORMATION5 PER_ALL_PEOPLE_F.PER_INFORMATION5%TYPE,
156: PER_INFORMATION6 PER_ALL_PEOPLE_F.PER_INFORMATION6%TYPE,
157: PER_INFORMATION7 PER_ALL_PEOPLE_F.PER_INFORMATION7%TYPE,
158: PER_INFORMATION8 PER_ALL_PEOPLE_F.PER_INFORMATION8%TYPE,
159: PER_INFORMATION9 PER_ALL_PEOPLE_F.PER_INFORMATION9%TYPE,
160: PER_INFORMATION10 PER_ALL_PEOPLE_F.PER_INFORMATION10%TYPE,
153: PER_INFORMATION3 PER_ALL_PEOPLE_F.PER_INFORMATION3%TYPE,
154: PER_INFORMATION4 PER_ALL_PEOPLE_F.PER_INFORMATION4%TYPE,
155: PER_INFORMATION5 PER_ALL_PEOPLE_F.PER_INFORMATION5%TYPE,
156: PER_INFORMATION6 PER_ALL_PEOPLE_F.PER_INFORMATION6%TYPE,
157: PER_INFORMATION7 PER_ALL_PEOPLE_F.PER_INFORMATION7%TYPE,
158: PER_INFORMATION8 PER_ALL_PEOPLE_F.PER_INFORMATION8%TYPE,
159: PER_INFORMATION9 PER_ALL_PEOPLE_F.PER_INFORMATION9%TYPE,
160: PER_INFORMATION10 PER_ALL_PEOPLE_F.PER_INFORMATION10%TYPE,
161: PER_INFORMATION11 PER_ALL_PEOPLE_F.PER_INFORMATION11%TYPE,
154: PER_INFORMATION4 PER_ALL_PEOPLE_F.PER_INFORMATION4%TYPE,
155: PER_INFORMATION5 PER_ALL_PEOPLE_F.PER_INFORMATION5%TYPE,
156: PER_INFORMATION6 PER_ALL_PEOPLE_F.PER_INFORMATION6%TYPE,
157: PER_INFORMATION7 PER_ALL_PEOPLE_F.PER_INFORMATION7%TYPE,
158: PER_INFORMATION8 PER_ALL_PEOPLE_F.PER_INFORMATION8%TYPE,
159: PER_INFORMATION9 PER_ALL_PEOPLE_F.PER_INFORMATION9%TYPE,
160: PER_INFORMATION10 PER_ALL_PEOPLE_F.PER_INFORMATION10%TYPE,
161: PER_INFORMATION11 PER_ALL_PEOPLE_F.PER_INFORMATION11%TYPE,
162: PER_INFORMATION12 PER_ALL_PEOPLE_F.PER_INFORMATION12%TYPE,
155: PER_INFORMATION5 PER_ALL_PEOPLE_F.PER_INFORMATION5%TYPE,
156: PER_INFORMATION6 PER_ALL_PEOPLE_F.PER_INFORMATION6%TYPE,
157: PER_INFORMATION7 PER_ALL_PEOPLE_F.PER_INFORMATION7%TYPE,
158: PER_INFORMATION8 PER_ALL_PEOPLE_F.PER_INFORMATION8%TYPE,
159: PER_INFORMATION9 PER_ALL_PEOPLE_F.PER_INFORMATION9%TYPE,
160: PER_INFORMATION10 PER_ALL_PEOPLE_F.PER_INFORMATION10%TYPE,
161: PER_INFORMATION11 PER_ALL_PEOPLE_F.PER_INFORMATION11%TYPE,
162: PER_INFORMATION12 PER_ALL_PEOPLE_F.PER_INFORMATION12%TYPE,
163: PER_INFORMATION13 PER_ALL_PEOPLE_F.PER_INFORMATION13%TYPE,
156: PER_INFORMATION6 PER_ALL_PEOPLE_F.PER_INFORMATION6%TYPE,
157: PER_INFORMATION7 PER_ALL_PEOPLE_F.PER_INFORMATION7%TYPE,
158: PER_INFORMATION8 PER_ALL_PEOPLE_F.PER_INFORMATION8%TYPE,
159: PER_INFORMATION9 PER_ALL_PEOPLE_F.PER_INFORMATION9%TYPE,
160: PER_INFORMATION10 PER_ALL_PEOPLE_F.PER_INFORMATION10%TYPE,
161: PER_INFORMATION11 PER_ALL_PEOPLE_F.PER_INFORMATION11%TYPE,
162: PER_INFORMATION12 PER_ALL_PEOPLE_F.PER_INFORMATION12%TYPE,
163: PER_INFORMATION13 PER_ALL_PEOPLE_F.PER_INFORMATION13%TYPE,
164: PER_INFORMATION14 PER_ALL_PEOPLE_F.PER_INFORMATION14%TYPE,
157: PER_INFORMATION7 PER_ALL_PEOPLE_F.PER_INFORMATION7%TYPE,
158: PER_INFORMATION8 PER_ALL_PEOPLE_F.PER_INFORMATION8%TYPE,
159: PER_INFORMATION9 PER_ALL_PEOPLE_F.PER_INFORMATION9%TYPE,
160: PER_INFORMATION10 PER_ALL_PEOPLE_F.PER_INFORMATION10%TYPE,
161: PER_INFORMATION11 PER_ALL_PEOPLE_F.PER_INFORMATION11%TYPE,
162: PER_INFORMATION12 PER_ALL_PEOPLE_F.PER_INFORMATION12%TYPE,
163: PER_INFORMATION13 PER_ALL_PEOPLE_F.PER_INFORMATION13%TYPE,
164: PER_INFORMATION14 PER_ALL_PEOPLE_F.PER_INFORMATION14%TYPE,
165: PER_INFORMATION15 PER_ALL_PEOPLE_F.PER_INFORMATION15%TYPE,
158: PER_INFORMATION8 PER_ALL_PEOPLE_F.PER_INFORMATION8%TYPE,
159: PER_INFORMATION9 PER_ALL_PEOPLE_F.PER_INFORMATION9%TYPE,
160: PER_INFORMATION10 PER_ALL_PEOPLE_F.PER_INFORMATION10%TYPE,
161: PER_INFORMATION11 PER_ALL_PEOPLE_F.PER_INFORMATION11%TYPE,
162: PER_INFORMATION12 PER_ALL_PEOPLE_F.PER_INFORMATION12%TYPE,
163: PER_INFORMATION13 PER_ALL_PEOPLE_F.PER_INFORMATION13%TYPE,
164: PER_INFORMATION14 PER_ALL_PEOPLE_F.PER_INFORMATION14%TYPE,
165: PER_INFORMATION15 PER_ALL_PEOPLE_F.PER_INFORMATION15%TYPE,
166: PER_INFORMATION16 PER_ALL_PEOPLE_F.PER_INFORMATION16%TYPE,
159: PER_INFORMATION9 PER_ALL_PEOPLE_F.PER_INFORMATION9%TYPE,
160: PER_INFORMATION10 PER_ALL_PEOPLE_F.PER_INFORMATION10%TYPE,
161: PER_INFORMATION11 PER_ALL_PEOPLE_F.PER_INFORMATION11%TYPE,
162: PER_INFORMATION12 PER_ALL_PEOPLE_F.PER_INFORMATION12%TYPE,
163: PER_INFORMATION13 PER_ALL_PEOPLE_F.PER_INFORMATION13%TYPE,
164: PER_INFORMATION14 PER_ALL_PEOPLE_F.PER_INFORMATION14%TYPE,
165: PER_INFORMATION15 PER_ALL_PEOPLE_F.PER_INFORMATION15%TYPE,
166: PER_INFORMATION16 PER_ALL_PEOPLE_F.PER_INFORMATION16%TYPE,
167: PER_INFORMATION17 PER_ALL_PEOPLE_F.PER_INFORMATION17%TYPE,
160: PER_INFORMATION10 PER_ALL_PEOPLE_F.PER_INFORMATION10%TYPE,
161: PER_INFORMATION11 PER_ALL_PEOPLE_F.PER_INFORMATION11%TYPE,
162: PER_INFORMATION12 PER_ALL_PEOPLE_F.PER_INFORMATION12%TYPE,
163: PER_INFORMATION13 PER_ALL_PEOPLE_F.PER_INFORMATION13%TYPE,
164: PER_INFORMATION14 PER_ALL_PEOPLE_F.PER_INFORMATION14%TYPE,
165: PER_INFORMATION15 PER_ALL_PEOPLE_F.PER_INFORMATION15%TYPE,
166: PER_INFORMATION16 PER_ALL_PEOPLE_F.PER_INFORMATION16%TYPE,
167: PER_INFORMATION17 PER_ALL_PEOPLE_F.PER_INFORMATION17%TYPE,
168: PER_INFORMATION18 PER_ALL_PEOPLE_F.PER_INFORMATION18%TYPE,
161: PER_INFORMATION11 PER_ALL_PEOPLE_F.PER_INFORMATION11%TYPE,
162: PER_INFORMATION12 PER_ALL_PEOPLE_F.PER_INFORMATION12%TYPE,
163: PER_INFORMATION13 PER_ALL_PEOPLE_F.PER_INFORMATION13%TYPE,
164: PER_INFORMATION14 PER_ALL_PEOPLE_F.PER_INFORMATION14%TYPE,
165: PER_INFORMATION15 PER_ALL_PEOPLE_F.PER_INFORMATION15%TYPE,
166: PER_INFORMATION16 PER_ALL_PEOPLE_F.PER_INFORMATION16%TYPE,
167: PER_INFORMATION17 PER_ALL_PEOPLE_F.PER_INFORMATION17%TYPE,
168: PER_INFORMATION18 PER_ALL_PEOPLE_F.PER_INFORMATION18%TYPE,
169: PER_INFORMATION19 PER_ALL_PEOPLE_F.PER_INFORMATION19%TYPE,
162: PER_INFORMATION12 PER_ALL_PEOPLE_F.PER_INFORMATION12%TYPE,
163: PER_INFORMATION13 PER_ALL_PEOPLE_F.PER_INFORMATION13%TYPE,
164: PER_INFORMATION14 PER_ALL_PEOPLE_F.PER_INFORMATION14%TYPE,
165: PER_INFORMATION15 PER_ALL_PEOPLE_F.PER_INFORMATION15%TYPE,
166: PER_INFORMATION16 PER_ALL_PEOPLE_F.PER_INFORMATION16%TYPE,
167: PER_INFORMATION17 PER_ALL_PEOPLE_F.PER_INFORMATION17%TYPE,
168: PER_INFORMATION18 PER_ALL_PEOPLE_F.PER_INFORMATION18%TYPE,
169: PER_INFORMATION19 PER_ALL_PEOPLE_F.PER_INFORMATION19%TYPE,
170: PER_INFORMATION20 PER_ALL_PEOPLE_F.PER_INFORMATION20%TYPE,
163: PER_INFORMATION13 PER_ALL_PEOPLE_F.PER_INFORMATION13%TYPE,
164: PER_INFORMATION14 PER_ALL_PEOPLE_F.PER_INFORMATION14%TYPE,
165: PER_INFORMATION15 PER_ALL_PEOPLE_F.PER_INFORMATION15%TYPE,
166: PER_INFORMATION16 PER_ALL_PEOPLE_F.PER_INFORMATION16%TYPE,
167: PER_INFORMATION17 PER_ALL_PEOPLE_F.PER_INFORMATION17%TYPE,
168: PER_INFORMATION18 PER_ALL_PEOPLE_F.PER_INFORMATION18%TYPE,
169: PER_INFORMATION19 PER_ALL_PEOPLE_F.PER_INFORMATION19%TYPE,
170: PER_INFORMATION20 PER_ALL_PEOPLE_F.PER_INFORMATION20%TYPE,
171: PER_INFORMATION21 PER_ALL_PEOPLE_F.PER_INFORMATION21%TYPE,
164: PER_INFORMATION14 PER_ALL_PEOPLE_F.PER_INFORMATION14%TYPE,
165: PER_INFORMATION15 PER_ALL_PEOPLE_F.PER_INFORMATION15%TYPE,
166: PER_INFORMATION16 PER_ALL_PEOPLE_F.PER_INFORMATION16%TYPE,
167: PER_INFORMATION17 PER_ALL_PEOPLE_F.PER_INFORMATION17%TYPE,
168: PER_INFORMATION18 PER_ALL_PEOPLE_F.PER_INFORMATION18%TYPE,
169: PER_INFORMATION19 PER_ALL_PEOPLE_F.PER_INFORMATION19%TYPE,
170: PER_INFORMATION20 PER_ALL_PEOPLE_F.PER_INFORMATION20%TYPE,
171: PER_INFORMATION21 PER_ALL_PEOPLE_F.PER_INFORMATION21%TYPE,
172: PER_INFORMATION22 PER_ALL_PEOPLE_F.PER_INFORMATION22%TYPE,
165: PER_INFORMATION15 PER_ALL_PEOPLE_F.PER_INFORMATION15%TYPE,
166: PER_INFORMATION16 PER_ALL_PEOPLE_F.PER_INFORMATION16%TYPE,
167: PER_INFORMATION17 PER_ALL_PEOPLE_F.PER_INFORMATION17%TYPE,
168: PER_INFORMATION18 PER_ALL_PEOPLE_F.PER_INFORMATION18%TYPE,
169: PER_INFORMATION19 PER_ALL_PEOPLE_F.PER_INFORMATION19%TYPE,
170: PER_INFORMATION20 PER_ALL_PEOPLE_F.PER_INFORMATION20%TYPE,
171: PER_INFORMATION21 PER_ALL_PEOPLE_F.PER_INFORMATION21%TYPE,
172: PER_INFORMATION22 PER_ALL_PEOPLE_F.PER_INFORMATION22%TYPE,
173: PER_INFORMATION23 PER_ALL_PEOPLE_F.PER_INFORMATION23%TYPE,
166: PER_INFORMATION16 PER_ALL_PEOPLE_F.PER_INFORMATION16%TYPE,
167: PER_INFORMATION17 PER_ALL_PEOPLE_F.PER_INFORMATION17%TYPE,
168: PER_INFORMATION18 PER_ALL_PEOPLE_F.PER_INFORMATION18%TYPE,
169: PER_INFORMATION19 PER_ALL_PEOPLE_F.PER_INFORMATION19%TYPE,
170: PER_INFORMATION20 PER_ALL_PEOPLE_F.PER_INFORMATION20%TYPE,
171: PER_INFORMATION21 PER_ALL_PEOPLE_F.PER_INFORMATION21%TYPE,
172: PER_INFORMATION22 PER_ALL_PEOPLE_F.PER_INFORMATION22%TYPE,
173: PER_INFORMATION23 PER_ALL_PEOPLE_F.PER_INFORMATION23%TYPE,
174: PER_INFORMATION24 PER_ALL_PEOPLE_F.PER_INFORMATION24%TYPE,
167: PER_INFORMATION17 PER_ALL_PEOPLE_F.PER_INFORMATION17%TYPE,
168: PER_INFORMATION18 PER_ALL_PEOPLE_F.PER_INFORMATION18%TYPE,
169: PER_INFORMATION19 PER_ALL_PEOPLE_F.PER_INFORMATION19%TYPE,
170: PER_INFORMATION20 PER_ALL_PEOPLE_F.PER_INFORMATION20%TYPE,
171: PER_INFORMATION21 PER_ALL_PEOPLE_F.PER_INFORMATION21%TYPE,
172: PER_INFORMATION22 PER_ALL_PEOPLE_F.PER_INFORMATION22%TYPE,
173: PER_INFORMATION23 PER_ALL_PEOPLE_F.PER_INFORMATION23%TYPE,
174: PER_INFORMATION24 PER_ALL_PEOPLE_F.PER_INFORMATION24%TYPE,
175: PER_INFORMATION25 PER_ALL_PEOPLE_F.PER_INFORMATION25%TYPE,
168: PER_INFORMATION18 PER_ALL_PEOPLE_F.PER_INFORMATION18%TYPE,
169: PER_INFORMATION19 PER_ALL_PEOPLE_F.PER_INFORMATION19%TYPE,
170: PER_INFORMATION20 PER_ALL_PEOPLE_F.PER_INFORMATION20%TYPE,
171: PER_INFORMATION21 PER_ALL_PEOPLE_F.PER_INFORMATION21%TYPE,
172: PER_INFORMATION22 PER_ALL_PEOPLE_F.PER_INFORMATION22%TYPE,
173: PER_INFORMATION23 PER_ALL_PEOPLE_F.PER_INFORMATION23%TYPE,
174: PER_INFORMATION24 PER_ALL_PEOPLE_F.PER_INFORMATION24%TYPE,
175: PER_INFORMATION25 PER_ALL_PEOPLE_F.PER_INFORMATION25%TYPE,
176: PER_INFORMATION26 PER_ALL_PEOPLE_F.PER_INFORMATION26%TYPE,
169: PER_INFORMATION19 PER_ALL_PEOPLE_F.PER_INFORMATION19%TYPE,
170: PER_INFORMATION20 PER_ALL_PEOPLE_F.PER_INFORMATION20%TYPE,
171: PER_INFORMATION21 PER_ALL_PEOPLE_F.PER_INFORMATION21%TYPE,
172: PER_INFORMATION22 PER_ALL_PEOPLE_F.PER_INFORMATION22%TYPE,
173: PER_INFORMATION23 PER_ALL_PEOPLE_F.PER_INFORMATION23%TYPE,
174: PER_INFORMATION24 PER_ALL_PEOPLE_F.PER_INFORMATION24%TYPE,
175: PER_INFORMATION25 PER_ALL_PEOPLE_F.PER_INFORMATION25%TYPE,
176: PER_INFORMATION26 PER_ALL_PEOPLE_F.PER_INFORMATION26%TYPE,
177: PER_INFORMATION27 PER_ALL_PEOPLE_F.PER_INFORMATION27%TYPE,
170: PER_INFORMATION20 PER_ALL_PEOPLE_F.PER_INFORMATION20%TYPE,
171: PER_INFORMATION21 PER_ALL_PEOPLE_F.PER_INFORMATION21%TYPE,
172: PER_INFORMATION22 PER_ALL_PEOPLE_F.PER_INFORMATION22%TYPE,
173: PER_INFORMATION23 PER_ALL_PEOPLE_F.PER_INFORMATION23%TYPE,
174: PER_INFORMATION24 PER_ALL_PEOPLE_F.PER_INFORMATION24%TYPE,
175: PER_INFORMATION25 PER_ALL_PEOPLE_F.PER_INFORMATION25%TYPE,
176: PER_INFORMATION26 PER_ALL_PEOPLE_F.PER_INFORMATION26%TYPE,
177: PER_INFORMATION27 PER_ALL_PEOPLE_F.PER_INFORMATION27%TYPE,
178: PER_INFORMATION28 PER_ALL_PEOPLE_F.PER_INFORMATION28%TYPE,
171: PER_INFORMATION21 PER_ALL_PEOPLE_F.PER_INFORMATION21%TYPE,
172: PER_INFORMATION22 PER_ALL_PEOPLE_F.PER_INFORMATION22%TYPE,
173: PER_INFORMATION23 PER_ALL_PEOPLE_F.PER_INFORMATION23%TYPE,
174: PER_INFORMATION24 PER_ALL_PEOPLE_F.PER_INFORMATION24%TYPE,
175: PER_INFORMATION25 PER_ALL_PEOPLE_F.PER_INFORMATION25%TYPE,
176: PER_INFORMATION26 PER_ALL_PEOPLE_F.PER_INFORMATION26%TYPE,
177: PER_INFORMATION27 PER_ALL_PEOPLE_F.PER_INFORMATION27%TYPE,
178: PER_INFORMATION28 PER_ALL_PEOPLE_F.PER_INFORMATION28%TYPE,
179: PER_INFORMATION29 PER_ALL_PEOPLE_F.PER_INFORMATION29%TYPE,
172: PER_INFORMATION22 PER_ALL_PEOPLE_F.PER_INFORMATION22%TYPE,
173: PER_INFORMATION23 PER_ALL_PEOPLE_F.PER_INFORMATION23%TYPE,
174: PER_INFORMATION24 PER_ALL_PEOPLE_F.PER_INFORMATION24%TYPE,
175: PER_INFORMATION25 PER_ALL_PEOPLE_F.PER_INFORMATION25%TYPE,
176: PER_INFORMATION26 PER_ALL_PEOPLE_F.PER_INFORMATION26%TYPE,
177: PER_INFORMATION27 PER_ALL_PEOPLE_F.PER_INFORMATION27%TYPE,
178: PER_INFORMATION28 PER_ALL_PEOPLE_F.PER_INFORMATION28%TYPE,
179: PER_INFORMATION29 PER_ALL_PEOPLE_F.PER_INFORMATION29%TYPE,
180: PER_INFORMATION30 PER_ALL_PEOPLE_F.PER_INFORMATION30%TYPE,
173: PER_INFORMATION23 PER_ALL_PEOPLE_F.PER_INFORMATION23%TYPE,
174: PER_INFORMATION24 PER_ALL_PEOPLE_F.PER_INFORMATION24%TYPE,
175: PER_INFORMATION25 PER_ALL_PEOPLE_F.PER_INFORMATION25%TYPE,
176: PER_INFORMATION26 PER_ALL_PEOPLE_F.PER_INFORMATION26%TYPE,
177: PER_INFORMATION27 PER_ALL_PEOPLE_F.PER_INFORMATION27%TYPE,
178: PER_INFORMATION28 PER_ALL_PEOPLE_F.PER_INFORMATION28%TYPE,
179: PER_INFORMATION29 PER_ALL_PEOPLE_F.PER_INFORMATION29%TYPE,
180: PER_INFORMATION30 PER_ALL_PEOPLE_F.PER_INFORMATION30%TYPE,
181: DATE_OF_DEATH varchar2(10),
174: PER_INFORMATION24 PER_ALL_PEOPLE_F.PER_INFORMATION24%TYPE,
175: PER_INFORMATION25 PER_ALL_PEOPLE_F.PER_INFORMATION25%TYPE,
176: PER_INFORMATION26 PER_ALL_PEOPLE_F.PER_INFORMATION26%TYPE,
177: PER_INFORMATION27 PER_ALL_PEOPLE_F.PER_INFORMATION27%TYPE,
178: PER_INFORMATION28 PER_ALL_PEOPLE_F.PER_INFORMATION28%TYPE,
179: PER_INFORMATION29 PER_ALL_PEOPLE_F.PER_INFORMATION29%TYPE,
180: PER_INFORMATION30 PER_ALL_PEOPLE_F.PER_INFORMATION30%TYPE,
181: DATE_OF_DEATH varchar2(10),
182: ORIGINAL_DATE_OF_HIRE varchar2(10),
175: PER_INFORMATION25 PER_ALL_PEOPLE_F.PER_INFORMATION25%TYPE,
176: PER_INFORMATION26 PER_ALL_PEOPLE_F.PER_INFORMATION26%TYPE,
177: PER_INFORMATION27 PER_ALL_PEOPLE_F.PER_INFORMATION27%TYPE,
178: PER_INFORMATION28 PER_ALL_PEOPLE_F.PER_INFORMATION28%TYPE,
179: PER_INFORMATION29 PER_ALL_PEOPLE_F.PER_INFORMATION29%TYPE,
180: PER_INFORMATION30 PER_ALL_PEOPLE_F.PER_INFORMATION30%TYPE,
181: DATE_OF_DEATH varchar2(10),
182: ORIGINAL_DATE_OF_HIRE varchar2(10),
183: TOWN_OF_BIRTH PER_ALL_PEOPLE_F.TOWN_OF_BIRTH%TYPE,
176: PER_INFORMATION26 PER_ALL_PEOPLE_F.PER_INFORMATION26%TYPE,
177: PER_INFORMATION27 PER_ALL_PEOPLE_F.PER_INFORMATION27%TYPE,
178: PER_INFORMATION28 PER_ALL_PEOPLE_F.PER_INFORMATION28%TYPE,
179: PER_INFORMATION29 PER_ALL_PEOPLE_F.PER_INFORMATION29%TYPE,
180: PER_INFORMATION30 PER_ALL_PEOPLE_F.PER_INFORMATION30%TYPE,
181: DATE_OF_DEATH varchar2(10),
182: ORIGINAL_DATE_OF_HIRE varchar2(10),
183: TOWN_OF_BIRTH PER_ALL_PEOPLE_F.TOWN_OF_BIRTH%TYPE,
184: REGION_OF_BIRTH PER_ALL_PEOPLE_F.REGION_OF_BIRTH%TYPE,
179: PER_INFORMATION29 PER_ALL_PEOPLE_F.PER_INFORMATION29%TYPE,
180: PER_INFORMATION30 PER_ALL_PEOPLE_F.PER_INFORMATION30%TYPE,
181: DATE_OF_DEATH varchar2(10),
182: ORIGINAL_DATE_OF_HIRE varchar2(10),
183: TOWN_OF_BIRTH PER_ALL_PEOPLE_F.TOWN_OF_BIRTH%TYPE,
184: REGION_OF_BIRTH PER_ALL_PEOPLE_F.REGION_OF_BIRTH%TYPE,
185: COUNTRY_OF_BIRTH PER_ALL_PEOPLE_F.COUNTRY_OF_BIRTH%TYPE,
186: COUNTRY_OF_BIRTH_DESC FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE,
187: GLOBAL_PERSON_ID PER_ALL_PEOPLE_F.GLOBAL_PERSON_ID%TYPE,
180: PER_INFORMATION30 PER_ALL_PEOPLE_F.PER_INFORMATION30%TYPE,
181: DATE_OF_DEATH varchar2(10),
182: ORIGINAL_DATE_OF_HIRE varchar2(10),
183: TOWN_OF_BIRTH PER_ALL_PEOPLE_F.TOWN_OF_BIRTH%TYPE,
184: REGION_OF_BIRTH PER_ALL_PEOPLE_F.REGION_OF_BIRTH%TYPE,
185: COUNTRY_OF_BIRTH PER_ALL_PEOPLE_F.COUNTRY_OF_BIRTH%TYPE,
186: COUNTRY_OF_BIRTH_DESC FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE,
187: GLOBAL_PERSON_ID PER_ALL_PEOPLE_F.GLOBAL_PERSON_ID%TYPE,
188: COORD_BEN_MED_PL_NAME PER_ALL_PEOPLE_F.COORD_BEN_MED_PL_NAME%TYPE,
181: DATE_OF_DEATH varchar2(10),
182: ORIGINAL_DATE_OF_HIRE varchar2(10),
183: TOWN_OF_BIRTH PER_ALL_PEOPLE_F.TOWN_OF_BIRTH%TYPE,
184: REGION_OF_BIRTH PER_ALL_PEOPLE_F.REGION_OF_BIRTH%TYPE,
185: COUNTRY_OF_BIRTH PER_ALL_PEOPLE_F.COUNTRY_OF_BIRTH%TYPE,
186: COUNTRY_OF_BIRTH_DESC FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE,
187: GLOBAL_PERSON_ID PER_ALL_PEOPLE_F.GLOBAL_PERSON_ID%TYPE,
188: COORD_BEN_MED_PL_NAME PER_ALL_PEOPLE_F.COORD_BEN_MED_PL_NAME%TYPE,
189: COORD_BEN_MED_INSR_CRR_NAME PER_ALL_PEOPLE_F.COORD_BEN_MED_INSR_CRR_NAME%TYPE,
183: TOWN_OF_BIRTH PER_ALL_PEOPLE_F.TOWN_OF_BIRTH%TYPE,
184: REGION_OF_BIRTH PER_ALL_PEOPLE_F.REGION_OF_BIRTH%TYPE,
185: COUNTRY_OF_BIRTH PER_ALL_PEOPLE_F.COUNTRY_OF_BIRTH%TYPE,
186: COUNTRY_OF_BIRTH_DESC FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE,
187: GLOBAL_PERSON_ID PER_ALL_PEOPLE_F.GLOBAL_PERSON_ID%TYPE,
188: COORD_BEN_MED_PL_NAME PER_ALL_PEOPLE_F.COORD_BEN_MED_PL_NAME%TYPE,
189: COORD_BEN_MED_INSR_CRR_NAME PER_ALL_PEOPLE_F.COORD_BEN_MED_INSR_CRR_NAME%TYPE,
190: COORD_BEN_MED_INSR_CRR_IDENT PER_ALL_PEOPLE_F.COORD_BEN_MED_INSR_CRR_IDENT%TYPE,
191: COORD_BEN_MED_EXT_ER PER_ALL_PEOPLE_F.COORD_BEN_MED_EXT_ER%TYPE,
184: REGION_OF_BIRTH PER_ALL_PEOPLE_F.REGION_OF_BIRTH%TYPE,
185: COUNTRY_OF_BIRTH PER_ALL_PEOPLE_F.COUNTRY_OF_BIRTH%TYPE,
186: COUNTRY_OF_BIRTH_DESC FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE,
187: GLOBAL_PERSON_ID PER_ALL_PEOPLE_F.GLOBAL_PERSON_ID%TYPE,
188: COORD_BEN_MED_PL_NAME PER_ALL_PEOPLE_F.COORD_BEN_MED_PL_NAME%TYPE,
189: COORD_BEN_MED_INSR_CRR_NAME PER_ALL_PEOPLE_F.COORD_BEN_MED_INSR_CRR_NAME%TYPE,
190: COORD_BEN_MED_INSR_CRR_IDENT PER_ALL_PEOPLE_F.COORD_BEN_MED_INSR_CRR_IDENT%TYPE,
191: COORD_BEN_MED_EXT_ER PER_ALL_PEOPLE_F.COORD_BEN_MED_EXT_ER%TYPE,
192: COORD_BEN_MED_CVG_STRT_DT PER_ALL_PEOPLE_F.COORD_BEN_MED_CVG_STRT_DT%TYPE,
185: COUNTRY_OF_BIRTH PER_ALL_PEOPLE_F.COUNTRY_OF_BIRTH%TYPE,
186: COUNTRY_OF_BIRTH_DESC FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE,
187: GLOBAL_PERSON_ID PER_ALL_PEOPLE_F.GLOBAL_PERSON_ID%TYPE,
188: COORD_BEN_MED_PL_NAME PER_ALL_PEOPLE_F.COORD_BEN_MED_PL_NAME%TYPE,
189: COORD_BEN_MED_INSR_CRR_NAME PER_ALL_PEOPLE_F.COORD_BEN_MED_INSR_CRR_NAME%TYPE,
190: COORD_BEN_MED_INSR_CRR_IDENT PER_ALL_PEOPLE_F.COORD_BEN_MED_INSR_CRR_IDENT%TYPE,
191: COORD_BEN_MED_EXT_ER PER_ALL_PEOPLE_F.COORD_BEN_MED_EXT_ER%TYPE,
192: COORD_BEN_MED_CVG_STRT_DT PER_ALL_PEOPLE_F.COORD_BEN_MED_CVG_STRT_DT%TYPE,
193: COORD_BEN_MED_CVG_END_DT PER_ALL_PEOPLE_F.COORD_BEN_MED_CVG_END_DT%TYPE,
186: COUNTRY_OF_BIRTH_DESC FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE,
187: GLOBAL_PERSON_ID PER_ALL_PEOPLE_F.GLOBAL_PERSON_ID%TYPE,
188: COORD_BEN_MED_PL_NAME PER_ALL_PEOPLE_F.COORD_BEN_MED_PL_NAME%TYPE,
189: COORD_BEN_MED_INSR_CRR_NAME PER_ALL_PEOPLE_F.COORD_BEN_MED_INSR_CRR_NAME%TYPE,
190: COORD_BEN_MED_INSR_CRR_IDENT PER_ALL_PEOPLE_F.COORD_BEN_MED_INSR_CRR_IDENT%TYPE,
191: COORD_BEN_MED_EXT_ER PER_ALL_PEOPLE_F.COORD_BEN_MED_EXT_ER%TYPE,
192: COORD_BEN_MED_CVG_STRT_DT PER_ALL_PEOPLE_F.COORD_BEN_MED_CVG_STRT_DT%TYPE,
193: COORD_BEN_MED_CVG_END_DT PER_ALL_PEOPLE_F.COORD_BEN_MED_CVG_END_DT%TYPE,
194: PARTY_ID PER_ALL_PEOPLE_F.PARTY_ID%TYPE,
187: GLOBAL_PERSON_ID PER_ALL_PEOPLE_F.GLOBAL_PERSON_ID%TYPE,
188: COORD_BEN_MED_PL_NAME PER_ALL_PEOPLE_F.COORD_BEN_MED_PL_NAME%TYPE,
189: COORD_BEN_MED_INSR_CRR_NAME PER_ALL_PEOPLE_F.COORD_BEN_MED_INSR_CRR_NAME%TYPE,
190: COORD_BEN_MED_INSR_CRR_IDENT PER_ALL_PEOPLE_F.COORD_BEN_MED_INSR_CRR_IDENT%TYPE,
191: COORD_BEN_MED_EXT_ER PER_ALL_PEOPLE_F.COORD_BEN_MED_EXT_ER%TYPE,
192: COORD_BEN_MED_CVG_STRT_DT PER_ALL_PEOPLE_F.COORD_BEN_MED_CVG_STRT_DT%TYPE,
193: COORD_BEN_MED_CVG_END_DT PER_ALL_PEOPLE_F.COORD_BEN_MED_CVG_END_DT%TYPE,
194: PARTY_ID PER_ALL_PEOPLE_F.PARTY_ID%TYPE,
195: NPW_NUMBER PER_ALL_PEOPLE_F.NPW_NUMBER%TYPE,
188: COORD_BEN_MED_PL_NAME PER_ALL_PEOPLE_F.COORD_BEN_MED_PL_NAME%TYPE,
189: COORD_BEN_MED_INSR_CRR_NAME PER_ALL_PEOPLE_F.COORD_BEN_MED_INSR_CRR_NAME%TYPE,
190: COORD_BEN_MED_INSR_CRR_IDENT PER_ALL_PEOPLE_F.COORD_BEN_MED_INSR_CRR_IDENT%TYPE,
191: COORD_BEN_MED_EXT_ER PER_ALL_PEOPLE_F.COORD_BEN_MED_EXT_ER%TYPE,
192: COORD_BEN_MED_CVG_STRT_DT PER_ALL_PEOPLE_F.COORD_BEN_MED_CVG_STRT_DT%TYPE,
193: COORD_BEN_MED_CVG_END_DT PER_ALL_PEOPLE_F.COORD_BEN_MED_CVG_END_DT%TYPE,
194: PARTY_ID PER_ALL_PEOPLE_F.PARTY_ID%TYPE,
195: NPW_NUMBER PER_ALL_PEOPLE_F.NPW_NUMBER%TYPE,
196: CURRENT_NPW_FLAG PER_ALL_PEOPLE_F.CURRENT_NPW_FLAG%TYPE,
189: COORD_BEN_MED_INSR_CRR_NAME PER_ALL_PEOPLE_F.COORD_BEN_MED_INSR_CRR_NAME%TYPE,
190: COORD_BEN_MED_INSR_CRR_IDENT PER_ALL_PEOPLE_F.COORD_BEN_MED_INSR_CRR_IDENT%TYPE,
191: COORD_BEN_MED_EXT_ER PER_ALL_PEOPLE_F.COORD_BEN_MED_EXT_ER%TYPE,
192: COORD_BEN_MED_CVG_STRT_DT PER_ALL_PEOPLE_F.COORD_BEN_MED_CVG_STRT_DT%TYPE,
193: COORD_BEN_MED_CVG_END_DT PER_ALL_PEOPLE_F.COORD_BEN_MED_CVG_END_DT%TYPE,
194: PARTY_ID PER_ALL_PEOPLE_F.PARTY_ID%TYPE,
195: NPW_NUMBER PER_ALL_PEOPLE_F.NPW_NUMBER%TYPE,
196: CURRENT_NPW_FLAG PER_ALL_PEOPLE_F.CURRENT_NPW_FLAG%TYPE,
197: GLOBAL_NAME PER_ALL_PEOPLE_F.GLOBAL_NAME%TYPE,
190: COORD_BEN_MED_INSR_CRR_IDENT PER_ALL_PEOPLE_F.COORD_BEN_MED_INSR_CRR_IDENT%TYPE,
191: COORD_BEN_MED_EXT_ER PER_ALL_PEOPLE_F.COORD_BEN_MED_EXT_ER%TYPE,
192: COORD_BEN_MED_CVG_STRT_DT PER_ALL_PEOPLE_F.COORD_BEN_MED_CVG_STRT_DT%TYPE,
193: COORD_BEN_MED_CVG_END_DT PER_ALL_PEOPLE_F.COORD_BEN_MED_CVG_END_DT%TYPE,
194: PARTY_ID PER_ALL_PEOPLE_F.PARTY_ID%TYPE,
195: NPW_NUMBER PER_ALL_PEOPLE_F.NPW_NUMBER%TYPE,
196: CURRENT_NPW_FLAG PER_ALL_PEOPLE_F.CURRENT_NPW_FLAG%TYPE,
197: GLOBAL_NAME PER_ALL_PEOPLE_F.GLOBAL_NAME%TYPE,
198: LOCAL_NAME PER_ALL_PEOPLE_F.LOCAL_NAME%TYPE
191: COORD_BEN_MED_EXT_ER PER_ALL_PEOPLE_F.COORD_BEN_MED_EXT_ER%TYPE,
192: COORD_BEN_MED_CVG_STRT_DT PER_ALL_PEOPLE_F.COORD_BEN_MED_CVG_STRT_DT%TYPE,
193: COORD_BEN_MED_CVG_END_DT PER_ALL_PEOPLE_F.COORD_BEN_MED_CVG_END_DT%TYPE,
194: PARTY_ID PER_ALL_PEOPLE_F.PARTY_ID%TYPE,
195: NPW_NUMBER PER_ALL_PEOPLE_F.NPW_NUMBER%TYPE,
196: CURRENT_NPW_FLAG PER_ALL_PEOPLE_F.CURRENT_NPW_FLAG%TYPE,
197: GLOBAL_NAME PER_ALL_PEOPLE_F.GLOBAL_NAME%TYPE,
198: LOCAL_NAME PER_ALL_PEOPLE_F.LOCAL_NAME%TYPE
199: );
192: COORD_BEN_MED_CVG_STRT_DT PER_ALL_PEOPLE_F.COORD_BEN_MED_CVG_STRT_DT%TYPE,
193: COORD_BEN_MED_CVG_END_DT PER_ALL_PEOPLE_F.COORD_BEN_MED_CVG_END_DT%TYPE,
194: PARTY_ID PER_ALL_PEOPLE_F.PARTY_ID%TYPE,
195: NPW_NUMBER PER_ALL_PEOPLE_F.NPW_NUMBER%TYPE,
196: CURRENT_NPW_FLAG PER_ALL_PEOPLE_F.CURRENT_NPW_FLAG%TYPE,
197: GLOBAL_NAME PER_ALL_PEOPLE_F.GLOBAL_NAME%TYPE,
198: LOCAL_NAME PER_ALL_PEOPLE_F.LOCAL_NAME%TYPE
199: );
200: /*Record type for assignment details*/
193: COORD_BEN_MED_CVG_END_DT PER_ALL_PEOPLE_F.COORD_BEN_MED_CVG_END_DT%TYPE,
194: PARTY_ID PER_ALL_PEOPLE_F.PARTY_ID%TYPE,
195: NPW_NUMBER PER_ALL_PEOPLE_F.NPW_NUMBER%TYPE,
196: CURRENT_NPW_FLAG PER_ALL_PEOPLE_F.CURRENT_NPW_FLAG%TYPE,
197: GLOBAL_NAME PER_ALL_PEOPLE_F.GLOBAL_NAME%TYPE,
198: LOCAL_NAME PER_ALL_PEOPLE_F.LOCAL_NAME%TYPE
199: );
200: /*Record type for assignment details*/
201: TYPE ASSGN_DETAILS is record
194: PARTY_ID PER_ALL_PEOPLE_F.PARTY_ID%TYPE,
195: NPW_NUMBER PER_ALL_PEOPLE_F.NPW_NUMBER%TYPE,
196: CURRENT_NPW_FLAG PER_ALL_PEOPLE_F.CURRENT_NPW_FLAG%TYPE,
197: GLOBAL_NAME PER_ALL_PEOPLE_F.GLOBAL_NAME%TYPE,
198: LOCAL_NAME PER_ALL_PEOPLE_F.LOCAL_NAME%TYPE
199: );
200: /*Record type for assignment details*/
201: TYPE ASSGN_DETAILS is record
202: (
219: , LOCATION_ID PER_ALL_ASSIGNMENTS_F.LOCATION_ID%TYPE
220: , LOCATION_DESC HR_LOCATIONS_ALL_TL.DESCRIPTION%TYPE --(BASED ON LANG)
221: , PERSON_REFERRED_BY_ID PER_ALL_ASSIGNMENTS_F.PERSON_REFERRED_BY_ID%TYPE
222: , SUPERVISOR_ID PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ID%TYPE
223: , SUPERVISOR_EMP_NUMBER PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%TYPE
224: , SUPERVISOR_CWK_NUMBER PER_ALL_PEOPLE_F.NPW_NUMBER%TYPE
225: , SUPERVISOR_NAME PER_ALL_PEOPLE_F.FULL_NAME%TYPE
226: , SPECIAL_CEILING_STEP_ID PER_ALL_ASSIGNMENTS_F.SPECIAL_CEILING_STEP_ID%TYPE
227: , RECRUITMENT_ACTIVITY_ID PER_ALL_ASSIGNMENTS_F.RECRUITMENT_ACTIVITY_ID%TYPE
220: , LOCATION_DESC HR_LOCATIONS_ALL_TL.DESCRIPTION%TYPE --(BASED ON LANG)
221: , PERSON_REFERRED_BY_ID PER_ALL_ASSIGNMENTS_F.PERSON_REFERRED_BY_ID%TYPE
222: , SUPERVISOR_ID PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ID%TYPE
223: , SUPERVISOR_EMP_NUMBER PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%TYPE
224: , SUPERVISOR_CWK_NUMBER PER_ALL_PEOPLE_F.NPW_NUMBER%TYPE
225: , SUPERVISOR_NAME PER_ALL_PEOPLE_F.FULL_NAME%TYPE
226: , SPECIAL_CEILING_STEP_ID PER_ALL_ASSIGNMENTS_F.SPECIAL_CEILING_STEP_ID%TYPE
227: , RECRUITMENT_ACTIVITY_ID PER_ALL_ASSIGNMENTS_F.RECRUITMENT_ACTIVITY_ID%TYPE
228: , SOURCE_ORGANIZATION_ID PER_ALL_ASSIGNMENTS_F.SOURCE_ORGANIZATION_ID%TYPE
221: , PERSON_REFERRED_BY_ID PER_ALL_ASSIGNMENTS_F.PERSON_REFERRED_BY_ID%TYPE
222: , SUPERVISOR_ID PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ID%TYPE
223: , SUPERVISOR_EMP_NUMBER PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%TYPE
224: , SUPERVISOR_CWK_NUMBER PER_ALL_PEOPLE_F.NPW_NUMBER%TYPE
225: , SUPERVISOR_NAME PER_ALL_PEOPLE_F.FULL_NAME%TYPE
226: , SPECIAL_CEILING_STEP_ID PER_ALL_ASSIGNMENTS_F.SPECIAL_CEILING_STEP_ID%TYPE
227: , RECRUITMENT_ACTIVITY_ID PER_ALL_ASSIGNMENTS_F.RECRUITMENT_ACTIVITY_ID%TYPE
228: , SOURCE_ORGANIZATION_ID PER_ALL_ASSIGNMENTS_F.SOURCE_ORGANIZATION_ID%TYPE
229: , ORGANIZATION_ID PER_ALL_ASSIGNMENTS_F.ORGANIZATION_ID%TYPE
371: TYPE contact_details IS RECORD
372: (
373: CONTACT_RELATIONSHIP_ID PER_CONTACT_RELATIONSHIPS.CONTACT_RELATIONSHIP_ID%TYPE,
374: CONTACT_PERSON_ID PER_CONTACT_RELATIONSHIPS.CONTACT_PERSON_ID%TYPE,
375: CONTACT_FULL_NAME PER_ALL_PEOPLE_F.FULL_NAME%TYPE,
376: CONTACT_TYPE PER_CONTACT_RELATIONSHIPS.CONTACT_TYPE%TYPE,
377: CONTACT_TYPE_DESC HR_LEG_LOOKUPS.MEANING%TYPE, -- 'CONTACT'
378: PRIMARY_CONTACT_FLAG PER_CONTACT_RELATIONSHIPS.PRIMARY_CONTACT_FLAG%TYPE,
379: DATE_START varchar2(10),
702: REPORT_DATE varchar2(10),
703: REPORT_TIME PER_WORK_INCIDENTS.REPORT_TIME%TYPE,
704: REPORT_METHOD PER_WORK_INCIDENTS.REPORT_METHOD%TYPE,
705: PERSON_REPORTED_BY PER_WORK_INCIDENTS.PERSON_REPORTED_BY%TYPE,
706: PERSON_REPORTED_BY_NAME PER_ALL_PEOPLE_F.FULL_NAME%TYPE,
707: PERSON_REPORTED_TO PER_WORK_INCIDENTS.PERSON_REPORTED_TO%TYPE,
708: WITNESS_DETAILS PER_WORK_INCIDENTS.WITNESS_DETAILS%TYPE,
709: DESCRIPTION PER_WORK_INCIDENTS.DESCRIPTION%TYPE,
710: INJURY_TYPE PER_WORK_INCIDENTS.INJURY_TYPE%TYPE,
1231: SUBJECT SUBJECT_RECORD);
1232:
1233: TYPE REPORTEE_DETAILS IS RECORD
1234: (
1235: REPORTEE_FULL_NAME PER_ALL_PEOPLE_F.FULL_NAME%TYPE,
1236: REPORTEE_PERSON_ID PER_ALL_PEOPLE_F.PERSON_ID%TYPE,
1237: REPORTEE_EMPLOYEE_NUMBER PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%TYPE,
1238: REPORTEE_CWK_NUMBER PER_ALL_PEOPLe_F.NPW_NUMBER%TYPE,
1239: REPORTEE_APPLICANT_NUMBER PER_ALL_PEOPLE_F.APPLICANT_NUMBER%TYPE,
1232:
1233: TYPE REPORTEE_DETAILS IS RECORD
1234: (
1235: REPORTEE_FULL_NAME PER_ALL_PEOPLE_F.FULL_NAME%TYPE,
1236: REPORTEE_PERSON_ID PER_ALL_PEOPLE_F.PERSON_ID%TYPE,
1237: REPORTEE_EMPLOYEE_NUMBER PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%TYPE,
1238: REPORTEE_CWK_NUMBER PER_ALL_PEOPLe_F.NPW_NUMBER%TYPE,
1239: REPORTEE_APPLICANT_NUMBER PER_ALL_PEOPLE_F.APPLICANT_NUMBER%TYPE,
1240: REPORTEE_LOCATION_ID PER_ALL_ASSIGNMENTS_F.LOCATION_ID%TYPE,
1233: TYPE REPORTEE_DETAILS IS RECORD
1234: (
1235: REPORTEE_FULL_NAME PER_ALL_PEOPLE_F.FULL_NAME%TYPE,
1236: REPORTEE_PERSON_ID PER_ALL_PEOPLE_F.PERSON_ID%TYPE,
1237: REPORTEE_EMPLOYEE_NUMBER PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%TYPE,
1238: REPORTEE_CWK_NUMBER PER_ALL_PEOPLe_F.NPW_NUMBER%TYPE,
1239: REPORTEE_APPLICANT_NUMBER PER_ALL_PEOPLE_F.APPLICANT_NUMBER%TYPE,
1240: REPORTEE_LOCATION_ID PER_ALL_ASSIGNMENTS_F.LOCATION_ID%TYPE,
1241: REPORTEE_LOCATION_DESC HR_ALL_POSITIONS_F_TL.NAME%TYPE, --(BASED ON LANG)E,
1234: (
1235: REPORTEE_FULL_NAME PER_ALL_PEOPLE_F.FULL_NAME%TYPE,
1236: REPORTEE_PERSON_ID PER_ALL_PEOPLE_F.PERSON_ID%TYPE,
1237: REPORTEE_EMPLOYEE_NUMBER PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%TYPE,
1238: REPORTEE_CWK_NUMBER PER_ALL_PEOPLe_F.NPW_NUMBER%TYPE,
1239: REPORTEE_APPLICANT_NUMBER PER_ALL_PEOPLE_F.APPLICANT_NUMBER%TYPE,
1240: REPORTEE_LOCATION_ID PER_ALL_ASSIGNMENTS_F.LOCATION_ID%TYPE,
1241: REPORTEE_LOCATION_DESC HR_ALL_POSITIONS_F_TL.NAME%TYPE, --(BASED ON LANG)E,
1242: REPORTEE_ASG_STATUS_ID PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID%TYPE,
1235: REPORTEE_FULL_NAME PER_ALL_PEOPLE_F.FULL_NAME%TYPE,
1236: REPORTEE_PERSON_ID PER_ALL_PEOPLE_F.PERSON_ID%TYPE,
1237: REPORTEE_EMPLOYEE_NUMBER PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%TYPE,
1238: REPORTEE_CWK_NUMBER PER_ALL_PEOPLe_F.NPW_NUMBER%TYPE,
1239: REPORTEE_APPLICANT_NUMBER PER_ALL_PEOPLE_F.APPLICANT_NUMBER%TYPE,
1240: REPORTEE_LOCATION_ID PER_ALL_ASSIGNMENTS_F.LOCATION_ID%TYPE,
1241: REPORTEE_LOCATION_DESC HR_ALL_POSITIONS_F_TL.NAME%TYPE, --(BASED ON LANG)E,
1242: REPORTEE_ASG_STATUS_ID PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID%TYPE,
1243: REPORTEE_ASG_STATUS_DESC PER_ASSIGNMENT_STATUS_TYPES_TL.USER_STATUS%TYPE
1257: (plan_type_name ben_pl_typ_f.name%type
1258: ,plan_name ben_pl_f.name%type
1259: ,option_name ben_opt_f.name%type
1260: ,beneficiary VARCHAR2(400)
1261: ,ben_ssn per_all_people_f.national_identifier%type
1262: ,ben_relation VARCHAR2(400)
1263: ,primary_bnf NUMBER
1264: ,contingent_bnf NUMBER
1265: ,le_name ben_ler_f.name%type
1262: ,ben_relation VARCHAR2(400)
1263: ,primary_bnf NUMBER
1264: ,contingent_bnf NUMBER
1265: ,le_name ben_ler_f.name%type
1266: ,ben_full_name per_all_people_f.full_name%type
1267: );
1268:
1269: TYPE g_dependent_rec_type IS RECORD
1270: (
1267: );
1268:
1269: TYPE g_dependent_rec_type IS RECORD
1270: (
1271: name per_all_people_f.full_name%type,
1272: relationship VARCHAR2(400),
1273: type_of_benefit ben_pl_typ_f.name%type,
1274: coverage VARCHAR2(100)
1275: );