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 1127: l_from_clause:=l_from_clause||',per_all_assignments_f supan';

1123: if supervisor_assignment_id is not null then
1124: l_where_clause:=l_where_clause||' and per_asg.supervisor_assignment_id='||supervisor_assignment_id;
1125: l_asg:=TRUE;
1126: elsif supervisor_assignment_number is not null then
1127: l_from_clause:=l_from_clause||',per_all_assignments_f supan';
1128: l_where_clause:=l_where_clause||' and per_asg.supervisor_assignment_id=supan.assignment_id'
1129: ||' and upper(supan.assignment_number)
1130: like ('''||upper(replace(supervisor_assignment_number,g_quote,g_quote||g_quote))||''')'
1131: ||' and '||l_effective_date||' between supan.effective_start_date and supan.effective_end_date'

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

1331:
1332: if secure='Y' then
1333: l_from_clause:=l_from_clause||',per_assignments_f2 per_asg';
1334: else
1335: l_from_clause:=l_from_clause||',per_all_assignments_f per_asg';
1336: end if;
1337: --
1338: l_where_clause:=l_where_clause||' and per.person_id=per_asg.person_id and '
1339: ||l_effective_date||

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

1432:
1433: select_stmt:=l_from_clause||l_where_clause;
1434: l_select_stmt_asg:='select per_asg.assignment_id '||l_from_clause;
1435: if not l_asg then
1436: l_select_stmt_asg:=l_select_stmt_asg||',per_all_assignments_f per_asg';
1437: end if;
1438: l_select_stmt_asg:=l_select_stmt_asg||l_where_clause;
1439: if not l_asg then
1440: l_select_stmt_asg:=l_select_stmt_asg||' and per.person_id=per_asg.person_id and '

Line 2453: ,project_title in per_all_assignments_f.project_title%type default null

2449: ,email_address in per_all_people_f.email_address%type default null
2450: ,employee_number in per_all_people_f.employee_number%type default null
2451: --CWK
2452: ,npw_number in per_all_people_f.npw_number%type default null
2453: ,project_title in per_all_assignments_f.project_title%type default null
2454: ,vendor_id in per_all_assignments_f.vendor_id%type default null
2455: ,vendor_name in po_vendors.vendor_name%type default null
2456: ,vendor_employee_number in per_all_assignments_f.vendor_employee_number%type default null
2457: ,vendor_assignment_number in per_all_assignments_f.vendor_assignment_number%type default null

Line 2454: ,vendor_id in per_all_assignments_f.vendor_id%type default null

2450: ,employee_number in per_all_people_f.employee_number%type default null
2451: --CWK
2452: ,npw_number in per_all_people_f.npw_number%type default null
2453: ,project_title in per_all_assignments_f.project_title%type default null
2454: ,vendor_id in per_all_assignments_f.vendor_id%type default null
2455: ,vendor_name in po_vendors.vendor_name%type default null
2456: ,vendor_employee_number in per_all_assignments_f.vendor_employee_number%type default null
2457: ,vendor_assignment_number in per_all_assignments_f.vendor_assignment_number%type default null
2458: ,vendor_site_code in po_vendor_sites_all.vendor_site_code%TYPE default null

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

2452: ,npw_number in per_all_people_f.npw_number%type default null
2453: ,project_title in per_all_assignments_f.project_title%type default null
2454: ,vendor_id in per_all_assignments_f.vendor_id%type default null
2455: ,vendor_name in po_vendors.vendor_name%type default null
2456: ,vendor_employee_number in per_all_assignments_f.vendor_employee_number%type default null
2457: ,vendor_assignment_number in per_all_assignments_f.vendor_assignment_number%type default null
2458: ,vendor_site_code in po_vendor_sites_all.vendor_site_code%TYPE default null
2459: ,vendor_site_id in po_vendor_sites_all.vendor_site_id%TYPE default null
2460: ,po_header_num in po_headers_all.segment1%TYPE default null

Line 2457: ,vendor_assignment_number in per_all_assignments_f.vendor_assignment_number%type default null

