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_ASSIGNMENTS_F

Line 27: ,project_title per_all_assignments_f.project_title%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
31: ,vendor_assignment_number per_all_assignments_f.vendor_assignment_number%type default null

Line 28: ,vendor_id per_all_assignments_f.vendor_id%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
31: ,vendor_assignment_number per_all_assignments_f.vendor_assignment_number%type default null
32: ,vendor_site_code po_vendor_sites_all.vendor_site_code%TYPE default null

Line 30: ,vendor_employee_number per_all_assignments_f.vendor_employee_number%type default null

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
31: ,vendor_assignment_number per_all_assignments_f.vendor_assignment_number%type default null
32: ,vendor_site_code po_vendor_sites_all.vendor_site_code%TYPE default null
33: ,vendor_site_id po_vendor_sites_all.vendor_site_id%TYPE default null
34: ,po_header_num po_headers_all.segment1%TYPE default null

Line 31: ,vendor_assignment_number per_all_assignments_f.vendor_assignment_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
31: ,vendor_assignment_number per_all_assignments_f.vendor_assignment_number%type default null
32: ,vendor_site_code po_vendor_sites_all.vendor_site_code%TYPE default null
33: ,vendor_site_id po_vendor_sites_all.vendor_site_id%TYPE default null
34: ,po_header_num po_headers_all.segment1%TYPE default null
35: ,po_header_id po_headers_all.po_header_id%TYPE default null

Line 54: ,grade_id per_all_assignments_f.grade_id%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
57: ,position hr_all_positions_f.name%type default null
58: ,position_id per_all_assignments_f.position_id%type default null

Line 56: ,grade_ladder_pgm_id per_all_assignments_f.grade_ladder_pgm_id%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
57: ,position hr_all_positions_f.name%type default null
58: ,position_id per_all_assignments_f.position_id%type default null
59: ,job per_jobs.name%type default null
60: ,job_id per_all_assignments_f.job_id%type default null

Line 58: ,position_id per_all_assignments_f.position_id%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
57: ,position hr_all_positions_f.name%type default null
58: ,position_id per_all_assignments_f.position_id%type default null
59: ,job per_jobs.name%type default null
60: ,job_id per_all_assignments_f.job_id%type default null
61: ,assignment_status_type per_assignment_status_types.user_status%type default null
62: ,assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type default null

Line 60: ,job_id per_all_assignments_f.job_id%type default null

56: ,grade_ladder_pgm_id per_all_assignments_f.grade_ladder_pgm_id%type default null
57: ,position hr_all_positions_f.name%type default null
58: ,position_id per_all_assignments_f.position_id%type default null
59: ,job per_jobs.name%type default null
60: ,job_id per_all_assignments_f.job_id%type default null
61: ,assignment_status_type per_assignment_status_types.user_status%type default null
62: ,assignment_status_type_id per_all_assignments_f.assignment_status_type_id%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

Line 62: ,assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type default null

58: ,position_id per_all_assignments_f.position_id%type default null
59: ,job per_jobs.name%type default null
60: ,job_id per_all_assignments_f.job_id%type default null
61: ,assignment_status_type per_assignment_status_types.user_status%type default null
62: ,assignment_status_type_id per_all_assignments_f.assignment_status_type_id%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

Line 64: ,payroll_id per_all_assignments_f.payroll_id%type default null

60: ,job_id per_all_assignments_f.job_id%type default null
61: ,assignment_status_type per_assignment_status_types.user_status%type default null
62: ,assignment_status_type_id per_all_assignments_f.assignment_status_type_id%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

Line 66: ,location_id per_all_assignments_f.location_id%type default null

62: ,assignment_status_type_id per_all_assignments_f.assignment_status_type_id%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

Line 68: ,supervisor_id per_all_assignments_f.supervisor_id%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
72: ,recruitment_activity_id per_all_assignments_f.recruitment_activity_id%type default null

Line 70: ,supervisor_assignment_id per_all_assignments_f.supervisor_assignment_id%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
72: ,recruitment_activity_id per_all_assignments_f.recruitment_activity_id%type default null
73: ,organization hr_all_organization_units.name%type default null
74: ,organization_id per_all_assignments_f.organization_id%type default null

Line 72: ,recruitment_activity_id per_all_assignments_f.recruitment_activity_id%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
72: ,recruitment_activity_id per_all_assignments_f.recruitment_activity_id%type default null
73: ,organization hr_all_organization_units.name%type default null
74: ,organization_id per_all_assignments_f.organization_id%type default null
75: ,people_group pay_people_groups.group_name%type default null
76: ,people_group_id per_all_assignments_f.people_group_id%type default null

