[Home] [Help]
1: PACKAGE per_qh_find_query AUTHID CURRENT_USER as
2: /* $Header: peqhfndq.pkh 120.1 2005/12/29 05:34:28 rvarshne noship $ */
3:
4: type findrec is RECORD
5: (person_id per_all_people_f.person_id%type
6: ,business_group_name per_business_groups.name%type
7: ,per_effective_start_date per_all_people_f.effective_start_date%type
8: ,per_effective_end_date per_all_people_f.effective_end_date%type
9: ,person_type varchar2(240)
3:
4: type findrec is RECORD
5: (person_id per_all_people_f.person_id%type
6: ,business_group_name per_business_groups.name%type
7: ,per_effective_start_date per_all_people_f.effective_start_date%type
8: ,per_effective_end_date per_all_people_f.effective_end_date%type
9: ,person_type varchar2(240)
10: ,system_person_type per_person_types.system_person_type%type
11: ,last_name per_all_people_f.last_name%type
4: type findrec is RECORD
5: (person_id per_all_people_f.person_id%type
6: ,business_group_name per_business_groups.name%type
7: ,per_effective_start_date per_all_people_f.effective_start_date%type
8: ,per_effective_end_date per_all_people_f.effective_end_date%type
9: ,person_type varchar2(240)
10: ,system_person_type per_person_types.system_person_type%type
11: ,last_name per_all_people_f.last_name%type
12: ,start_date per_all_people_f.start_date%type
7: ,per_effective_start_date per_all_people_f.effective_start_date%type
8: ,per_effective_end_date per_all_people_f.effective_end_date%type
9: ,person_type varchar2(240)
10: ,system_person_type per_person_types.system_person_type%type
11: ,last_name per_all_people_f.last_name%type
12: ,start_date per_all_people_f.start_date%type
13: ,applicant_number per_all_people_f.applicant_number%type
14: ,background_chk_stat_meaning hr_lookups.meaning%type
15: ,background_date_check per_all_people_f.background_date_check%type
8: ,per_effective_end_date per_all_people_f.effective_end_date%type
9: ,person_type varchar2(240)
10: ,system_person_type per_person_types.system_person_type%type
11: ,last_name per_all_people_f.last_name%type
12: ,start_date per_all_people_f.start_date%type
13: ,applicant_number per_all_people_f.applicant_number%type
14: ,background_chk_stat_meaning hr_lookups.meaning%type
15: ,background_date_check per_all_people_f.background_date_check%type
16: ,blood_type_meaning hr_lookups.meaning%type
9: ,person_type varchar2(240)
10: ,system_person_type per_person_types.system_person_type%type
11: ,last_name per_all_people_f.last_name%type
12: ,start_date per_all_people_f.start_date%type
13: ,applicant_number per_all_people_f.applicant_number%type
14: ,background_chk_stat_meaning hr_lookups.meaning%type
15: ,background_date_check per_all_people_f.background_date_check%type
16: ,blood_type_meaning hr_lookups.meaning%type
17: ,corr_lang_meaning hr_lookups.meaning%type
11: ,last_name per_all_people_f.last_name%type
12: ,start_date per_all_people_f.start_date%type
13: ,applicant_number per_all_people_f.applicant_number%type
14: ,background_chk_stat_meaning hr_lookups.meaning%type
15: ,background_date_check per_all_people_f.background_date_check%type
16: ,blood_type_meaning hr_lookups.meaning%type
17: ,corr_lang_meaning hr_lookups.meaning%type
18: ,date_employee_data_verified per_all_people_f.date_employee_data_verified%type
19: ,date_of_birth per_all_people_f.date_of_birth%type
14: ,background_chk_stat_meaning hr_lookups.meaning%type
15: ,background_date_check per_all_people_f.background_date_check%type
16: ,blood_type_meaning hr_lookups.meaning%type
17: ,corr_lang_meaning hr_lookups.meaning%type
18: ,date_employee_data_verified per_all_people_f.date_employee_data_verified%type
19: ,date_of_birth per_all_people_f.date_of_birth%type
20: ,email_address per_all_people_f.email_address%type
21: ,employee_number per_all_people_f.employee_number%type
22: ,expnse_chk_send_addr_meaning hr_lookups.meaning%type
15: ,background_date_check per_all_people_f.background_date_check%type
16: ,blood_type_meaning hr_lookups.meaning%type
17: ,corr_lang_meaning hr_lookups.meaning%type
18: ,date_employee_data_verified per_all_people_f.date_employee_data_verified%type
19: ,date_of_birth per_all_people_f.date_of_birth%type
20: ,email_address per_all_people_f.email_address%type
21: ,employee_number per_all_people_f.employee_number%type
22: ,expnse_chk_send_addr_meaning hr_lookups.meaning%type
23: ,first_name per_all_people_f.first_name%type
16: ,blood_type_meaning hr_lookups.meaning%type
17: ,corr_lang_meaning hr_lookups.meaning%type
18: ,date_employee_data_verified per_all_people_f.date_employee_data_verified%type
19: ,date_of_birth per_all_people_f.date_of_birth%type
20: ,email_address per_all_people_f.email_address%type
21: ,employee_number per_all_people_f.employee_number%type
22: ,expnse_chk_send_addr_meaning hr_lookups.meaning%type
23: ,first_name per_all_people_f.first_name%type
24: ,per_fte_capacity per_all_people_f.fte_capacity%type
17: ,corr_lang_meaning hr_lookups.meaning%type
18: ,date_employee_data_verified per_all_people_f.date_employee_data_verified%type
19: ,date_of_birth per_all_people_f.date_of_birth%type
20: ,email_address per_all_people_f.email_address%type
21: ,employee_number per_all_people_f.employee_number%type
22: ,expnse_chk_send_addr_meaning hr_lookups.meaning%type
23: ,first_name per_all_people_f.first_name%type
24: ,per_fte_capacity per_all_people_f.fte_capacity%type
25: ,full_name per_all_people_f.full_name%type
19: ,date_of_birth per_all_people_f.date_of_birth%type
20: ,email_address per_all_people_f.email_address%type
21: ,employee_number per_all_people_f.employee_number%type
22: ,expnse_chk_send_addr_meaning hr_lookups.meaning%type
23: ,first_name per_all_people_f.first_name%type
24: ,per_fte_capacity per_all_people_f.fte_capacity%type
25: ,full_name per_all_people_f.full_name%type
26: --CWK
27: ,npw_number per_all_people_f.npw_number%type
20: ,email_address per_all_people_f.email_address%type
21: ,employee_number per_all_people_f.employee_number%type
22: ,expnse_chk_send_addr_meaning hr_lookups.meaning%type
23: ,first_name per_all_people_f.first_name%type
24: ,per_fte_capacity per_all_people_f.fte_capacity%type
25: ,full_name per_all_people_f.full_name%type
26: --CWK
27: ,npw_number per_all_people_f.npw_number%type
28: ,project_title per_all_assignments_f.project_title%type
21: ,employee_number per_all_people_f.employee_number%type
22: ,expnse_chk_send_addr_meaning hr_lookups.meaning%type
23: ,first_name per_all_people_f.first_name%type
24: ,per_fte_capacity per_all_people_f.fte_capacity%type
25: ,full_name per_all_people_f.full_name%type
26: --CWK
27: ,npw_number per_all_people_f.npw_number%type
28: ,project_title per_all_assignments_f.project_title%type
29: ,vendor_employee_number per_all_assignments_f.vendor_employee_number%type
23: ,first_name per_all_people_f.first_name%type
24: ,per_fte_capacity per_all_people_f.fte_capacity%type
25: ,full_name per_all_people_f.full_name%type
26: --CWK
27: ,npw_number per_all_people_f.npw_number%type
28: ,project_title per_all_assignments_f.project_title%type
29: ,vendor_employee_number per_all_assignments_f.vendor_employee_number%type
30: ,vendor_assignment_number per_all_assignments_f.vendor_assignment_number%type
31: ,vendor_name po_vendors.vendor_name%type
32: ,vendor_site_code po_vendor_sites_all.vendor_site_code%TYPE
33: ,po_header_num po_headers_all.segment1%TYPE
34: ,po_line_num po_lines_all.line_num%TYPE
35: --
36: ,hold_applicant_date_until per_all_people_f.hold_applicant_date_until%type
37: ,honors per_all_people_f.honors%type
38: ,internal_location per_all_people_f.internal_location%type
39: ,known_as per_all_people_f.known_as%type
40: ,last_medical_test_by per_all_people_f.last_medical_test_by%type
33: ,po_header_num po_headers_all.segment1%TYPE
34: ,po_line_num po_lines_all.line_num%TYPE
35: --
36: ,hold_applicant_date_until per_all_people_f.hold_applicant_date_until%type
37: ,honors per_all_people_f.honors%type
38: ,internal_location per_all_people_f.internal_location%type
39: ,known_as per_all_people_f.known_as%type
40: ,last_medical_test_by per_all_people_f.last_medical_test_by%type
41: ,last_medical_test_date per_all_people_f.last_medical_test_date%type
34: ,po_line_num po_lines_all.line_num%TYPE
35: --
36: ,hold_applicant_date_until per_all_people_f.hold_applicant_date_until%type
37: ,honors per_all_people_f.honors%type
38: ,internal_location per_all_people_f.internal_location%type
39: ,known_as per_all_people_f.known_as%type
40: ,last_medical_test_by per_all_people_f.last_medical_test_by%type
41: ,last_medical_test_date per_all_people_f.last_medical_test_date%type
42: ,mailstop per_all_people_f.mailstop%type
35: --
36: ,hold_applicant_date_until per_all_people_f.hold_applicant_date_until%type
37: ,honors per_all_people_f.honors%type
38: ,internal_location per_all_people_f.internal_location%type
39: ,known_as per_all_people_f.known_as%type
40: ,last_medical_test_by per_all_people_f.last_medical_test_by%type
41: ,last_medical_test_date per_all_people_f.last_medical_test_date%type
42: ,mailstop per_all_people_f.mailstop%type
43: ,marital_status_meaning hr_lookups.meaning%type
36: ,hold_applicant_date_until per_all_people_f.hold_applicant_date_until%type
37: ,honors per_all_people_f.honors%type
38: ,internal_location per_all_people_f.internal_location%type
39: ,known_as per_all_people_f.known_as%type
40: ,last_medical_test_by per_all_people_f.last_medical_test_by%type
41: ,last_medical_test_date per_all_people_f.last_medical_test_date%type
42: ,mailstop per_all_people_f.mailstop%type
43: ,marital_status_meaning hr_lookups.meaning%type
44: ,middle_names per_all_people_f.middle_names%type
37: ,honors per_all_people_f.honors%type
38: ,internal_location per_all_people_f.internal_location%type
39: ,known_as per_all_people_f.known_as%type
40: ,last_medical_test_by per_all_people_f.last_medical_test_by%type
41: ,last_medical_test_date per_all_people_f.last_medical_test_date%type
42: ,mailstop per_all_people_f.mailstop%type
43: ,marital_status_meaning hr_lookups.meaning%type
44: ,middle_names per_all_people_f.middle_names%type
45: ,nationality_meaning hr_lookups.meaning%type
38: ,internal_location per_all_people_f.internal_location%type
39: ,known_as per_all_people_f.known_as%type
40: ,last_medical_test_by per_all_people_f.last_medical_test_by%type
41: ,last_medical_test_date per_all_people_f.last_medical_test_date%type
42: ,mailstop per_all_people_f.mailstop%type
43: ,marital_status_meaning hr_lookups.meaning%type
44: ,middle_names per_all_people_f.middle_names%type
45: ,nationality_meaning hr_lookups.meaning%type
46: ,national_identifier per_all_people_f.national_identifier%type
40: ,last_medical_test_by per_all_people_f.last_medical_test_by%type
41: ,last_medical_test_date per_all_people_f.last_medical_test_date%type
42: ,mailstop per_all_people_f.mailstop%type
43: ,marital_status_meaning hr_lookups.meaning%type
44: ,middle_names per_all_people_f.middle_names%type
45: ,nationality_meaning hr_lookups.meaning%type
46: ,national_identifier per_all_people_f.national_identifier%type
47: ,office_number per_all_people_f.office_number%type
48: ,on_military_service_meaning hr_lookups.meaning%type
42: ,mailstop per_all_people_f.mailstop%type
43: ,marital_status_meaning hr_lookups.meaning%type
44: ,middle_names per_all_people_f.middle_names%type
45: ,nationality_meaning hr_lookups.meaning%type
46: ,national_identifier per_all_people_f.national_identifier%type
47: ,office_number per_all_people_f.office_number%type
48: ,on_military_service_meaning hr_lookups.meaning%type
49: ,pre_name_adjunct per_all_people_f.pre_name_adjunct%type
50: ,previous_last_name per_all_people_f.previous_last_name%type
43: ,marital_status_meaning hr_lookups.meaning%type
44: ,middle_names per_all_people_f.middle_names%type
45: ,nationality_meaning hr_lookups.meaning%type
46: ,national_identifier per_all_people_f.national_identifier%type
47: ,office_number per_all_people_f.office_number%type
48: ,on_military_service_meaning hr_lookups.meaning%type
49: ,pre_name_adjunct per_all_people_f.pre_name_adjunct%type
50: ,previous_last_name per_all_people_f.previous_last_name%type
51: ,rehire_recommendation per_all_people_f.rehire_recommendation%type
45: ,nationality_meaning hr_lookups.meaning%type
46: ,national_identifier per_all_people_f.national_identifier%type
47: ,office_number per_all_people_f.office_number%type
48: ,on_military_service_meaning hr_lookups.meaning%type
49: ,pre_name_adjunct per_all_people_f.pre_name_adjunct%type
50: ,previous_last_name per_all_people_f.previous_last_name%type
51: ,rehire_recommendation per_all_people_f.rehire_recommendation%type
52: ,resume_exists_meaning hr_lookups.meaning%type
53: ,resume_last_updated per_all_people_f.resume_last_updated%type
46: ,national_identifier per_all_people_f.national_identifier%type
47: ,office_number per_all_people_f.office_number%type
48: ,on_military_service_meaning hr_lookups.meaning%type
49: ,pre_name_adjunct per_all_people_f.pre_name_adjunct%type
50: ,previous_last_name per_all_people_f.previous_last_name%type
51: ,rehire_recommendation per_all_people_f.rehire_recommendation%type
52: ,resume_exists_meaning hr_lookups.meaning%type
53: ,resume_last_updated per_all_people_f.resume_last_updated%type
54: -- Bug 3037019
47: ,office_number per_all_people_f.office_number%type
48: ,on_military_service_meaning hr_lookups.meaning%type
49: ,pre_name_adjunct per_all_people_f.pre_name_adjunct%type
50: ,previous_last_name per_all_people_f.previous_last_name%type
51: ,rehire_recommendation per_all_people_f.rehire_recommendation%type
52: ,resume_exists_meaning hr_lookups.meaning%type
53: ,resume_last_updated per_all_people_f.resume_last_updated%type
54: -- Bug 3037019
55: ,registered_disabled_flag hr_lookups.meaning%type
49: ,pre_name_adjunct per_all_people_f.pre_name_adjunct%type
50: ,previous_last_name per_all_people_f.previous_last_name%type
51: ,rehire_recommendation per_all_people_f.rehire_recommendation%type
52: ,resume_exists_meaning hr_lookups.meaning%type
53: ,resume_last_updated per_all_people_f.resume_last_updated%type
54: -- Bug 3037019
55: ,registered_disabled_flag hr_lookups.meaning%type
56: ,secnd_passport_exsts_meaning hr_lookups.meaning%type
57: ,sex_meaning hr_lookups.meaning%type
55: ,registered_disabled_flag hr_lookups.meaning%type
56: ,secnd_passport_exsts_meaning hr_lookups.meaning%type
57: ,sex_meaning hr_lookups.meaning%type
58: ,student_status_meaning hr_lookups.meaning%type
59: ,suffix per_all_people_f.suffix%type
60: ,title_meaning hr_lookups.meaning%type
61: ,work_schedule_meaning hr_lookups.meaning%type
62: ,coord_ben_med_pln_no per_all_people_f.coord_ben_med_pln_no%type
63: ,cord_ben_no_cvg_flag_meaning hr_lookups.meaning%type
58: ,student_status_meaning hr_lookups.meaning%type
59: ,suffix per_all_people_f.suffix%type
60: ,title_meaning hr_lookups.meaning%type
61: ,work_schedule_meaning hr_lookups.meaning%type
62: ,coord_ben_med_pln_no per_all_people_f.coord_ben_med_pln_no%type
63: ,cord_ben_no_cvg_flag_meaning hr_lookups.meaning%type
64: ,dpdnt_adoption_date per_all_people_f.dpdnt_adoption_date%type
65: ,dpdnt_vlntry_svc_flg_meaning hr_lookups.meaning%type
66: ,receipt_of_death_cert_date per_all_people_f.receipt_of_death_cert_date%type
60: ,title_meaning hr_lookups.meaning%type
61: ,work_schedule_meaning hr_lookups.meaning%type
62: ,coord_ben_med_pln_no per_all_people_f.coord_ben_med_pln_no%type
63: ,cord_ben_no_cvg_flag_meaning hr_lookups.meaning%type
64: ,dpdnt_adoption_date per_all_people_f.dpdnt_adoption_date%type
65: ,dpdnt_vlntry_svc_flg_meaning hr_lookups.meaning%type
66: ,receipt_of_death_cert_date per_all_people_f.receipt_of_death_cert_date%type
67: ,uses_tobacco_meaning hr_lookups.meaning%type
68: ,benefit_group ben_benfts_grp.name%type
62: ,coord_ben_med_pln_no per_all_people_f.coord_ben_med_pln_no%type
63: ,cord_ben_no_cvg_flag_meaning hr_lookups.meaning%type
64: ,dpdnt_adoption_date per_all_people_f.dpdnt_adoption_date%type
65: ,dpdnt_vlntry_svc_flg_meaning hr_lookups.meaning%type
66: ,receipt_of_death_cert_date per_all_people_f.receipt_of_death_cert_date%type
67: ,uses_tobacco_meaning hr_lookups.meaning%type
68: ,benefit_group ben_benfts_grp.name%type
69: /* These fields are no longer used because they may change
70: context on a row by row basis, making them meaningless in a table
68: ,benefit_group ben_benfts_grp.name%type
69: /* These fields are no longer used because they may change
70: context on a row by row basis, making them meaningless in a table
71:
72: ,attribute_category per_all_people_f.attribute_category%type
73: ,attribute1 per_all_people_f.attribute1%type
74: ,attribute1_v varchar2(150)
75: ,attribute1_m varchar2(150)
76: ,attribute2 per_all_people_f.attribute2%type
69: /* These fields are no longer used because they may change
70: context on a row by row basis, making them meaningless in a table
71:
72: ,attribute_category per_all_people_f.attribute_category%type
73: ,attribute1 per_all_people_f.attribute1%type
74: ,attribute1_v varchar2(150)
75: ,attribute1_m varchar2(150)
76: ,attribute2 per_all_people_f.attribute2%type
77: ,attribute2_v varchar2(150)
72: ,attribute_category per_all_people_f.attribute_category%type
73: ,attribute1 per_all_people_f.attribute1%type
74: ,attribute1_v varchar2(150)
75: ,attribute1_m varchar2(150)
76: ,attribute2 per_all_people_f.attribute2%type
77: ,attribute2_v varchar2(150)
78: ,attribute2_m varchar2(150)
79: ,attribute3 per_all_people_f.attribute3%type
80: ,attribute3_v varchar2(150)
75: ,attribute1_m varchar2(150)
76: ,attribute2 per_all_people_f.attribute2%type
77: ,attribute2_v varchar2(150)
78: ,attribute2_m varchar2(150)
79: ,attribute3 per_all_people_f.attribute3%type
80: ,attribute3_v varchar2(150)
81: ,attribute3_m varchar2(150)
82: ,attribute4 per_all_people_f.attribute4%type
83: ,attribute4_v varchar2(150)
78: ,attribute2_m varchar2(150)
79: ,attribute3 per_all_people_f.attribute3%type
80: ,attribute3_v varchar2(150)
81: ,attribute3_m varchar2(150)
82: ,attribute4 per_all_people_f.attribute4%type
83: ,attribute4_v varchar2(150)
84: ,attribute4_m varchar2(150)
85: ,attribute5 per_all_people_f.attribute5%type
86: ,attribute5_v varchar2(150)
81: ,attribute3_m varchar2(150)
82: ,attribute4 per_all_people_f.attribute4%type
83: ,attribute4_v varchar2(150)
84: ,attribute4_m varchar2(150)
85: ,attribute5 per_all_people_f.attribute5%type
86: ,attribute5_v varchar2(150)
87: ,attribute5_m varchar2(150)
88: ,attribute6 per_all_people_f.attribute6%type
89: ,attribute6_v varchar2(150)
84: ,attribute4_m varchar2(150)
85: ,attribute5 per_all_people_f.attribute5%type
86: ,attribute5_v varchar2(150)
87: ,attribute5_m varchar2(150)
88: ,attribute6 per_all_people_f.attribute6%type
89: ,attribute6_v varchar2(150)
90: ,attribute6_m varchar2(150)
91: ,attribute7 per_all_people_f.attribute7%type
92: ,attribute7_v varchar2(150)
87: ,attribute5_m varchar2(150)
88: ,attribute6 per_all_people_f.attribute6%type
89: ,attribute6_v varchar2(150)
90: ,attribute6_m varchar2(150)
91: ,attribute7 per_all_people_f.attribute7%type
92: ,attribute7_v varchar2(150)
93: ,attribute7_m varchar2(150)
94: ,attribute8 per_all_people_f.attribute8%type
95: ,attribute8_v varchar2(150)
90: ,attribute6_m varchar2(150)
91: ,attribute7 per_all_people_f.attribute7%type
92: ,attribute7_v varchar2(150)
93: ,attribute7_m varchar2(150)
94: ,attribute8 per_all_people_f.attribute8%type
95: ,attribute8_v varchar2(150)
96: ,attribute8_m varchar2(150)
97: ,attribute9 per_all_people_f.attribute9%type
98: ,attribute9_v varchar2(150)
93: ,attribute7_m varchar2(150)
94: ,attribute8 per_all_people_f.attribute8%type
95: ,attribute8_v varchar2(150)
96: ,attribute8_m varchar2(150)
97: ,attribute9 per_all_people_f.attribute9%type
98: ,attribute9_v varchar2(150)
99: ,attribute9_m varchar2(150)
100: ,attribute10 per_all_people_f.attribute10%type
101: ,attribute10_v varchar2(150)
96: ,attribute8_m varchar2(150)
97: ,attribute9 per_all_people_f.attribute9%type
98: ,attribute9_v varchar2(150)
99: ,attribute9_m varchar2(150)
100: ,attribute10 per_all_people_f.attribute10%type
101: ,attribute10_v varchar2(150)
102: ,attribute10_m varchar2(150)
103: ,attribute11 per_all_people_f.attribute11%type
104: ,attribute11_v varchar2(150)
99: ,attribute9_m varchar2(150)
100: ,attribute10 per_all_people_f.attribute10%type
101: ,attribute10_v varchar2(150)
102: ,attribute10_m varchar2(150)
103: ,attribute11 per_all_people_f.attribute11%type
104: ,attribute11_v varchar2(150)
105: ,attribute11_m varchar2(150)
106: ,attribute12 per_all_people_f.attribute12%type
107: ,attribute12_v varchar2(150)
102: ,attribute10_m varchar2(150)
103: ,attribute11 per_all_people_f.attribute11%type
104: ,attribute11_v varchar2(150)
105: ,attribute11_m varchar2(150)
106: ,attribute12 per_all_people_f.attribute12%type
107: ,attribute12_v varchar2(150)
108: ,attribute12_m varchar2(150)
109: ,attribute13 per_all_people_f.attribute13%type
110: ,attribute13_v varchar2(150)
105: ,attribute11_m varchar2(150)
106: ,attribute12 per_all_people_f.attribute12%type
107: ,attribute12_v varchar2(150)
108: ,attribute12_m varchar2(150)
109: ,attribute13 per_all_people_f.attribute13%type
110: ,attribute13_v varchar2(150)
111: ,attribute13_m varchar2(150)
112: ,attribute14 per_all_people_f.attribute14%type
113: ,attribute14_v varchar2(150)
108: ,attribute12_m varchar2(150)
109: ,attribute13 per_all_people_f.attribute13%type
110: ,attribute13_v varchar2(150)
111: ,attribute13_m varchar2(150)
112: ,attribute14 per_all_people_f.attribute14%type
113: ,attribute14_v varchar2(150)
114: ,attribute14_m varchar2(150)
115: ,attribute15 per_all_people_f.attribute15%type
116: ,attribute15_v varchar2(150)
111: ,attribute13_m varchar2(150)
112: ,attribute14 per_all_people_f.attribute14%type
113: ,attribute14_v varchar2(150)
114: ,attribute14_m varchar2(150)
115: ,attribute15 per_all_people_f.attribute15%type
116: ,attribute15_v varchar2(150)
117: ,attribute15_m varchar2(150)
118: ,attribute16 per_all_people_f.attribute16%type
119: ,attribute16_v varchar2(150)
114: ,attribute14_m varchar2(150)
115: ,attribute15 per_all_people_f.attribute15%type
116: ,attribute15_v varchar2(150)
117: ,attribute15_m varchar2(150)
118: ,attribute16 per_all_people_f.attribute16%type
119: ,attribute16_v varchar2(150)
120: ,attribute16_m varchar2(150)
121: ,attribute17 per_all_people_f.attribute17%type
122: ,attribute17_v varchar2(150)
117: ,attribute15_m varchar2(150)
118: ,attribute16 per_all_people_f.attribute16%type
119: ,attribute16_v varchar2(150)
120: ,attribute16_m varchar2(150)
121: ,attribute17 per_all_people_f.attribute17%type
122: ,attribute17_v varchar2(150)
123: ,attribute17_m varchar2(150)
124: ,attribute18 per_all_people_f.attribute18%type
125: ,attribute18_v varchar2(150)
120: ,attribute16_m varchar2(150)
121: ,attribute17 per_all_people_f.attribute17%type
122: ,attribute17_v varchar2(150)
123: ,attribute17_m varchar2(150)
124: ,attribute18 per_all_people_f.attribute18%type
125: ,attribute18_v varchar2(150)
126: ,attribute18_m varchar2(150)
127: ,attribute19 per_all_people_f.attribute19%type
128: ,attribute19_v varchar2(150)
123: ,attribute17_m varchar2(150)
124: ,attribute18 per_all_people_f.attribute18%type
125: ,attribute18_v varchar2(150)
126: ,attribute18_m varchar2(150)
127: ,attribute19 per_all_people_f.attribute19%type
128: ,attribute19_v varchar2(150)
129: ,attribute19_m varchar2(150)
130: ,attribute20 per_all_people_f.attribute20%type
131: ,attribute20_v varchar2(150)
126: ,attribute18_m varchar2(150)
127: ,attribute19 per_all_people_f.attribute19%type
128: ,attribute19_v varchar2(150)
129: ,attribute19_m varchar2(150)
130: ,attribute20 per_all_people_f.attribute20%type
131: ,attribute20_v varchar2(150)
132: ,attribute20_m varchar2(150)
133: ,attribute21 per_all_people_f.attribute21%type
134: ,attribute21_v varchar2(150)
129: ,attribute19_m varchar2(150)
130: ,attribute20 per_all_people_f.attribute20%type
131: ,attribute20_v varchar2(150)
132: ,attribute20_m varchar2(150)
133: ,attribute21 per_all_people_f.attribute21%type
134: ,attribute21_v varchar2(150)
135: ,attribute21_m varchar2(150)
136: ,attribute22 per_all_people_f.attribute22%type
137: ,attribute22_v varchar2(150)
132: ,attribute20_m varchar2(150)
133: ,attribute21 per_all_people_f.attribute21%type
134: ,attribute21_v varchar2(150)
135: ,attribute21_m varchar2(150)
136: ,attribute22 per_all_people_f.attribute22%type
137: ,attribute22_v varchar2(150)
138: ,attribute22_m varchar2(150)
139: ,attribute23 per_all_people_f.attribute23%type
140: ,attribute23_v varchar2(150)
135: ,attribute21_m varchar2(150)
136: ,attribute22 per_all_people_f.attribute22%type
137: ,attribute22_v varchar2(150)
138: ,attribute22_m varchar2(150)
139: ,attribute23 per_all_people_f.attribute23%type
140: ,attribute23_v varchar2(150)
141: ,attribute23_m varchar2(150)
142: ,attribute24 per_all_people_f.attribute24%type
143: ,attribute24_v varchar2(150)
138: ,attribute22_m varchar2(150)
139: ,attribute23 per_all_people_f.attribute23%type
140: ,attribute23_v varchar2(150)
141: ,attribute23_m varchar2(150)
142: ,attribute24 per_all_people_f.attribute24%type
143: ,attribute24_v varchar2(150)
144: ,attribute24_m varchar2(150)
145: ,attribute25 per_all_people_f.attribute25%type
146: ,attribute25_v varchar2(150)
141: ,attribute23_m varchar2(150)
142: ,attribute24 per_all_people_f.attribute24%type
143: ,attribute24_v varchar2(150)
144: ,attribute24_m varchar2(150)
145: ,attribute25 per_all_people_f.attribute25%type
146: ,attribute25_v varchar2(150)
147: ,attribute25_m varchar2(150)
148: ,attribute26 per_all_people_f.attribute26%type
149: ,attribute26_v varchar2(150)
144: ,attribute24_m varchar2(150)
145: ,attribute25 per_all_people_f.attribute25%type
146: ,attribute25_v varchar2(150)
147: ,attribute25_m varchar2(150)
148: ,attribute26 per_all_people_f.attribute26%type
149: ,attribute26_v varchar2(150)
150: ,attribute26_m varchar2(150)
151: ,attribute27 per_all_people_f.attribute27%type
152: ,attribute27_v varchar2(150)
147: ,attribute25_m varchar2(150)
148: ,attribute26 per_all_people_f.attribute26%type
149: ,attribute26_v varchar2(150)
150: ,attribute26_m varchar2(150)
151: ,attribute27 per_all_people_f.attribute27%type
152: ,attribute27_v varchar2(150)
153: ,attribute27_m varchar2(150)
154: ,attribute28 per_all_people_f.attribute28%type
155: ,attribute28_v varchar2(150)
150: ,attribute26_m varchar2(150)
151: ,attribute27 per_all_people_f.attribute27%type
152: ,attribute27_v varchar2(150)
153: ,attribute27_m varchar2(150)
154: ,attribute28 per_all_people_f.attribute28%type
155: ,attribute28_v varchar2(150)
156: ,attribute28_m varchar2(150)
157: ,attribute29 per_all_people_f.attribute29%type
158: ,attribute29_v varchar2(150)
153: ,attribute27_m varchar2(150)
154: ,attribute28 per_all_people_f.attribute28%type
155: ,attribute28_v varchar2(150)
156: ,attribute28_m varchar2(150)
157: ,attribute29 per_all_people_f.attribute29%type
158: ,attribute29_v varchar2(150)
159: ,attribute29_m varchar2(150)
160: ,attribute30 per_all_people_f.attribute30%type
161: ,attribute30_v varchar2(150)
156: ,attribute28_m varchar2(150)
157: ,attribute29 per_all_people_f.attribute29%type
158: ,attribute29_v varchar2(150)
159: ,attribute29_m varchar2(150)
160: ,attribute30 per_all_people_f.attribute30%type
161: ,attribute30_v varchar2(150)
162: ,attribute30_m varchar2(150)
163: */
164: ,per_information_category per_all_people_f.per_information_category%type
160: ,attribute30 per_all_people_f.attribute30%type
161: ,attribute30_v varchar2(150)
162: ,attribute30_m varchar2(150)
163: */
164: ,per_information_category per_all_people_f.per_information_category%type
165: ,per_information1 per_all_people_f.attribute1%type
166: ,per_information1_v varchar2(150)
167: ,per_information1_m varchar2(150)
168: ,per_information2 per_all_people_f.attribute2%type
161: ,attribute30_v varchar2(150)
162: ,attribute30_m varchar2(150)
163: */
164: ,per_information_category per_all_people_f.per_information_category%type
165: ,per_information1 per_all_people_f.attribute1%type
166: ,per_information1_v varchar2(150)
167: ,per_information1_m varchar2(150)
168: ,per_information2 per_all_people_f.attribute2%type
169: ,per_information2_v varchar2(150)
164: ,per_information_category per_all_people_f.per_information_category%type
165: ,per_information1 per_all_people_f.attribute1%type
166: ,per_information1_v varchar2(150)
167: ,per_information1_m varchar2(150)
168: ,per_information2 per_all_people_f.attribute2%type
169: ,per_information2_v varchar2(150)
170: ,per_information2_m varchar2(150)
171: ,per_information3 per_all_people_f.attribute3%type
172: ,per_information3_v varchar2(150)
167: ,per_information1_m varchar2(150)
168: ,per_information2 per_all_people_f.attribute2%type
169: ,per_information2_v varchar2(150)
170: ,per_information2_m varchar2(150)
171: ,per_information3 per_all_people_f.attribute3%type
172: ,per_information3_v varchar2(150)
173: ,per_information3_m varchar2(150)
174: ,per_information4 per_all_people_f.attribute4%type
175: ,per_information4_v varchar2(150)
170: ,per_information2_m varchar2(150)
171: ,per_information3 per_all_people_f.attribute3%type
172: ,per_information3_v varchar2(150)
173: ,per_information3_m varchar2(150)
174: ,per_information4 per_all_people_f.attribute4%type
175: ,per_information4_v varchar2(150)
176: ,per_information4_m varchar2(150)
177: ,per_information5 per_all_people_f.attribute5%type
178: ,per_information5_v varchar2(150)
173: ,per_information3_m varchar2(150)
174: ,per_information4 per_all_people_f.attribute4%type
175: ,per_information4_v varchar2(150)
176: ,per_information4_m varchar2(150)
177: ,per_information5 per_all_people_f.attribute5%type
178: ,per_information5_v varchar2(150)
179: ,per_information5_m varchar2(150)
180: ,per_information6 per_all_people_f.attribute6%type
181: ,per_information6_v varchar2(150)
176: ,per_information4_m varchar2(150)
177: ,per_information5 per_all_people_f.attribute5%type
178: ,per_information5_v varchar2(150)
179: ,per_information5_m varchar2(150)
180: ,per_information6 per_all_people_f.attribute6%type
181: ,per_information6_v varchar2(150)
182: ,per_information6_m varchar2(150)
183: ,per_information7 per_all_people_f.attribute7%type
184: ,per_information7_v varchar2(150)
179: ,per_information5_m varchar2(150)
180: ,per_information6 per_all_people_f.attribute6%type
181: ,per_information6_v varchar2(150)
182: ,per_information6_m varchar2(150)
183: ,per_information7 per_all_people_f.attribute7%type
184: ,per_information7_v varchar2(150)
185: ,per_information7_m varchar2(150)
186: ,per_information8 per_all_people_f.attribute8%type
187: ,per_information8_v varchar2(150)
182: ,per_information6_m varchar2(150)
183: ,per_information7 per_all_people_f.attribute7%type
184: ,per_information7_v varchar2(150)
185: ,per_information7_m varchar2(150)
186: ,per_information8 per_all_people_f.attribute8%type
187: ,per_information8_v varchar2(150)
188: ,per_information8_m varchar2(150)
189: ,per_information9 per_all_people_f.attribute9%type
190: ,per_information9_v varchar2(150)
185: ,per_information7_m varchar2(150)
186: ,per_information8 per_all_people_f.attribute8%type
187: ,per_information8_v varchar2(150)
188: ,per_information8_m varchar2(150)
189: ,per_information9 per_all_people_f.attribute9%type
190: ,per_information9_v varchar2(150)
191: ,per_information9_m varchar2(150)
192: ,per_information10 per_all_people_f.attribute10%type
193: ,per_information10_v varchar2(150)
188: ,per_information8_m varchar2(150)
189: ,per_information9 per_all_people_f.attribute9%type
190: ,per_information9_v varchar2(150)
191: ,per_information9_m varchar2(150)
192: ,per_information10 per_all_people_f.attribute10%type
193: ,per_information10_v varchar2(150)
194: ,per_information10_m varchar2(150)
195: ,per_information11 per_all_people_f.attribute11%type
196: ,per_information11_v varchar2(150)
191: ,per_information9_m varchar2(150)
192: ,per_information10 per_all_people_f.attribute10%type
193: ,per_information10_v varchar2(150)
194: ,per_information10_m varchar2(150)
195: ,per_information11 per_all_people_f.attribute11%type
196: ,per_information11_v varchar2(150)
197: ,per_information11_m varchar2(150)
198: ,per_information12 per_all_people_f.attribute12%type
199: ,per_information12_v varchar2(150)
194: ,per_information10_m varchar2(150)
195: ,per_information11 per_all_people_f.attribute11%type
196: ,per_information11_v varchar2(150)
197: ,per_information11_m varchar2(150)
198: ,per_information12 per_all_people_f.attribute12%type
199: ,per_information12_v varchar2(150)
200: ,per_information12_m varchar2(150)
201: ,per_information13 per_all_people_f.attribute13%type
202: ,per_information13_v varchar2(150)
197: ,per_information11_m varchar2(150)
198: ,per_information12 per_all_people_f.attribute12%type
199: ,per_information12_v varchar2(150)
200: ,per_information12_m varchar2(150)
201: ,per_information13 per_all_people_f.attribute13%type
202: ,per_information13_v varchar2(150)
203: ,per_information13_m varchar2(150)
204: ,per_information14 per_all_people_f.attribute14%type
205: ,per_information14_v varchar2(150)
200: ,per_information12_m varchar2(150)
201: ,per_information13 per_all_people_f.attribute13%type
202: ,per_information13_v varchar2(150)
203: ,per_information13_m varchar2(150)
204: ,per_information14 per_all_people_f.attribute14%type
205: ,per_information14_v varchar2(150)
206: ,per_information14_m varchar2(150)
207: ,per_information15 per_all_people_f.attribute15%type
208: ,per_information15_v varchar2(150)
203: ,per_information13_m varchar2(150)
204: ,per_information14 per_all_people_f.attribute14%type
205: ,per_information14_v varchar2(150)
206: ,per_information14_m varchar2(150)
207: ,per_information15 per_all_people_f.attribute15%type
208: ,per_information15_v varchar2(150)
209: ,per_information15_m varchar2(150)
210: ,per_information16 per_all_people_f.attribute16%type
211: ,per_information16_v varchar2(150)
206: ,per_information14_m varchar2(150)
207: ,per_information15 per_all_people_f.attribute15%type
208: ,per_information15_v varchar2(150)
209: ,per_information15_m varchar2(150)
210: ,per_information16 per_all_people_f.attribute16%type
211: ,per_information16_v varchar2(150)
212: ,per_information16_m varchar2(150)
213: ,per_information17 per_all_people_f.attribute17%type
214: ,per_information17_v varchar2(150)
209: ,per_information15_m varchar2(150)
210: ,per_information16 per_all_people_f.attribute16%type
211: ,per_information16_v varchar2(150)
212: ,per_information16_m varchar2(150)
213: ,per_information17 per_all_people_f.attribute17%type
214: ,per_information17_v varchar2(150)
215: ,per_information17_m varchar2(150)
216: ,per_information18 per_all_people_f.attribute18%type
217: ,per_information18_v varchar2(150)
212: ,per_information16_m varchar2(150)
213: ,per_information17 per_all_people_f.attribute17%type
214: ,per_information17_v varchar2(150)
215: ,per_information17_m varchar2(150)
216: ,per_information18 per_all_people_f.attribute18%type
217: ,per_information18_v varchar2(150)
218: ,per_information18_m varchar2(150)
219: ,per_information19 per_all_people_f.attribute19%type
220: ,per_information19_v varchar2(150)
215: ,per_information17_m varchar2(150)
216: ,per_information18 per_all_people_f.attribute18%type
217: ,per_information18_v varchar2(150)
218: ,per_information18_m varchar2(150)
219: ,per_information19 per_all_people_f.attribute19%type
220: ,per_information19_v varchar2(150)
221: ,per_information19_m varchar2(150)
222: ,per_information20 per_all_people_f.attribute20%type
223: ,per_information20_v varchar2(150)
218: ,per_information18_m varchar2(150)
219: ,per_information19 per_all_people_f.attribute19%type
220: ,per_information19_v varchar2(150)
221: ,per_information19_m varchar2(150)
222: ,per_information20 per_all_people_f.attribute20%type
223: ,per_information20_v varchar2(150)
224: ,per_information20_m varchar2(150)
225: ,per_information21 per_all_people_f.attribute21%type
226: ,per_information21_v varchar2(150)
221: ,per_information19_m varchar2(150)
222: ,per_information20 per_all_people_f.attribute20%type
223: ,per_information20_v varchar2(150)
224: ,per_information20_m varchar2(150)
225: ,per_information21 per_all_people_f.attribute21%type
226: ,per_information21_v varchar2(150)
227: ,per_information21_m varchar2(150)
228: ,per_information22 per_all_people_f.attribute22%type
229: ,per_information22_v varchar2(150)
224: ,per_information20_m varchar2(150)
225: ,per_information21 per_all_people_f.attribute21%type
226: ,per_information21_v varchar2(150)
227: ,per_information21_m varchar2(150)
228: ,per_information22 per_all_people_f.attribute22%type
229: ,per_information22_v varchar2(150)
230: ,per_information22_m varchar2(150)
231: ,per_information23 per_all_people_f.attribute23%type
232: ,per_information23_v varchar2(150)
227: ,per_information21_m varchar2(150)
228: ,per_information22 per_all_people_f.attribute22%type
229: ,per_information22_v varchar2(150)
230: ,per_information22_m varchar2(150)
231: ,per_information23 per_all_people_f.attribute23%type
232: ,per_information23_v varchar2(150)
233: ,per_information23_m varchar2(150)
234: ,per_information24 per_all_people_f.attribute24%type
235: ,per_information24_v varchar2(150)
230: ,per_information22_m varchar2(150)
231: ,per_information23 per_all_people_f.attribute23%type
232: ,per_information23_v varchar2(150)
233: ,per_information23_m varchar2(150)
234: ,per_information24 per_all_people_f.attribute24%type
235: ,per_information24_v varchar2(150)
236: ,per_information24_m varchar2(150)
237: ,per_information25 per_all_people_f.attribute25%type
238: ,per_information25_v varchar2(150)
233: ,per_information23_m varchar2(150)
234: ,per_information24 per_all_people_f.attribute24%type
235: ,per_information24_v varchar2(150)
236: ,per_information24_m varchar2(150)
237: ,per_information25 per_all_people_f.attribute25%type
238: ,per_information25_v varchar2(150)
239: ,per_information25_m varchar2(150)
240: ,per_information26 per_all_people_f.attribute26%type
241: ,per_information26_v varchar2(150)
236: ,per_information24_m varchar2(150)
237: ,per_information25 per_all_people_f.attribute25%type
238: ,per_information25_v varchar2(150)
239: ,per_information25_m varchar2(150)
240: ,per_information26 per_all_people_f.attribute26%type
241: ,per_information26_v varchar2(150)
242: ,per_information26_m varchar2(150)
243: ,per_information27 per_all_people_f.attribute27%type
244: ,per_information27_v varchar2(150)
239: ,per_information25_m varchar2(150)
240: ,per_information26 per_all_people_f.attribute26%type
241: ,per_information26_v varchar2(150)
242: ,per_information26_m varchar2(150)
243: ,per_information27 per_all_people_f.attribute27%type
244: ,per_information27_v varchar2(150)
245: ,per_information27_m varchar2(150)
246: ,per_information28 per_all_people_f.attribute28%type
247: ,per_information28_v varchar2(150)
242: ,per_information26_m varchar2(150)
243: ,per_information27 per_all_people_f.attribute27%type
244: ,per_information27_v varchar2(150)
245: ,per_information27_m varchar2(150)
246: ,per_information28 per_all_people_f.attribute28%type
247: ,per_information28_v varchar2(150)
248: ,per_information28_m varchar2(150)
249: ,per_information29 per_all_people_f.attribute29%type
250: ,per_information29_v varchar2(150)
245: ,per_information27_m varchar2(150)
246: ,per_information28 per_all_people_f.attribute28%type
247: ,per_information28_v varchar2(150)
248: ,per_information28_m varchar2(150)
249: ,per_information29 per_all_people_f.attribute29%type
250: ,per_information29_v varchar2(150)
251: ,per_information29_m varchar2(150)
252: ,per_information30 per_all_people_f.attribute30%type
253: ,per_information30_v varchar2(150)
248: ,per_information28_m varchar2(150)
249: ,per_information29 per_all_people_f.attribute29%type
250: ,per_information29_v varchar2(150)
251: ,per_information29_m varchar2(150)
252: ,per_information30 per_all_people_f.attribute30%type
253: ,per_information30_v varchar2(150)
254: ,per_information30_m varchar2(150)
255: ,date_of_death per_all_people_f.date_of_death%type
256: ,hire_date per_periods_of_service.date_start%type
251: ,per_information29_m varchar2(150)
252: ,per_information30 per_all_people_f.attribute30%type
253: ,per_information30_v varchar2(150)
254: ,per_information30_m varchar2(150)
255: ,date_of_death per_all_people_f.date_of_death%type
256: ,hire_date per_periods_of_service.date_start%type
257: ,projected_hire_date per_applications.projected_hire_date%type
258: ,assignment_id per_all_assignments_f.assignment_id%type
259: ,asg_effective_start_date per_all_assignments_f.effective_start_date%type
257: ,projected_hire_date per_applications.projected_hire_date%type
258: ,assignment_id per_all_assignments_f.assignment_id%type
259: ,asg_effective_start_date per_all_assignments_f.effective_start_date%type
260: ,asg_effective_end_date per_all_assignments_f.effective_end_date%type
261: ,recruiter per_all_people_f.full_name%type
262: ,grade per_grades.name%type
263: ,grade_ladder ben_pgm_f.name%type
264: ,position hr_all_positions_f.name%type
265: ,job per_jobs.name%type
266: ,assignment_status_type per_assignment_status_types.user_status%type
267: ,system_status per_assignment_status_types.per_system_status%type
268: ,payroll pay_all_payrolls_f.payroll_name%type
269: ,location hr_locations.location_code%type
270: ,person_referred_by per_all_people_f.full_name%type
271: ,supervisor per_all_people_f.full_name%type
272: ,supervisor_assignment_number per_assignments_v.supervisor_assignment_number%type
273: ,recruitment_activity per_recruitment_activities.name%type
274: ,source_organization hr_all_organization_units.name%type
267: ,system_status per_assignment_status_types.per_system_status%type
268: ,payroll pay_all_payrolls_f.payroll_name%type
269: ,location hr_locations.location_code%type
270: ,person_referred_by per_all_people_f.full_name%type
271: ,supervisor per_all_people_f.full_name%type
272: ,supervisor_assignment_number per_assignments_v.supervisor_assignment_number%type
273: ,recruitment_activity per_recruitment_activities.name%type
274: ,source_organization hr_all_organization_units.name%type
275: ,organization hr_all_organization_units.name%type
590: index by binary_integer;
591:
592: procedure findquery(resultset IN OUT NOCOPY findtab
593: ,p_effective_date date
594: ,business_group_id per_all_people_f.business_group_id%type
595: ,business_group_name per_business_groups.name%type default null
596: ,person_id per_all_people_f.person_id%type default null
597: ,person_type per_person_types.user_person_type%type default null
598: ,system_person_type per_person_types.system_person_type%type default null
592: procedure findquery(resultset IN OUT NOCOPY findtab
593: ,p_effective_date date
594: ,business_group_id per_all_people_f.business_group_id%type
595: ,business_group_name per_business_groups.name%type default null
596: ,person_id per_all_people_f.person_id%type default null
597: ,person_type per_person_types.user_person_type%type default null
598: ,system_person_type per_person_types.system_person_type%type default null
599: ,person_type_id per_all_people_f.person_type_id%type default null
600: ,last_name per_all_people_f.last_name%type default null
595: ,business_group_name per_business_groups.name%type default null
596: ,person_id per_all_people_f.person_id%type default null
597: ,person_type per_person_types.user_person_type%type default null
598: ,system_person_type per_person_types.system_person_type%type default null
599: ,person_type_id per_all_people_f.person_type_id%type default null
600: ,last_name per_all_people_f.last_name%type default null
601: ,start_date per_all_people_f.start_date%type default null
602: ,hire_date per_periods_of_service.date_start%type default null
603: ,applicant_number per_all_people_f.applicant_number%type default null
596: ,person_id per_all_people_f.person_id%type default null
597: ,person_type per_person_types.user_person_type%type default null
598: ,system_person_type per_person_types.system_person_type%type default null
599: ,person_type_id per_all_people_f.person_type_id%type default null
600: ,last_name per_all_people_f.last_name%type default null
601: ,start_date per_all_people_f.start_date%type default null
602: ,hire_date per_periods_of_service.date_start%type default null
603: ,applicant_number per_all_people_f.applicant_number%type default null
604: ,date_of_birth per_all_people_f.date_of_birth%type default null
597: ,person_type per_person_types.user_person_type%type default null
598: ,system_person_type per_person_types.system_person_type%type default null
599: ,person_type_id per_all_people_f.person_type_id%type default null
600: ,last_name per_all_people_f.last_name%type default null
601: ,start_date per_all_people_f.start_date%type default null
602: ,hire_date per_periods_of_service.date_start%type default null
603: ,applicant_number per_all_people_f.applicant_number%type default null
604: ,date_of_birth per_all_people_f.date_of_birth%type default null
605: ,email_address per_all_people_f.email_address%type default null
599: ,person_type_id per_all_people_f.person_type_id%type default null
600: ,last_name per_all_people_f.last_name%type default null
601: ,start_date per_all_people_f.start_date%type default null
602: ,hire_date per_periods_of_service.date_start%type default null
603: ,applicant_number per_all_people_f.applicant_number%type default null
604: ,date_of_birth per_all_people_f.date_of_birth%type default null
605: ,email_address per_all_people_f.email_address%type default null
606: ,employee_number per_all_people_f.employee_number%type default null
607: --CWK
600: ,last_name per_all_people_f.last_name%type default null
601: ,start_date per_all_people_f.start_date%type default null
602: ,hire_date per_periods_of_service.date_start%type default null
603: ,applicant_number per_all_people_f.applicant_number%type default null
604: ,date_of_birth per_all_people_f.date_of_birth%type default null
605: ,email_address per_all_people_f.email_address%type default null
606: ,employee_number per_all_people_f.employee_number%type default null
607: --CWK
608: ,npw_number per_all_people_f.npw_number%type default null
601: ,start_date per_all_people_f.start_date%type default null
602: ,hire_date per_periods_of_service.date_start%type default null
603: ,applicant_number per_all_people_f.applicant_number%type default null
604: ,date_of_birth per_all_people_f.date_of_birth%type default null
605: ,email_address per_all_people_f.email_address%type default null
606: ,employee_number per_all_people_f.employee_number%type default null
607: --CWK
608: ,npw_number per_all_people_f.npw_number%type default null
609: ,project_title per_all_assignments_f.project_title%type default null
602: ,hire_date per_periods_of_service.date_start%type default null
603: ,applicant_number per_all_people_f.applicant_number%type default null
604: ,date_of_birth per_all_people_f.date_of_birth%type default null
605: ,email_address per_all_people_f.email_address%type default null
606: ,employee_number per_all_people_f.employee_number%type default null
607: --CWK
608: ,npw_number per_all_people_f.npw_number%type default null
609: ,project_title per_all_assignments_f.project_title%type default null
610: ,vendor_id per_all_assignments_f.vendor_id%type default null
604: ,date_of_birth per_all_people_f.date_of_birth%type default null
605: ,email_address per_all_people_f.email_address%type default null
606: ,employee_number per_all_people_f.employee_number%type default null
607: --CWK
608: ,npw_number per_all_people_f.npw_number%type default null
609: ,project_title per_all_assignments_f.project_title%type default null
610: ,vendor_id per_all_assignments_f.vendor_id%type default null
611: ,vendor_name po_vendors.vendor_name%type default null
612: ,vendor_employee_number per_all_assignments_f.vendor_employee_number%type default null
617: ,po_header_id po_headers_all.po_header_id%TYPE default null
618: ,po_line_num po_lines_all.line_num%TYPE default null
619: ,po_line_id po_lines_all.po_line_id%TYPE default null
620: --
621: ,first_name per_all_people_f.first_name%type default null
622: ,full_name per_all_people_f.full_name%type default null
623: ,title per_all_people_f.title%type
624: ,middle_names per_all_people_f.middle_names%type
625: ,nationality_meaning hr_lookups.meaning%type default null
618: ,po_line_num po_lines_all.line_num%TYPE default null
619: ,po_line_id po_lines_all.po_line_id%TYPE default null
620: --
621: ,first_name per_all_people_f.first_name%type default null
622: ,full_name per_all_people_f.full_name%type default null
623: ,title per_all_people_f.title%type
624: ,middle_names per_all_people_f.middle_names%type
625: ,nationality_meaning hr_lookups.meaning%type default null
626: ,nationality per_all_people_f.nationality%type default null
619: ,po_line_id po_lines_all.po_line_id%TYPE default null
620: --
621: ,first_name per_all_people_f.first_name%type default null
622: ,full_name per_all_people_f.full_name%type default null
623: ,title per_all_people_f.title%type
624: ,middle_names per_all_people_f.middle_names%type
625: ,nationality_meaning hr_lookups.meaning%type default null
626: ,nationality per_all_people_f.nationality%type default null
627: ,national_identifier per_all_people_f.national_identifier%type default null
620: --
621: ,first_name per_all_people_f.first_name%type default null
622: ,full_name per_all_people_f.full_name%type default null
623: ,title per_all_people_f.title%type
624: ,middle_names per_all_people_f.middle_names%type
625: ,nationality_meaning hr_lookups.meaning%type default null
626: ,nationality per_all_people_f.nationality%type default null
627: ,national_identifier per_all_people_f.national_identifier%type default null
628: -- Bug 3037019
622: ,full_name per_all_people_f.full_name%type default null
623: ,title per_all_people_f.title%type
624: ,middle_names per_all_people_f.middle_names%type
625: ,nationality_meaning hr_lookups.meaning%type default null
626: ,nationality per_all_people_f.nationality%type default null
627: ,national_identifier per_all_people_f.national_identifier%type default null
628: -- Bug 3037019
629: ,registered_disabled_flag hr_lookups.meaning%type default null
630: ,registered_disabled per_all_people_f.registered_disabled_flag%type default null
623: ,title per_all_people_f.title%type
624: ,middle_names per_all_people_f.middle_names%type
625: ,nationality_meaning hr_lookups.meaning%type default null
626: ,nationality per_all_people_f.nationality%type default null
627: ,national_identifier per_all_people_f.national_identifier%type default null
628: -- Bug 3037019
629: ,registered_disabled_flag hr_lookups.meaning%type default null
630: ,registered_disabled per_all_people_f.registered_disabled_flag%type default null
631: ,sex_meaning hr_lookups.meaning%type default null
626: ,nationality per_all_people_f.nationality%type default null
627: ,national_identifier per_all_people_f.national_identifier%type default null
628: -- Bug 3037019
629: ,registered_disabled_flag hr_lookups.meaning%type default null
630: ,registered_disabled per_all_people_f.registered_disabled_flag%type default null
631: ,sex_meaning hr_lookups.meaning%type default null
632: ,sex per_all_people_f.sex%type default null
633: ,benefit_group ben_benfts_grp.name%type default null
634: ,benefit_group_id per_all_people_f.benefit_group_id%type default null
628: -- Bug 3037019
629: ,registered_disabled_flag hr_lookups.meaning%type default null
630: ,registered_disabled per_all_people_f.registered_disabled_flag%type default null
631: ,sex_meaning hr_lookups.meaning%type default null
632: ,sex per_all_people_f.sex%type default null
633: ,benefit_group ben_benfts_grp.name%type default null
634: ,benefit_group_id per_all_people_f.benefit_group_id%type default null
635: ,grade per_grades.name%type default null
636: ,grade_id per_all_assignments_f.grade_id%type default null
630: ,registered_disabled per_all_people_f.registered_disabled_flag%type default null
631: ,sex_meaning hr_lookups.meaning%type default null
632: ,sex per_all_people_f.sex%type default null
633: ,benefit_group ben_benfts_grp.name%type default null
634: ,benefit_group_id per_all_people_f.benefit_group_id%type default null
635: ,grade per_grades.name%type default null
636: ,grade_id per_all_assignments_f.grade_id%type default null
637: ,grade_ladder ben_pgm_f.name%type default null
638: ,grade_ladder_pgm_id per_all_assignments_f.grade_ladder_pgm_id%type default null
645: ,payroll pay_all_payrolls_f.payroll_name%type default null
646: ,payroll_id per_all_assignments_f.payroll_id%type default null
647: ,location hr_locations.location_code%type default null
648: ,location_id per_all_assignments_f.location_id%type default null
649: ,supervisor per_all_people_f.full_name%type default null
650: ,supervisor_id per_all_assignments_f.supervisor_id%type default null
651: ,supervisor_assignment_number per_assignments_v.supervisor_assignment_number%type default null
652: ,supervisor_assignment_id per_all_assignments_f.supervisor_assignment_id%type default null
653: ,recruitment_activity per_recruitment_activities.name%type default null
694:
695:
696: procedure findsave(
697: query_id in number
698: ,business_group_id in per_all_people_f.business_group_id%type
699: ,business_group_name in per_business_groups.name%type
700: ,person_id in per_all_people_f.person_id%type default null
701: ,person_type in per_person_types.user_person_type%type default null
702: ,system_person_type in per_person_types.system_person_type%type default null
696: procedure findsave(
697: query_id in number
698: ,business_group_id in per_all_people_f.business_group_id%type
699: ,business_group_name in per_business_groups.name%type
700: ,person_id in per_all_people_f.person_id%type default null
701: ,person_type in per_person_types.user_person_type%type default null
702: ,system_person_type in per_person_types.system_person_type%type default null
703: ,person_type_id in per_all_people_f.person_type_id%type default null
704: ,last_name in per_all_people_f.last_name%type default null
699: ,business_group_name in per_business_groups.name%type
700: ,person_id in per_all_people_f.person_id%type default null
701: ,person_type in per_person_types.user_person_type%type default null
702: ,system_person_type in per_person_types.system_person_type%type default null
703: ,person_type_id in per_all_people_f.person_type_id%type default null
704: ,last_name in per_all_people_f.last_name%type default null
705: ,start_date in per_all_people_f.start_date%type default null
706: ,hire_date in per_periods_of_service.date_start%type default null
707: ,applicant_number in per_all_people_f.applicant_number%type default null
700: ,person_id in per_all_people_f.person_id%type default null
701: ,person_type in per_person_types.user_person_type%type default null
702: ,system_person_type in per_person_types.system_person_type%type default null
703: ,person_type_id in per_all_people_f.person_type_id%type default null
704: ,last_name in per_all_people_f.last_name%type default null
705: ,start_date in per_all_people_f.start_date%type default null
706: ,hire_date in per_periods_of_service.date_start%type default null
707: ,applicant_number in per_all_people_f.applicant_number%type default null
708: ,date_of_birth in per_all_people_f.date_of_birth%type default null
701: ,person_type in per_person_types.user_person_type%type default null
702: ,system_person_type in per_person_types.system_person_type%type default null
703: ,person_type_id in per_all_people_f.person_type_id%type default null
704: ,last_name in per_all_people_f.last_name%type default null
705: ,start_date in per_all_people_f.start_date%type default null
706: ,hire_date in per_periods_of_service.date_start%type default null
707: ,applicant_number in per_all_people_f.applicant_number%type default null
708: ,date_of_birth in per_all_people_f.date_of_birth%type default null
709: ,email_address in per_all_people_f.email_address%type default null
703: ,person_type_id in per_all_people_f.person_type_id%type default null
704: ,last_name in per_all_people_f.last_name%type default null
705: ,start_date in per_all_people_f.start_date%type default null
706: ,hire_date in per_periods_of_service.date_start%type default null
707: ,applicant_number in per_all_people_f.applicant_number%type default null
708: ,date_of_birth in per_all_people_f.date_of_birth%type default null
709: ,email_address in per_all_people_f.email_address%type default null
710: ,employee_number in per_all_people_f.employee_number%type default null
711: --CWK
704: ,last_name in per_all_people_f.last_name%type default null
705: ,start_date in per_all_people_f.start_date%type default null
706: ,hire_date in per_periods_of_service.date_start%type default null
707: ,applicant_number in per_all_people_f.applicant_number%type default null
708: ,date_of_birth in per_all_people_f.date_of_birth%type default null
709: ,email_address in per_all_people_f.email_address%type default null
710: ,employee_number in per_all_people_f.employee_number%type default null
711: --CWK
712: ,npw_number in per_all_people_f.npw_number%type default null
705: ,start_date in per_all_people_f.start_date%type default null
706: ,hire_date in per_periods_of_service.date_start%type default null
707: ,applicant_number in per_all_people_f.applicant_number%type default null
708: ,date_of_birth in per_all_people_f.date_of_birth%type default null
709: ,email_address in per_all_people_f.email_address%type default null
710: ,employee_number in per_all_people_f.employee_number%type default null
711: --CWK
712: ,npw_number in per_all_people_f.npw_number%type default null
713: ,project_title in per_all_assignments_f.project_title%type default null
706: ,hire_date in per_periods_of_service.date_start%type default null
707: ,applicant_number in per_all_people_f.applicant_number%type default null
708: ,date_of_birth in per_all_people_f.date_of_birth%type default null
709: ,email_address in per_all_people_f.email_address%type default null
710: ,employee_number in per_all_people_f.employee_number%type default null
711: --CWK
712: ,npw_number in per_all_people_f.npw_number%type default null
713: ,project_title in per_all_assignments_f.project_title%type default null
714: ,vendor_id in per_all_assignments_f.vendor_id%type default null
708: ,date_of_birth in per_all_people_f.date_of_birth%type default null
709: ,email_address in per_all_people_f.email_address%type default null
710: ,employee_number in per_all_people_f.employee_number%type default null
711: --CWK
712: ,npw_number in per_all_people_f.npw_number%type default null
713: ,project_title in per_all_assignments_f.project_title%type default null
714: ,vendor_id in per_all_assignments_f.vendor_id%type default null
715: ,vendor_name in po_vendors.vendor_name%type default null
716: ,vendor_employee_number in per_all_assignments_f.vendor_employee_number%type default null
721: ,po_header_id in po_headers_all.po_header_id%TYPE default null
722: ,po_line_num in po_lines_all.line_num%TYPE default null
723: ,po_line_id in po_lines_all.po_line_id%TYPE default null
724: --
725: ,first_name in per_all_people_f.first_name%type default null
726: ,full_name in per_all_people_f.full_name%type default null
727: ,title per_all_people_f.title%type
728: ,middle_names per_all_people_f.middle_names%type
729: ,nationality_meaning in hr_lookups.meaning%type default null
722: ,po_line_num in po_lines_all.line_num%TYPE default null
723: ,po_line_id in po_lines_all.po_line_id%TYPE default null
724: --
725: ,first_name in per_all_people_f.first_name%type default null
726: ,full_name in per_all_people_f.full_name%type default null
727: ,title per_all_people_f.title%type
728: ,middle_names per_all_people_f.middle_names%type
729: ,nationality_meaning in hr_lookups.meaning%type default null
730: ,nationality in per_all_people_f.nationality%type default null
723: ,po_line_id in po_lines_all.po_line_id%TYPE default null
724: --
725: ,first_name in per_all_people_f.first_name%type default null
726: ,full_name in per_all_people_f.full_name%type default null
727: ,title per_all_people_f.title%type
728: ,middle_names per_all_people_f.middle_names%type
729: ,nationality_meaning in hr_lookups.meaning%type default null
730: ,nationality in per_all_people_f.nationality%type default null
731: ,national_identifier in per_all_people_f.national_identifier%type default null
724: --
725: ,first_name in per_all_people_f.first_name%type default null
726: ,full_name in per_all_people_f.full_name%type default null
727: ,title per_all_people_f.title%type
728: ,middle_names per_all_people_f.middle_names%type
729: ,nationality_meaning in hr_lookups.meaning%type default null
730: ,nationality in per_all_people_f.nationality%type default null
731: ,national_identifier in per_all_people_f.national_identifier%type default null
732: -- Bug 3037019
726: ,full_name in per_all_people_f.full_name%type default null
727: ,title per_all_people_f.title%type
728: ,middle_names per_all_people_f.middle_names%type
729: ,nationality_meaning in hr_lookups.meaning%type default null
730: ,nationality in per_all_people_f.nationality%type default null
731: ,national_identifier in per_all_people_f.national_identifier%type default null
732: -- Bug 3037019
733: ,registered_disabled_flag in hr_lookups.meaning%type default null
734: ,registered_disabled in per_all_people_f.registered_disabled_flag%type default null
727: ,title per_all_people_f.title%type
728: ,middle_names per_all_people_f.middle_names%type
729: ,nationality_meaning in hr_lookups.meaning%type default null
730: ,nationality in per_all_people_f.nationality%type default null
731: ,national_identifier in per_all_people_f.national_identifier%type default null
732: -- Bug 3037019
733: ,registered_disabled_flag in hr_lookups.meaning%type default null
734: ,registered_disabled in per_all_people_f.registered_disabled_flag%type default null
735: ,sex_meaning in hr_lookups.meaning%type default null
730: ,nationality in per_all_people_f.nationality%type default null
731: ,national_identifier in per_all_people_f.national_identifier%type default null
732: -- Bug 3037019
733: ,registered_disabled_flag in hr_lookups.meaning%type default null
734: ,registered_disabled in per_all_people_f.registered_disabled_flag%type default null
735: ,sex_meaning in hr_lookups.meaning%type default null
736: ,sex in per_all_people_f.sex%type default null
737: ,benefit_group in ben_benfts_grp.name%type default null
738: ,benefit_group_id in per_all_people_f.benefit_group_id%type default null
732: -- Bug 3037019
733: ,registered_disabled_flag in hr_lookups.meaning%type default null
734: ,registered_disabled in per_all_people_f.registered_disabled_flag%type default null
735: ,sex_meaning in hr_lookups.meaning%type default null
736: ,sex in per_all_people_f.sex%type default null
737: ,benefit_group in ben_benfts_grp.name%type default null
738: ,benefit_group_id in per_all_people_f.benefit_group_id%type default null
739: ,grade in per_grades.name%type default null
740: ,grade_id in per_all_assignments_f.grade_id%type default null
734: ,registered_disabled in per_all_people_f.registered_disabled_flag%type default null
735: ,sex_meaning in hr_lookups.meaning%type default null
736: ,sex in per_all_people_f.sex%type default null
737: ,benefit_group in ben_benfts_grp.name%type default null
738: ,benefit_group_id in per_all_people_f.benefit_group_id%type default null
739: ,grade in per_grades.name%type default null
740: ,grade_id in per_all_assignments_f.grade_id%type default null
741: ,grade_ladder in ben_pgm_f.name%type default null
742: ,grade_ladder_pgm_id in per_all_assignments_f.grade_ladder_pgm_id%type default null
749: ,payroll in pay_all_payrolls_f.payroll_name%type default null
750: ,payroll_id in per_all_assignments_f.payroll_id%type default null
751: ,location in hr_locations.location_code%type default null
752: ,location_id in per_all_assignments_f.location_id%type default null
753: ,supervisor in per_all_people_f.full_name%type default null
754: ,supervisor_id in per_all_assignments_f.supervisor_id%type default null
755: ,supervisor_assignment_number in per_assignments_v.supervisor_assignment_number%type default null
756: ,supervisor_assignment_id in per_all_assignments_f.supervisor_assignment_id%type default null
757: ,recruitment_activity in per_recruitment_activities.name%type default null