2453: ,project_title in per_all_assignments_f.project_title%type default null
2454: ,vendor_id in per_all_assignments_f.vendor_id%type default null
2455: ,vendor_name in po_vendors.vendor_name%type default null
2456: ,vendor_employee_number in per_all_assignments_f.vendor_employee_number%type default null
2457: ,vendor_assignment_number in per_all_assignments_f.vendor_assignment_number%type default null
2458: ,vendor_site_code in po_vendor_sites_all.vendor_site_code%TYPE default null
2459: ,vendor_site_id in po_vendor_sites_all.vendor_site_id%TYPE default null
2460: ,po_header_num in po_headers_all.segment1%TYPE default null
2461: ,po_header_id in po_headers_all.po_header_id%TYPE default null

Line 2480: ,grade_id in per_all_assignments_f.grade_id%type default null

2476: ,sex in per_all_people_f.sex%type default null
2477: ,benefit_group in ben_benfts_grp.name%type default null
2478: ,benefit_group_id in per_all_people_f.benefit_group_id%type default null
2479: ,grade in per_grades.name%type default null
2480: ,grade_id in per_all_assignments_f.grade_id%type default null
2481: ,grade_ladder in ben_pgm_f.name%type default null
2482: ,grade_ladder_pgm_id in per_all_assignments_f.grade_ladder_pgm_id%type default null
2483: ,position in hr_all_positions_f.name%type default null
2484: ,position_id in per_all_assignments_f.position_id%type default null

Line 2482: ,grade_ladder_pgm_id in per_all_assignments_f.grade_ladder_pgm_id%type default null

2478: ,benefit_group_id in per_all_people_f.benefit_group_id%type default null
2479: ,grade in per_grades.name%type default null
2480: ,grade_id in per_all_assignments_f.grade_id%type default null
2481: ,grade_ladder in ben_pgm_f.name%type default null
2482: ,grade_ladder_pgm_id in per_all_assignments_f.grade_ladder_pgm_id%type default null
2483: ,position in hr_all_positions_f.name%type default null
2484: ,position_id in per_all_assignments_f.position_id%type default null
2485: ,job in per_jobs.name%type default null
2486: ,job_id in per_all_assignments_f.job_id%type default null

Line 2484: ,position_id in per_all_assignments_f.position_id%type default null

2480: ,grade_id in per_all_assignments_f.grade_id%type default null
2481: ,grade_ladder in ben_pgm_f.name%type default null
2482: ,grade_ladder_pgm_id in per_all_assignments_f.grade_ladder_pgm_id%type default null
2483: ,position in hr_all_positions_f.name%type default null
2484: ,position_id in per_all_assignments_f.position_id%type default null
2485: ,job in per_jobs.name%type default null
2486: ,job_id in per_all_assignments_f.job_id%type default null
2487: ,assignment_status_type in per_assignment_status_types.user_status%type default null
2488: ,assignment_status_type_id in per_all_assignments_f.assignment_status_type_id%type default null

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

2482: ,grade_ladder_pgm_id in per_all_assignments_f.grade_ladder_pgm_id%type default null
2483: ,position in hr_all_positions_f.name%type default null
2484: ,position_id in per_all_assignments_f.position_id%type default null
2485: ,job in per_jobs.name%type default null
2486: ,job_id in per_all_assignments_f.job_id%type default null
2487: ,assignment_status_type in per_assignment_status_types.user_status%type default null
2488: ,assignment_status_type_id in per_all_assignments_f.assignment_status_type_id%type default null
2489: ,payroll in pay_all_payrolls_f.payroll_name%type default null
2490: ,payroll_id in per_all_assignments_f.payroll_id%type default null

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

2484: ,position_id in per_all_assignments_f.position_id%type default null
2485: ,job in per_jobs.name%type default null
2486: ,job_id in per_all_assignments_f.job_id%type default null
2487: ,assignment_status_type in per_assignment_status_types.user_status%type default null
2488: ,assignment_status_type_id in per_all_assignments_f.assignment_status_type_id%type default null
2489: ,payroll in pay_all_payrolls_f.payroll_name%type default null
2490: ,payroll_id in per_all_assignments_f.payroll_id%type default null
2491: ,location in hr_locations.location_code%type default null
2492: ,location_id in per_all_assignments_f.location_id%type default null

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

