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_ALL_ORGANIZATION_UNITS

Line 73: ,organization hr_all_organization_units.name%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
77: ,vacancy per_vacancies.name%type default null

Line 677: ,'hr_all_organization_units org_a','org_a.organization_id','org_a.name');

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');
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');

Line 1151: l_from_clause:=l_from_clause||',hr_all_organization_units_tl houtl,hr_all_organization_units hou';

1147: if organization_id is not null then
1148: l_where_clause:=l_where_clause||' and per_asg.organization_id='||organization_id;
1149: l_asg:=TRUE;
1150: elsif organization is not null then
1151: l_from_clause:=l_from_clause||',hr_all_organization_units_tl houtl,hr_all_organization_units hou';
1152: l_where_clause:=l_where_clause||' and per_asg.organization_id=hou.organization_id'
1153: ||' and hou.organization_id=houtl.organization_id'
1154: ||' and upper(houtl.name) like ('''||upper(replace(organization,g_quote,g_quote||g_quote))||''')'
1155: ||' and hou.internal_external_flag=''INT'''

Line 2499: ,organization in hr_all_organization_units.name%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
2503: ,vacancy in per_vacancies.name%type default null