Line 74: ,organization_id per_all_assignments_f.organization_id%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
72: ,recruitment_activity_id per_all_assignments_f.recruitment_activity_id%type default null
73: ,organization hr_all_organization_units.name%type default null
74: ,organization_id per_all_assignments_f.organization_id%type default null
75: ,people_group pay_people_groups.group_name%type default null
76: ,people_group_id per_all_assignments_f.people_group_id%type default null
77: ,vacancy per_vacancies.name%type default null
78: ,vacancy_id per_all_assignments_f.vacancy_id%type default null

Line 76: ,people_group_id per_all_assignments_f.people_group_id%type default null

72: ,recruitment_activity_id per_all_assignments_f.recruitment_activity_id%type default null
73: ,organization hr_all_organization_units.name%type default null
74: ,organization_id per_all_assignments_f.organization_id%type default null
75: ,people_group pay_people_groups.group_name%type default null
76: ,people_group_id per_all_assignments_f.people_group_id%type default null
77: ,vacancy per_vacancies.name%type default null
78: ,vacancy_id per_all_assignments_f.vacancy_id%type default null
79: ,requisition per_requisitions.name%type default null
80: ,requisition_id per_requisitions.requisition_id%type default null

Line 78: ,vacancy_id per_all_assignments_f.vacancy_id%type default null

74: ,organization_id per_all_assignments_f.organization_id%type default null
75: ,people_group pay_people_groups.group_name%type default null
76: ,people_group_id per_all_assignments_f.people_group_id%type default null
77: ,vacancy per_vacancies.name%type default null
78: ,vacancy_id per_all_assignments_f.vacancy_id%type default null
79: ,requisition per_requisitions.name%type default null
80: ,requisition_id per_requisitions.requisition_id%type default null
81: ,salary_basis per_pay_bases.name%type default null
82: ,pay_basis_id per_all_assignments_f.pay_basis_id%type default null

Line 82: ,pay_basis_id per_all_assignments_f.pay_basis_id%type default null

78: ,vacancy_id per_all_assignments_f.vacancy_id%type default null
79: ,requisition per_requisitions.name%type default null
80: ,requisition_id per_requisitions.requisition_id%type default null
81: ,salary_basis per_pay_bases.name%type default null
82: ,pay_basis_id per_all_assignments_f.pay_basis_id%type default null
83: ,bargaining_unit_code_meaning hr_lookups.meaning%type default null
84: ,bargaining_unit_code per_all_assignments_f.bargaining_unit_code%type default null
85: ,employment_category_meaning hr_lookups.meaning%type default null
86: ,employment_category per_all_assignments_f.employment_category%type default null

Line 84: ,bargaining_unit_code per_all_assignments_f.bargaining_unit_code%type default null

80: ,requisition_id per_requisitions.requisition_id%type default null
81: ,salary_basis per_pay_bases.name%type default null
82: ,pay_basis_id per_all_assignments_f.pay_basis_id%type default null
83: ,bargaining_unit_code_meaning hr_lookups.meaning%type default null
84: ,bargaining_unit_code per_all_assignments_f.bargaining_unit_code%type default null
85: ,employment_category_meaning hr_lookups.meaning%type default null
86: ,employment_category per_all_assignments_f.employment_category%type default null
87: -- BUG 3002915 starts here. modified type.
88: ,establishment hr_leg_establishments_v.name%type default null

Line 86: ,employment_category per_all_assignments_f.employment_category%type default null

82: ,pay_basis_id per_all_assignments_f.pay_basis_id%type default null
83: ,bargaining_unit_code_meaning hr_lookups.meaning%type default null
84: ,bargaining_unit_code per_all_assignments_f.bargaining_unit_code%type default null
85: ,employment_category_meaning hr_lookups.meaning%type default null
86: ,employment_category per_all_assignments_f.employment_category%type default null
87: -- BUG 3002915 starts here. modified type.
88: ,establishment hr_leg_establishments_v.name%type default null
89: ,establishment_id hr_leg_establishments_v.organization_id%type default null
90: -- BUG 3002915 ends here.

Line 121: l_assignment_id per_all_assignments_f.assignment_id%type;

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);
125: l_select_stmt_per2 VARCHAR2(20000);

Line 171: from per_all_assignments_f