2486: ,job_id in per_all_assignments_f.job_id%type default null
2487: ,assignment_status_type in per_assignment_status_types.user_status%type default null
2488: ,assignment_status_type_id in per_all_assignments_f.assignment_status_type_id%type default null
2489: ,payroll in pay_all_payrolls_f.payroll_name%type default null
2490: ,payroll_id in per_all_assignments_f.payroll_id%type default null
2491: ,location in hr_locations.location_code%type default null
2492: ,location_id in per_all_assignments_f.location_id%type default null
2493: ,supervisor in per_all_people_f.full_name%type default null
2494: ,supervisor_id in per_all_assignments_f.supervisor_id%type default null

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

2488: ,assignment_status_type_id in per_all_assignments_f.assignment_status_type_id%type default null
2489: ,payroll in pay_all_payrolls_f.payroll_name%type default null
2490: ,payroll_id in per_all_assignments_f.payroll_id%type default null
2491: ,location in hr_locations.location_code%type default null
2492: ,location_id in per_all_assignments_f.location_id%type default null
2493: ,supervisor in per_all_people_f.full_name%type default null
2494: ,supervisor_id in per_all_assignments_f.supervisor_id%type default null
2495: ,supervisor_assignment_number in per_assignments_v.supervisor_assignment_number%type default null
2496: ,supervisor_assignment_id in per_all_assignments_f.supervisor_assignment_id%type default null

Line 2494: ,supervisor_id in per_all_assignments_f.supervisor_id%type default null

2490: ,payroll_id in per_all_assignments_f.payroll_id%type default null
2491: ,location in hr_locations.location_code%type default null
2492: ,location_id in per_all_assignments_f.location_id%type default null
2493: ,supervisor in per_all_people_f.full_name%type default null
2494: ,supervisor_id in per_all_assignments_f.supervisor_id%type default null
2495: ,supervisor_assignment_number in per_assignments_v.supervisor_assignment_number%type default null
2496: ,supervisor_assignment_id in per_all_assignments_f.supervisor_assignment_id%type default null
2497: ,recruitment_activity in per_recruitment_activities.name%type default null
2498: ,recruitment_activity_id in per_all_assignments_f.recruitment_activity_id%type default null

Line 2496: ,supervisor_assignment_id in per_all_assignments_f.supervisor_assignment_id%type default null

2492: ,location_id in per_all_assignments_f.location_id%type default null
2493: ,supervisor in per_all_people_f.full_name%type default null
2494: ,supervisor_id in per_all_assignments_f.supervisor_id%type default null
2495: ,supervisor_assignment_number in per_assignments_v.supervisor_assignment_number%type default null
2496: ,supervisor_assignment_id in per_all_assignments_f.supervisor_assignment_id%type default null
2497: ,recruitment_activity in per_recruitment_activities.name%type default null
2498: ,recruitment_activity_id in per_all_assignments_f.recruitment_activity_id%type default null
2499: ,organization in hr_all_organization_units.name%type default null
2500: ,organization_id in per_all_assignments_f.organization_id%type default null

Line 2498: ,recruitment_activity_id in per_all_assignments_f.recruitment_activity_id%type default null

2494: ,supervisor_id in per_all_assignments_f.supervisor_id%type default null
2495: ,supervisor_assignment_number in per_assignments_v.supervisor_assignment_number%type default null
2496: ,supervisor_assignment_id in per_all_assignments_f.supervisor_assignment_id%type default null
2497: ,recruitment_activity in per_recruitment_activities.name%type default null
2498: ,recruitment_activity_id in per_all_assignments_f.recruitment_activity_id%type default null
2499: ,organization in hr_all_organization_units.name%type default null
2500: ,organization_id in per_all_assignments_f.organization_id%type default null
2501: ,people_group in pay_people_groups.group_name%type default null
2502: ,people_group_id in per_all_assignments_f.people_group_id%type default null

