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 HR_LOCATIONS

Line 65: ,location hr_locations.location_code%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
69: ,supervisor_assignment_number per_assignments_v.supervisor_assignment_number%type default null

Line 277: from hr_locations

273: --
274: cursor csr_location
275: (p_location_id number) is
276: select location_code
277: from hr_locations
278: where location_id=p_location_id;
279: --
280: cursor csr_rec_activity
281: (p_recruitment_activity_id number) is

Line 681: ,'hr_locations loc_a','loc_a.location_id','loc_a.location_code');

677: ,'hr_all_organization_units org_a','org_a.organization_id','org_a.name');
678: l_asg:=TRUE;
679: elsif p_field_name='LOCATION' then
680: l_a_where_clause:=build_varchar2_where('per_asg.location_id',p_condition,p_value
681: ,'hr_locations loc_a','loc_a.location_id','loc_a.location_code');
682: l_asg:=TRUE;
683: elsif p_field_name='PAYROLL' then
684: l_a_where_clause:=build_varchar2_where('per_asg.payroll_id',p_condition,p_value
685: ,'pay_all_payrolls pay_a','pay_a.payroll_id','pay_a.payroll_name');

Line 1121: l_from_clause:=l_from_clause||',hr_locations loc';

1117: if location_id is not null then
1118: l_where_clause:=l_where_clause||' and per_asg.location_id='||location_id;
1119: l_asg:=TRUE;
1120: elsif location is not null then
1121: l_from_clause:=l_from_clause||',hr_locations loc';
1122: l_where_clause:=l_where_clause||' and per_asg.location_id=loc.location_id'
1123: ||' and upper(loc.location_code) like ('''||upper(replace(location,g_quote,g_quote||g_quote))||''')';
1124: l_asg:=TRUE;
1125: end if;

Line 2507: ,location in hr_locations.location_code%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
2511: ,supervisor_assignment_number in per_assignments_v.supervisor_assignment_number%type default null