167: cursor csr_assignment_details
168: (p_assignment_id number
169: ,p_effective_date date) is
170: select *
171: from per_all_assignments_f
172: where assignment_id=p_assignment_id
173: and p_effective_date between effective_start_date and effective_end_date;
174: --
175: cursor count_asgs(p_person_id number) is

Line 177: from per_all_assignments_f per_asg

173: and p_effective_date between effective_start_date and effective_end_date;
174: --
175: cursor count_asgs(p_person_id number) is
176: select count(*)
177: from per_all_assignments_f per_asg
178: where per_asg.person_id=p_person_id
179: and p_effective_date between per_asg.effective_start_date and per_asg.effective_end_date
180: and per_asg.assignment_type <> 'B' ; -- Added for fix of #3286659
181: --

Line 196: from per_all_assignments_f

192: (p_supervisor_assignment_id number
193: ,p_effective_date date) is
194:
195: select assignment_number
196: from per_all_assignments_f
197: where assignment_id = p_supervisor_assignment_id
198: and p_effective_date between effective_start_date and effective_end_date;
199: --
200: cursor csr_pds(p_person_id number,p_effective_date date) is

Line 365: asg_rec per_all_assignments_f%rowtype;

361: where id_flex_code='CAGR'
362: and application_id=800
363: and id_flex_num=p_id_flex_num;
364: --
365: asg_rec per_all_assignments_f%rowtype;
366: pgp_rec pay_people_groups%rowtype;
367: scl_rec hr_soft_coding_keyflex%rowtype;
368: --
369: cursor csr_vendor(p_vendor_id in number) is

Line 673: ,'per_all_assignments_f supan_a','supan_a.assignment_id','supan_a.assignment_number');

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');
674: l_asg:=TRUE;
675: elsif p_field_name='ORGANIZATION' then
676: l_a_where_clause:=build_varchar2_where('per_asg.organization_id',p_condition,p_value
677: ,'hr_all_organization_units org_a','org_a.organization_id','org_a.name');

Line 1143: l_from_clause:=l_from_clause||',per_all_assignments_f supan';

1139: if supervisor_assignment_id is not null then
1140: l_where_clause:=l_where_clause||' and per_asg.supervisor_assignment_id='||supervisor_assignment_id;
1141: l_asg:=TRUE;
1142: elsif supervisor_assignment_number is not null then
1143: l_from_clause:=l_from_clause||',per_all_assignments_f supan';
1144: l_where_clause:=l_where_clause||' and per_asg.supervisor_assignment_id=supan.assignment_id'
1145: ||' and upper(supan.assignment_number)
1146: like ('''||upper(replace(supervisor_assignment_number,g_quote,g_quote||g_quote))||''')'
1147: ||' and '||l_effective_date||' between supan.effective_start_date and supan.effective_end_date'

Line 1351: l_from_clause:=l_from_clause||',per_all_assignments_f per_asg';

1347:
1348: if secure='Y' then
1349: l_from_clause:=l_from_clause||',per_assignments_f2 per_asg';
1350: else
1351: l_from_clause:=l_from_clause||',per_all_assignments_f per_asg';
1352: end if;
1353: --
1354: l_where_clause:=l_where_clause||' and per.person_id=per_asg.person_id and '
1355: ||l_effective_date||

Line 1452: l_select_stmt_asg:=l_select_stmt_asg||',per_all_assignments_f per_asg';

1448:
1449: select_stmt:=l_from_clause||l_where_clause;
1450: l_select_stmt_asg:='select per_asg.assignment_id '||l_from_clause;
1451: if not l_asg then
1452: l_select_stmt_asg:=l_select_stmt_asg||',per_all_assignments_f per_asg';
1453: end if;
1454: l_select_stmt_asg:=l_select_stmt_asg||l_where_clause;
1455: if not l_asg then
1456: l_select_stmt_asg:=l_select_stmt_asg||' and per.person_id=per_asg.person_id and '

Line 2469: ,project_title in per_all_assignments_f.project_title%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
2473: ,vendor_assignment_number in per_all_assignments_f.vendor_assignment_number%type default null

Line 2470: ,vendor_id in per_all_assignments_f.vendor_id%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
2473: ,vendor_assignment_number in per_all_assignments_f.vendor_assignment_number%type default null
2474: ,vendor_site_code in po_vendor_sites_all.vendor_site_code%TYPE default null

