eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_QH_FIND_QUERY dependencies on PER_ALL_PEOPLE_F

Line 12: ,business_group_id per_all_people_f.business_group_id%type

8: g_quote varchar2(1) := '''';
9:
10: procedure findquery(resultset IN OUT NOCOPY findtab
11: ,p_effective_date date
12: ,business_group_id per_all_people_f.business_group_id%type
13: ,business_group_name per_business_groups.name%type default null
14: ,person_id per_all_people_f.person_id%type default null
15: ,person_type per_person_types.user_person_type%type default null
16: ,system_person_type per_person_types.system_person_type%type default null

Line 14: ,person_id per_all_people_f.person_id%type default null

10: procedure findquery(resultset IN OUT NOCOPY findtab
11: ,p_effective_date date
12: ,business_group_id per_all_people_f.business_group_id%type
13: ,business_group_name per_business_groups.name%type default null
14: ,person_id per_all_people_f.person_id%type default null
15: ,person_type per_person_types.user_person_type%type default null
16: ,system_person_type per_person_types.system_person_type%type default null
17: ,person_type_id per_all_people_f.person_type_id%type default null
18: ,last_name per_all_people_f.last_name%type default null

Line 17: ,person_type_id per_all_people_f.person_type_id%type default null

13: ,business_group_name per_business_groups.name%type default null
14: ,person_id per_all_people_f.person_id%type default null
15: ,person_type per_person_types.user_person_type%type default null
16: ,system_person_type per_person_types.system_person_type%type default null
17: ,person_type_id per_all_people_f.person_type_id%type default null
18: ,last_name per_all_people_f.last_name%type default null
19: ,start_date per_all_people_f.start_date%type default null
20: ,hire_date per_periods_of_service.date_start%type default null
21: ,applicant_number per_all_people_f.applicant_number%type default null

Line 18: ,last_name per_all_people_f.last_name%type default null

14: ,person_id per_all_people_f.person_id%type default null
15: ,person_type per_person_types.user_person_type%type default null
16: ,system_person_type per_person_types.system_person_type%type default null
17: ,person_type_id per_all_people_f.person_type_id%type default null
18: ,last_name per_all_people_f.last_name%type default null
19: ,start_date per_all_people_f.start_date%type default null
20: ,hire_date per_periods_of_service.date_start%type default null
21: ,applicant_number per_all_people_f.applicant_number%type default null
22: ,date_of_birth per_all_people_f.date_of_birth%type default null

Line 19: ,start_date per_all_people_f.start_date%type default null

15: ,person_type per_person_types.user_person_type%type default null
16: ,system_person_type per_person_types.system_person_type%type default null
17: ,person_type_id per_all_people_f.person_type_id%type default null
18: ,last_name per_all_people_f.last_name%type default null
19: ,start_date per_all_people_f.start_date%type default null
20: ,hire_date per_periods_of_service.date_start%type default null
21: ,applicant_number per_all_people_f.applicant_number%type default null
22: ,date_of_birth per_all_people_f.date_of_birth%type default null
23: ,email_address per_all_people_f.email_address%type default null

Line 21: ,applicant_number per_all_people_f.applicant_number%type default null

17: ,person_type_id per_all_people_f.person_type_id%type default null
18: ,last_name per_all_people_f.last_name%type default null
19: ,start_date per_all_people_f.start_date%type default null
20: ,hire_date per_periods_of_service.date_start%type default null
21: ,applicant_number per_all_people_f.applicant_number%type default null
22: ,date_of_birth per_all_people_f.date_of_birth%type default null
23: ,email_address per_all_people_f.email_address%type default null
24: ,employee_number per_all_people_f.employee_number%type default null
25: --CWK

Line 22: ,date_of_birth per_all_people_f.date_of_birth%type default null

18: ,last_name per_all_people_f.last_name%type default null
19: ,start_date per_all_people_f.start_date%type default null
20: ,hire_date per_periods_of_service.date_start%type default null
21: ,applicant_number per_all_people_f.applicant_number%type default null
22: ,date_of_birth per_all_people_f.date_of_birth%type default null
23: ,email_address per_all_people_f.email_address%type default null
24: ,employee_number per_all_people_f.employee_number%type default null
25: --CWK
26: ,npw_number per_all_people_f.npw_number%type default null

Line 23: ,email_address per_all_people_f.email_address%type default null

19: ,start_date per_all_people_f.start_date%type default null
20: ,hire_date per_periods_of_service.date_start%type default null
21: ,applicant_number per_all_people_f.applicant_number%type default null
22: ,date_of_birth per_all_people_f.date_of_birth%type default null
23: ,email_address per_all_people_f.email_address%type default null
24: ,employee_number per_all_people_f.employee_number%type default null
25: --CWK
26: ,npw_number per_all_people_f.npw_number%type default null
27: ,project_title per_all_assignments_f.project_title%type default null

Line 24: ,employee_number per_all_people_f.employee_number%type default null

20: ,hire_date per_periods_of_service.date_start%type default null
21: ,applicant_number per_all_people_f.applicant_number%type default null
22: ,date_of_birth per_all_people_f.date_of_birth%type default null
23: ,email_address per_all_people_f.email_address%type default null
24: ,employee_number per_all_people_f.employee_number%type default null
25: --CWK
26: ,npw_number per_all_people_f.npw_number%type default null
27: ,project_title per_all_assignments_f.project_title%type default null
28: ,vendor_id per_all_assignments_f.vendor_id%type default null

Line 26: ,npw_number per_all_people_f.npw_number%type default null

22: ,date_of_birth per_all_people_f.date_of_birth%type default null
23: ,email_address per_all_people_f.email_address%type default null
24: ,employee_number per_all_people_f.employee_number%type default null
25: --CWK
26: ,npw_number per_all_people_f.npw_number%type default null
27: ,project_title per_all_assignments_f.project_title%type default null
28: ,vendor_id per_all_assignments_f.vendor_id%type default null
29: ,vendor_name po_vendors.vendor_name%type default null
30: ,vendor_employee_number per_all_assignments_f.vendor_employee_number%type default null

Line 39: ,first_name per_all_people_f.first_name%type default null

35: ,po_header_id po_headers_all.po_header_id%TYPE default null
36: ,po_line_num po_lines_all.line_num%TYPE default null
37: ,po_line_id po_lines_all.po_line_id%TYPE default null
38: --
39: ,first_name per_all_people_f.first_name%type default null
40: ,full_name per_all_people_f.full_name%type default null
41: ,title per_all_people_f.title%type
42: ,middle_names per_all_people_f.middle_names%type
43: ,nationality_meaning hr_lookups.meaning%type default null

Line 40: ,full_name per_all_people_f.full_name%type default null

36: ,po_line_num po_lines_all.line_num%TYPE default null
37: ,po_line_id po_lines_all.po_line_id%TYPE default null
38: --
39: ,first_name per_all_people_f.first_name%type default null
40: ,full_name per_all_people_f.full_name%type default null
41: ,title per_all_people_f.title%type
42: ,middle_names per_all_people_f.middle_names%type
43: ,nationality_meaning hr_lookups.meaning%type default null
44: ,nationality per_all_people_f.nationality%type default null

Line 41: ,title per_all_people_f.title%type

37: ,po_line_id po_lines_all.po_line_id%TYPE default null
38: --
39: ,first_name per_all_people_f.first_name%type default null
40: ,full_name per_all_people_f.full_name%type default null
41: ,title per_all_people_f.title%type
42: ,middle_names per_all_people_f.middle_names%type
43: ,nationality_meaning hr_lookups.meaning%type default null
44: ,nationality per_all_people_f.nationality%type default null
45: ,national_identifier per_all_people_f.national_identifier%type default null

Line 42: ,middle_names per_all_people_f.middle_names%type

38: --
39: ,first_name per_all_people_f.first_name%type default null
40: ,full_name per_all_people_f.full_name%type default null
41: ,title per_all_people_f.title%type
42: ,middle_names per_all_people_f.middle_names%type
43: ,nationality_meaning hr_lookups.meaning%type default null
44: ,nationality per_all_people_f.nationality%type default null
45: ,national_identifier per_all_people_f.national_identifier%type default null
46: -- Bug 3037019

Line 44: ,nationality per_all_people_f.nationality%type default null

40: ,full_name per_all_people_f.full_name%type default null
41: ,title per_all_people_f.title%type
42: ,middle_names per_all_people_f.middle_names%type
43: ,nationality_meaning hr_lookups.meaning%type default null
44: ,nationality per_all_people_f.nationality%type default null
45: ,national_identifier per_all_people_f.national_identifier%type default null
46: -- Bug 3037019
47: ,registered_disabled_flag hr_lookups.meaning%type default null
48: ,registered_disabled per_all_people_f.registered_disabled_flag%type default null

Line 45: ,national_identifier per_all_people_f.national_identifier%type default null

41: ,title per_all_people_f.title%type
42: ,middle_names per_all_people_f.middle_names%type
43: ,nationality_meaning hr_lookups.meaning%type default null
44: ,nationality per_all_people_f.nationality%type default null
45: ,national_identifier per_all_people_f.national_identifier%type default null
46: -- Bug 3037019
47: ,registered_disabled_flag hr_lookups.meaning%type default null
48: ,registered_disabled per_all_people_f.registered_disabled_flag%type default null
49: ,sex_meaning hr_lookups.meaning%type default null

Line 48: ,registered_disabled per_all_people_f.registered_disabled_flag%type default null

44: ,nationality per_all_people_f.nationality%type default null
45: ,national_identifier per_all_people_f.national_identifier%type default null
46: -- Bug 3037019
47: ,registered_disabled_flag hr_lookups.meaning%type default null
48: ,registered_disabled per_all_people_f.registered_disabled_flag%type default null
49: ,sex_meaning hr_lookups.meaning%type default null
50: ,sex per_all_people_f.sex%type default null
51: ,benefit_group ben_benfts_grp.name%type default null
52: ,benefit_group_id per_all_people_f.benefit_group_id%type default null

Line 50: ,sex per_all_people_f.sex%type default null

46: -- Bug 3037019
47: ,registered_disabled_flag hr_lookups.meaning%type default null
48: ,registered_disabled per_all_people_f.registered_disabled_flag%type default null
49: ,sex_meaning hr_lookups.meaning%type default null
50: ,sex per_all_people_f.sex%type default null
51: ,benefit_group ben_benfts_grp.name%type default null
52: ,benefit_group_id per_all_people_f.benefit_group_id%type default null
53: ,grade per_grades.name%type default null
54: ,grade_id per_all_assignments_f.grade_id%type default null

Line 52: ,benefit_group_id per_all_people_f.benefit_group_id%type default null

48: ,registered_disabled per_all_people_f.registered_disabled_flag%type default null
49: ,sex_meaning hr_lookups.meaning%type default null
50: ,sex per_all_people_f.sex%type default null
51: ,benefit_group ben_benfts_grp.name%type default null
52: ,benefit_group_id per_all_people_f.benefit_group_id%type default null
53: ,grade per_grades.name%type default null
54: ,grade_id per_all_assignments_f.grade_id%type default null
55: ,grade_ladder ben_pgm_f.name%type default null
56: ,grade_ladder_pgm_id per_all_assignments_f.grade_ladder_pgm_id%type default null

Line 67: ,supervisor per_all_people_f.full_name%type default null

63: ,payroll pay_all_payrolls_f.payroll_name%type default null
64: ,payroll_id per_all_assignments_f.payroll_id%type default null
65: ,location hr_locations.location_code%type default null
66: ,location_id per_all_assignments_f.location_id%type default null
67: ,supervisor per_all_people_f.full_name%type default null
68: ,supervisor_id per_all_assignments_f.supervisor_id%type default null
69: ,supervisor_assignment_number per_assignments_v.supervisor_assignment_number%type default null
70: ,supervisor_assignment_id per_all_assignments_f.supervisor_assignment_id%type default null
71: ,recruitment_activity per_recruitment_activities.name%type default null

Line 120: l_person_id per_all_people_f.person_id%TYPE;

116: --
117: num_row number:=0;
118: out_rec findrec;
119: --
120: l_person_id per_all_people_f.person_id%TYPE;
121: l_assignment_id per_all_assignments_f.assignment_id%type;
122: l_num_asgs NUMBER;
123:
124: l_select_stmt_per VARCHAR2(20000);

Line 128: l_full_name per_all_people_f.full_name%type;

124: l_select_stmt_per VARCHAR2(20000);
125: l_select_stmt_per2 VARCHAR2(20000);
126: l_select_stmt_asg VARCHAR2(20000);
127: --
128: l_full_name per_all_people_f.full_name%type;
129: --
130: l_from_clause VARCHAR2(20000);
131: l_where_clause VARCHAR2(20000);
132: l_effective_date_clause VARCHAR2(20000);

Line 150: from per_all_people_f

146: (p_person_id number
147: ,p_effective_date date) is
148:
149: select *
150: from per_all_people_f
151: where person_id=p_person_id
152: and p_effective_date between effective_start_date and effective_end_date;
153: --
154: cursor csr_lang

Line 166: per_rec per_all_people_f%rowtype;

162: select name
163: from ben_benfts_grp
164: where benfts_grp_id=p_benfts_grp_id;
165: --
166: per_rec per_all_people_f%rowtype;
167: cursor csr_assignment_details
168: (p_assignment_id number
169: ,p_effective_date date) is
170: select *

Line 187: from per_all_people_f

183: (p_person_id number
184: ,p_effective_date date) is
185:
186: select full_name
187: from per_all_people_f
188: where person_id=p_person_id
189: and p_effective_date between effective_start_date and effective_end_date;
190: --
191: cursor csr_supervisor_assgt_number

Line 669: ,'per_all_people_f sup_a','sup_a.person_id','sup_a.full_name');

665: ,'pay_people_groups pgp_a','pgp_a.people_group_id','pgp_a.group_name');
666: l_asg:=TRUE;
667: elsif p_field_name='SUPERVISOR' then
668: l_a_where_clause:=build_varchar2_where('per_asg.supervisor_id',p_condition,p_value
669: ,'per_all_people_f sup_a','sup_a.person_id','sup_a.full_name');
670: l_asg:=TRUE;
671: elsif p_field_name='SUPERVISOR_ASSIGNMENT_NUMBER' then
672: l_a_where_clause:=build_varchar2_where('per_asg.supervisor_assignment_id',p_condition,p_value
673: ,'per_all_assignments_f supan_a','supan_a.assignment_id','supan_a.assignment_number');

Line 796: l_from_clause:=' from per_all_people_f per';

792: --for bug 2632619 conditionally switch the from clause
793: if secure='Y' then
794: l_from_clause:=' from per_people_f per';
795: else
796: l_from_clause:=' from per_all_people_f per';
797: end if;
798:
799: --Modified for PMxbg
800:

Line 1131: l_from_clause:=l_from_clause||',per_all_people_f sup';

1127: if supervisor_id is not null then
1128: l_where_clause:=l_where_clause||' and per_asg.supervisor_id='||supervisor_id;
1129: l_asg:=TRUE;
1130: elsif supervisor is not null then
1131: l_from_clause:=l_from_clause||',per_all_people_f sup';
1132: l_where_clause:=l_where_clause||' and per_asg.supervisor_id=sup.person_id'
1133: ||' and upper(sup.full_name) like ('''||upper(replace(supervisor,g_quote,g_quote||g_quote))||''')'
1134: ||' and '||l_effective_date||' between sup.effective_start_date and sup.effective_end_date'
1135: ||' and sup.business_group_id=per.business_group_id';

Line 1303: -- ||' or hr_security.show_record(''PER_ALL_PEOPLE_F'''