Line 2500: ,organization_id in per_all_assignments_f.organization_id%type default null

2496: ,supervisor_assignment_id in per_all_assignments_f.supervisor_assignment_id%type default null
2497: ,recruitment_activity in per_recruitment_activities.name%type default null
2498: ,recruitment_activity_id in per_all_assignments_f.recruitment_activity_id%type default null
2499: ,organization in hr_all_organization_units.name%type default null
2500: ,organization_id in per_all_assignments_f.organization_id%type default null
2501: ,people_group in pay_people_groups.group_name%type default null
2502: ,people_group_id in per_all_assignments_f.people_group_id%type default null
2503: ,vacancy in per_vacancies.name%type default null
2504: ,vacancy_id in per_all_assignments_f.vacancy_id%type default null

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

2498: ,recruitment_activity_id in per_all_assignments_f.recruitment_activity_id%type default null
2499: ,organization in hr_all_organization_units.name%type default null
2500: ,organization_id in per_all_assignments_f.organization_id%type default null
2501: ,people_group in pay_people_groups.group_name%type default null
2502: ,people_group_id in per_all_assignments_f.people_group_id%type default null
2503: ,vacancy in per_vacancies.name%type default null
2504: ,vacancy_id in per_all_assignments_f.vacancy_id%type default null
2505: ,requisition in per_requisitions.name%type default null
2506: ,requisition_id in per_requisitions.requisition_id%type default null

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

2500: ,organization_id in per_all_assignments_f.organization_id%type default null
2501: ,people_group in pay_people_groups.group_name%type default null
2502: ,people_group_id in per_all_assignments_f.people_group_id%type default null
2503: ,vacancy in per_vacancies.name%type default null
2504: ,vacancy_id in per_all_assignments_f.vacancy_id%type default null
2505: ,requisition in per_requisitions.name%type default null
2506: ,requisition_id in per_requisitions.requisition_id%type default null
2507: ,salary_basis in per_pay_bases.name%type default null
2508: ,pay_basis_id in per_all_assignments_f.pay_basis_id%type default null

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

2504: ,vacancy_id in per_all_assignments_f.vacancy_id%type default null
2505: ,requisition in per_requisitions.name%type default null
2506: ,requisition_id in per_requisitions.requisition_id%type default null
2507: ,salary_basis in per_pay_bases.name%type default null
2508: ,pay_basis_id in per_all_assignments_f.pay_basis_id%type default null
2509: ,bargaining_unit_code_meaning in hr_lookups.meaning%type default null
2510: ,bargaining_unit_code in per_all_assignments_f.bargaining_unit_code%type default null
2511: ,employment_category_meaning in hr_lookups.meaning%type default null
2512: ,employment_category in per_all_assignments_f.employment_category%type default null

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

2506: ,requisition_id in per_requisitions.requisition_id%type default null
2507: ,salary_basis in per_pay_bases.name%type default null
2508: ,pay_basis_id in per_all_assignments_f.pay_basis_id%type default null
2509: ,bargaining_unit_code_meaning in hr_lookups.meaning%type default null
2510: ,bargaining_unit_code in per_all_assignments_f.bargaining_unit_code%type default null
2511: ,employment_category_meaning in hr_lookups.meaning%type default null
2512: ,employment_category in per_all_assignments_f.employment_category%type default null
2513: --bug 3002915 starts here. modified the type.
2514: ,establishment in hr_leg_establishments_v.name%type default null

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

2508: ,pay_basis_id in per_all_assignments_f.pay_basis_id%type default null
2509: ,bargaining_unit_code_meaning in hr_lookups.meaning%type default null
2510: ,bargaining_unit_code in per_all_assignments_f.bargaining_unit_code%type default null
2511: ,employment_category_meaning in hr_lookups.meaning%type default null
2512: ,employment_category in per_all_assignments_f.employment_category%type default null
2513: --bug 3002915 starts here. modified the type.
2514: ,establishment in hr_leg_establishments_v.name%type default null
2515: ,establishment_id in hr_leg_establishments_v.organization_id%type default null
2516: --bug 3002915 ends here.