Line 2472: ,vendor_employee_number in per_all_assignments_f.vendor_employee_number%type default null

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
2473: ,vendor_assignment_number in per_all_assignments_f.vendor_assignment_number%type default null
2474: ,vendor_site_code in po_vendor_sites_all.vendor_site_code%TYPE default null
2475: ,vendor_site_id in po_vendor_sites_all.vendor_site_id%TYPE default null
2476: ,po_header_num in po_headers_all.segment1%TYPE default null

Line 2473: ,vendor_assignment_number in per_all_assignments_f.vendor_assignment_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
2473: ,vendor_assignment_number in per_all_assignments_f.vendor_assignment_number%type default null
2474: ,vendor_site_code in po_vendor_sites_all.vendor_site_code%TYPE default null
2475: ,vendor_site_id in po_vendor_sites_all.vendor_site_id%TYPE default null
2476: ,po_header_num in po_headers_all.segment1%TYPE default null
2477: ,po_header_id in po_headers_all.po_header_id%TYPE default null

Line 2496: ,grade_id in per_all_assignments_f.grade_id%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
2499: ,position in hr_all_positions_f.name%type default null
2500: ,position_id in per_all_assignments_f.position_id%type default null

Line 2498: ,grade_ladder_pgm_id in per_all_assignments_f.grade_ladder_pgm_id%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
2499: ,position in hr_all_positions_f.name%type default null
2500: ,position_id in per_all_assignments_f.position_id%type default null
2501: ,job in per_jobs.name%type default null
2502: ,job_id in per_all_assignments_f.job_id%type default null

Line 2500: ,position_id in per_all_assignments_f.position_id%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
2499: ,position in hr_all_positions_f.name%type default null
2500: ,position_id in per_all_assignments_f.position_id%type default null
2501: ,job in per_jobs.name%type default null
2502: ,job_id in per_all_assignments_f.job_id%type default null
2503: ,assignment_status_type in per_assignment_status_types.user_status%type default null
2504: ,assignment_status_type_id in per_all_assignments_f.assignment_status_type_id%type default null

Line 2502: ,job_id in per_all_assignments_f.job_id%type default null

2498: ,grade_ladder_pgm_id in per_all_assignments_f.grade_ladder_pgm_id%type default null
2499: ,position in hr_all_positions_f.name%type default null
2500: ,position_id in per_all_assignments_f.position_id%type default null
2501: ,job in per_jobs.name%type default null
2502: ,job_id in per_all_assignments_f.job_id%type default null
2503: ,assignment_status_type in per_assignment_status_types.user_status%type default null
2504: ,assignment_status_type_id in per_all_assignments_f.assignment_status_type_id%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

Line 2504: ,assignment_status_type_id in per_all_assignments_f.assignment_status_type_id%type default null

2500: ,position_id in per_all_assignments_f.position_id%type default null
2501: ,job in per_jobs.name%type default null
2502: ,job_id in per_all_assignments_f.job_id%type default null
2503: ,assignment_status_type in per_assignment_status_types.user_status%type default null
2504: ,assignment_status_type_id in per_all_assignments_f.assignment_status_type_id%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

Line 2506: ,payroll_id in per_all_assignments_f.payroll_id%type default null

2502: ,job_id in per_all_assignments_f.job_id%type default null
2503: ,assignment_status_type in per_assignment_status_types.user_status%type default null
2504: ,assignment_status_type_id in per_all_assignments_f.assignment_status_type_id%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

Line 2508: ,location_id in per_all_assignments_f.location_id%type default null

2504: ,assignment_status_type_id in per_all_assignments_f.assignment_status_type_id%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

Line 2510: ,supervisor_id in per_all_assignments_f.supervisor_id%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
2514: ,recruitment_activity_id in per_all_assignments_f.recruitment_activity_id%type default null

Line 2512: ,supervisor_assignment_id in per_all_assignments_f.supervisor_assignment_id%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
2514: ,recruitment_activity_id in per_all_assignments_f.recruitment_activity_id%type default null
2515: ,organization in hr_all_organization_units.name%type default null
2516: ,organization_id in per_all_assignments_f.organization_id%type default null

Line 2514: ,recruitment_activity_id in per_all_assignments_f.recruitment_activity_id%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
2514: ,recruitment_activity_id in per_all_assignments_f.recruitment_activity_id%type default null
2515: ,organization in hr_all_organization_units.name%type default null
2516: ,organization_id in per_all_assignments_f.organization_id%type default null
2517: ,people_group in pay_people_groups.group_name%type default null
2518: ,people_group_id in per_all_assignments_f.people_group_id%type default null