1299: --
1300: --removed for bug 2632619, replaced by conditional change of l_from_clause
1301: -- if secure='Y' then
1302: -- l_where_clause:=l_where_clause||' and (hr_security.view_all=''Y'''
1303: -- ||' or hr_security.show_record(''PER_ALL_PEOPLE_F'''
1304: -- ||',per.person_id,per.person_type_id,per.employee_number,per.applicant_number)=''TRUE'')';
1305: -- end if;
1306: --
1307: if field1_name is not null and field1_condition_code is not null then

Line 2454: ,business_group_id in per_all_people_f.business_group_id%type

2450: end insert_date;
2451: --
2452: procedure findsave(
2453: query_id in number
2454: ,business_group_id in per_all_people_f.business_group_id%type
2455: ,business_group_name in per_business_groups.name%type
2456: ,person_id in per_all_people_f.person_id%type default null
2457: ,person_type in per_person_types.user_person_type%type default null
2458: ,system_person_type in per_person_types.system_person_type%type default null

Line 2456: ,person_id in per_all_people_f.person_id%type default null

2452: procedure findsave(
2453: query_id in number
2454: ,business_group_id in per_all_people_f.business_group_id%type
2455: ,business_group_name in per_business_groups.name%type
2456: ,person_id in per_all_people_f.person_id%type default null
2457: ,person_type in per_person_types.user_person_type%type default null
2458: ,system_person_type in per_person_types.system_person_type%type default null
2459: ,person_type_id in per_all_people_f.person_type_id%type default null
2460: ,last_name in per_all_people_f.last_name%type default null

Line 2459: ,person_type_id in per_all_people_f.person_type_id%type default null

2455: ,business_group_name in per_business_groups.name%type
2456: ,person_id in per_all_people_f.person_id%type default null
2457: ,person_type in per_person_types.user_person_type%type default null
2458: ,system_person_type in per_person_types.system_person_type%type default null
2459: ,person_type_id in per_all_people_f.person_type_id%type default null
2460: ,last_name in per_all_people_f.last_name%type default null
2461: ,start_date in per_all_people_f.start_date%type default null
2462: ,hire_date in per_periods_of_service.date_start%type default null
2463: ,applicant_number in per_all_people_f.applicant_number%type default null

Line 2460: ,last_name in per_all_people_f.last_name%type default null

2456: ,person_id in per_all_people_f.person_id%type default null
2457: ,person_type in per_person_types.user_person_type%type default null
2458: ,system_person_type in per_person_types.system_person_type%type default null
2459: ,person_type_id in per_all_people_f.person_type_id%type default null
2460: ,last_name in per_all_people_f.last_name%type default null
2461: ,start_date in per_all_people_f.start_date%type default null
2462: ,hire_date in per_periods_of_service.date_start%type default null
2463: ,applicant_number in per_all_people_f.applicant_number%type default null
2464: ,date_of_birth in per_all_people_f.date_of_birth%type default null

Line 2461: ,start_date in per_all_people_f.start_date%type default null

2457: ,person_type in per_person_types.user_person_type%type default null
2458: ,system_person_type in per_person_types.system_person_type%type default null
2459: ,person_type_id in per_all_people_f.person_type_id%type default null
2460: ,last_name in per_all_people_f.last_name%type default null
2461: ,start_date in per_all_people_f.start_date%type default null
2462: ,hire_date in per_periods_of_service.date_start%type default null
2463: ,applicant_number in per_all_people_f.applicant_number%type default null
2464: ,date_of_birth in per_all_people_f.date_of_birth%type default null
2465: ,email_address in per_all_people_f.email_address%type default null

Line 2463: ,applicant_number in per_all_people_f.applicant_number%type default null

2459: ,person_type_id in per_all_people_f.person_type_id%type default null
2460: ,last_name in per_all_people_f.last_name%type default null
2461: ,start_date in per_all_people_f.start_date%type default null
2462: ,hire_date in per_periods_of_service.date_start%type default null
2463: ,applicant_number in per_all_people_f.applicant_number%type default null
2464: ,date_of_birth in per_all_people_f.date_of_birth%type default null
2465: ,email_address in per_all_people_f.email_address%type default null
2466: ,employee_number in per_all_people_f.employee_number%type default null
2467: --CWK

Line 2464: ,date_of_birth in per_all_people_f.date_of_birth%type default null

2460: ,last_name in per_all_people_f.last_name%type default null
2461: ,start_date in per_all_people_f.start_date%type default null
2462: ,hire_date in per_periods_of_service.date_start%type default null
2463: ,applicant_number in per_all_people_f.applicant_number%type default null
2464: ,date_of_birth in per_all_people_f.date_of_birth%type default null
2465: ,email_address in per_all_people_f.email_address%type default null
2466: ,employee_number in per_all_people_f.employee_number%type default null
2467: --CWK
2468: ,npw_number in per_all_people_f.npw_number%type default null

Line 2465: ,email_address in per_all_people_f.email_address%type default null

2461: ,start_date in per_all_people_f.start_date%type default null
2462: ,hire_date in per_periods_of_service.date_start%type default null
2463: ,applicant_number in per_all_people_f.applicant_number%type default null
2464: ,date_of_birth in per_all_people_f.date_of_birth%type default null
2465: ,email_address in per_all_people_f.email_address%type default null
2466: ,employee_number in per_all_people_f.employee_number%type default null
2467: --CWK
2468: ,npw_number in per_all_people_f.npw_number%type default null
2469: ,project_title in per_all_assignments_f.project_title%type default null

Line 2466: ,employee_number in per_all_people_f.employee_number%type default null

2462: ,hire_date in per_periods_of_service.date_start%type default null
2463: ,applicant_number in per_all_people_f.applicant_number%type default null
2464: ,date_of_birth in per_all_people_f.date_of_birth%type default null
2465: ,email_address in per_all_people_f.email_address%type default null
2466: ,employee_number in per_all_people_f.employee_number%type default null
2467: --CWK
2468: ,npw_number in per_all_people_f.npw_number%type default null
2469: ,project_title in per_all_assignments_f.project_title%type default null
2470: ,vendor_id in per_all_assignments_f.vendor_id%type default null

Line 2468: ,npw_number in per_all_people_f.npw_number%type default null

2464: ,date_of_birth in per_all_people_f.date_of_birth%type default null
2465: ,email_address in per_all_people_f.email_address%type default null
2466: ,employee_number in per_all_people_f.employee_number%type default null
2467: --CWK
2468: ,npw_number in per_all_people_f.npw_number%type default null
2469: ,project_title in per_all_assignments_f.project_title%type default null
2470: ,vendor_id in per_all_assignments_f.vendor_id%type default null
2471: ,vendor_name in po_vendors.vendor_name%type default null
2472: ,vendor_employee_number in per_all_assignments_f.vendor_employee_number%type default null

Line 2481: ,first_name in per_all_people_f.first_name%type default null

2477: ,po_header_id in po_headers_all.po_header_id%TYPE default null
2478: ,po_line_num in po_lines_all.line_num%TYPE default null
2479: ,po_line_id in po_lines_all.po_line_id%TYPE default null
2480: --
2481: ,first_name in per_all_people_f.first_name%type default null
2482: ,full_name in per_all_people_f.full_name%type default null
2483: ,title in per_all_people_f.title%type
2484: ,middle_names in per_all_people_f.middle_names%type
2485: ,nationality_meaning in hr_lookups.meaning%type default null

Line 2482: ,full_name in per_all_people_f.full_name%type default null

2478: ,po_line_num in po_lines_all.line_num%TYPE default null
2479: ,po_line_id in po_lines_all.po_line_id%TYPE default null
2480: --
2481: ,first_name in per_all_people_f.first_name%type default null
2482: ,full_name in per_all_people_f.full_name%type default null
2483: ,title in per_all_people_f.title%type
2484: ,middle_names in per_all_people_f.middle_names%type
2485: ,nationality_meaning in hr_lookups.meaning%type default null
2486: ,nationality in per_all_people_f.nationality%type default null

Line 2483: ,title in per_all_people_f.title%type

2479: ,po_line_id in po_lines_all.po_line_id%TYPE default null
2480: --
2481: ,first_name in per_all_people_f.first_name%type default null
2482: ,full_name in per_all_people_f.full_name%type default null
2483: ,title in per_all_people_f.title%type
2484: ,middle_names in per_all_people_f.middle_names%type
2485: ,nationality_meaning in hr_lookups.meaning%type default null
2486: ,nationality in per_all_people_f.nationality%type default null
2487: ,national_identifier in per_all_people_f.national_identifier%type default null

Line 2484: ,middle_names in per_all_people_f.middle_names%type

2480: --
2481: ,first_name in per_all_people_f.first_name%type default null
2482: ,full_name in per_all_people_f.full_name%type default null
2483: ,title in per_all_people_f.title%type
2484: ,middle_names in per_all_people_f.middle_names%type
2485: ,nationality_meaning in hr_lookups.meaning%type default null
2486: ,nationality in per_all_people_f.nationality%type default null
2487: ,national_identifier in per_all_people_f.national_identifier%type default null
2488: -- Bug 3037019 Start Here

Line 2486: ,nationality in per_all_people_f.nationality%type default null

2482: ,full_name in per_all_people_f.full_name%type default null
2483: ,title in per_all_people_f.title%type
2484: ,middle_names in per_all_people_f.middle_names%type
2485: ,nationality_meaning in hr_lookups.meaning%type default null
2486: ,nationality in per_all_people_f.nationality%type default null
2487: ,national_identifier in per_all_people_f.national_identifier%type default null
2488: -- Bug 3037019 Start Here
2489: ,registered_disabled_flag in hr_lookups.meaning%type default null
2490: ,registered_disabled in per_all_people_f.registered_disabled_flag%type default null

Line 2487: ,national_identifier in per_all_people_f.national_identifier%type default null

2483: ,title in per_all_people_f.title%type
2484: ,middle_names in per_all_people_f.middle_names%type
2485: ,nationality_meaning in hr_lookups.meaning%type default null
2486: ,nationality in per_all_people_f.nationality%type default null
2487: ,national_identifier in per_all_people_f.national_identifier%type default null
2488: -- Bug 3037019 Start Here
2489: ,registered_disabled_flag in hr_lookups.meaning%type default null
2490: ,registered_disabled in per_all_people_f.registered_disabled_flag%type default null
2491: ,sex_meaning in hr_lookups.meaning%type default null

Line 2490: ,registered_disabled in per_all_people_f.registered_disabled_flag%type default null

2486: ,nationality in per_all_people_f.nationality%type default null
2487: ,national_identifier in per_all_people_f.national_identifier%type default null
2488: -- Bug 3037019 Start Here
2489: ,registered_disabled_flag in hr_lookups.meaning%type default null
2490: ,registered_disabled in per_all_people_f.registered_disabled_flag%type default null
2491: ,sex_meaning in hr_lookups.meaning%type default null
2492: ,sex in per_all_people_f.sex%type default null
2493: ,benefit_group in ben_benfts_grp.name%type default null
2494: ,benefit_group_id in per_all_people_f.benefit_group_id%type default null

Line 2492: ,sex in per_all_people_f.sex%type default null

2488: -- Bug 3037019 Start Here
2489: ,registered_disabled_flag in hr_lookups.meaning%type default null
2490: ,registered_disabled in per_all_people_f.registered_disabled_flag%type default null
2491: ,sex_meaning in hr_lookups.meaning%type default null
2492: ,sex in per_all_people_f.sex%type default null
2493: ,benefit_group in ben_benfts_grp.name%type default null
2494: ,benefit_group_id in per_all_people_f.benefit_group_id%type default null
2495: ,grade in per_grades.name%type default null
2496: ,grade_id in per_all_assignments_f.grade_id%type default null

Line 2494: ,benefit_group_id in per_all_people_f.benefit_group_id%type default null

2490: ,registered_disabled in per_all_people_f.registered_disabled_flag%type default null
2491: ,sex_meaning in hr_lookups.meaning%type default null
2492: ,sex in per_all_people_f.sex%type default null
2493: ,benefit_group in ben_benfts_grp.name%type default null
2494: ,benefit_group_id in per_all_people_f.benefit_group_id%type default null
2495: ,grade in per_grades.name%type default null
2496: ,grade_id in per_all_assignments_f.grade_id%type default null
2497: ,grade_ladder in ben_pgm_f.name%type default null
2498: ,grade_ladder_pgm_id in per_all_assignments_f.grade_ladder_pgm_id%type default null

Line 2509: ,supervisor in per_all_people_f.full_name%type default null

2505: ,payroll in pay_all_payrolls_f.payroll_name%type default null
2506: ,payroll_id in per_all_assignments_f.payroll_id%type default null
2507: ,location in hr_locations.location_code%type default null
2508: ,location_id in per_all_assignments_f.location_id%type default null
2509: ,supervisor in per_all_people_f.full_name%type default null
2510: ,supervisor_id in per_all_assignments_f.supervisor_id%type default null
2511: ,supervisor_assignment_number in per_assignments_v.supervisor_assignment_number%type default null
2512: ,supervisor_assignment_id in per_all_assignments_f.supervisor_assignment_id%type default null
2513: ,recruitment_activity in per_recruitment_activities.name%type default null