Line 2516: ,organization_id in per_all_assignments_f.organization_id%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
2514: ,recruitment_activity_id in per_all_assignments_f.recruitment_activity_id%type default null
2515: ,organization in hr_all_organization_units.name%type default null
2516: ,organization_id in per_all_assignments_f.organization_id%type default null
2517: ,people_group in pay_people_groups.group_name%type default null
2518: ,people_group_id in per_all_assignments_f.people_group_id%type default null
2519: ,vacancy in per_vacancies.name%type default null
2520: ,vacancy_id in per_all_assignments_f.vacancy_id%type default null

Line 2518: ,people_group_id in per_all_assignments_f.people_group_id%type default null

2514: ,recruitment_activity_id in per_all_assignments_f.recruitment_activity_id%type default null
2515: ,organization in hr_all_organization_units.name%type default null
2516: ,organization_id in per_all_assignments_f.organization_id%type default null
2517: ,people_group in pay_people_groups.group_name%type default null
2518: ,people_group_id in per_all_assignments_f.people_group_id%type default null
2519: ,vacancy in per_vacancies.name%type default null
2520: ,vacancy_id in per_all_assignments_f.vacancy_id%type default null
2521: ,requisition in per_requisitions.name%type default null
2522: ,requisition_id in per_requisitions.requisition_id%type default null

Line 2520: ,vacancy_id in per_all_assignments_f.vacancy_id%type default null

2516: ,organization_id in per_all_assignments_f.organization_id%type default null
2517: ,people_group in pay_people_groups.group_name%type default null
2518: ,people_group_id in per_all_assignments_f.people_group_id%type default null
2519: ,vacancy in per_vacancies.name%type default null
2520: ,vacancy_id in per_all_assignments_f.vacancy_id%type default null
2521: ,requisition in per_requisitions.name%type default null
2522: ,requisition_id in per_requisitions.requisition_id%type default null
2523: ,salary_basis in per_pay_bases.name%type default null
2524: ,pay_basis_id in per_all_assignments_f.pay_basis_id%type default null

Line 2524: ,pay_basis_id in per_all_assignments_f.pay_basis_id%type default null

2520: ,vacancy_id in per_all_assignments_f.vacancy_id%type default null
2521: ,requisition in per_requisitions.name%type default null
2522: ,requisition_id in per_requisitions.requisition_id%type default null
2523: ,salary_basis in per_pay_bases.name%type default null
2524: ,pay_basis_id in per_all_assignments_f.pay_basis_id%type default null
2525: ,bargaining_unit_code_meaning in hr_lookups.meaning%type default null
2526: ,bargaining_unit_code in per_all_assignments_f.bargaining_unit_code%type default null
2527: ,employment_category_meaning in hr_lookups.meaning%type default null
2528: ,employment_category in per_all_assignments_f.employment_category%type default null

Line 2526: ,bargaining_unit_code in per_all_assignments_f.bargaining_unit_code%type default null

2522: ,requisition_id in per_requisitions.requisition_id%type default null
2523: ,salary_basis in per_pay_bases.name%type default null
2524: ,pay_basis_id in per_all_assignments_f.pay_basis_id%type default null
2525: ,bargaining_unit_code_meaning in hr_lookups.meaning%type default null
2526: ,bargaining_unit_code in per_all_assignments_f.bargaining_unit_code%type default null
2527: ,employment_category_meaning in hr_lookups.meaning%type default null
2528: ,employment_category in per_all_assignments_f.employment_category%type default null
2529: --bug 3002915 starts here. modified the type.
2530: ,establishment in hr_leg_establishments_v.name%type default null

Line 2528: ,employment_category in per_all_assignments_f.employment_category%type default null

2524: ,pay_basis_id in per_all_assignments_f.pay_basis_id%type default null
2525: ,bargaining_unit_code_meaning in hr_lookups.meaning%type default null
2526: ,bargaining_unit_code in per_all_assignments_f.bargaining_unit_code%type default null
2527: ,employment_category_meaning in hr_lookups.meaning%type default null
2528: ,employment_category in per_all_assignments_f.employment_category%type default null
2529: --bug 3002915 starts here. modified the type.
2530: ,establishment in hr_leg_establishments_v.name%type default null
2531: ,establishment_id in hr_leg_establishments_v.organization_id%type default null
2532: --bug 3002915 ends here.