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.PA_ASGMT_WFSTD dependencies on HR_ALL_ORGANIZATION_UNITS

Line 145: hr_all_organization_units hou,

141: hou.name resource_organization_name,
142: assign.supervisor_id manager_id
143: FROM per_all_people_f per,
144: per_all_assignments_f assign,
145: hr_all_organization_units hou,
146: pa_resource_txn_attributes rta
147: WHERE rta.resource_id = l_resource_id
148: AND rta.person_id = per.person_id
149: AND rta.person_id = assign.person_id

Line 167: hr_all_organization_units hr,

163: pap.location_id,
164: hr.name organization_name,
165: NVL(pt.administrative_flag,'N') admin_flag
166: FROM pa_projects_all pap,
167: hr_all_organization_units hr,
168: pa_project_types_all pt
169: WHERE pap.project_id = l_project_id
170: AND pap.carrying_out_organization_id =
171: hr.organization_id

Line 4884: hr_all_organization_units hr

4880: CURSOR l_resource_csr (l_resource_id IN NUMBER, l_start_date IN DATE) IS
4881: SELECT res.resource_name,
4882: hr.name
4883: FROM pa_resources_denorm res,
4884: hr_all_organization_units hr
4885: WHERE res.resource_id = l_resource_id
4886: AND hr.organization_id = res.resource_organization_id
4887: AND l_start_date between resource_effective_start_date and resource_effective_end_date;
4888: */

Line 4895: hr_all_organization_units hou,

4891: SELECT per.full_name resource_name,
4892: hou.name
4893: FROM per_people_f per,
4894: per_assignments_f assign,
4895: hr_all_organization_units hou,
4896: pa_resource_txn_attributes rta
4897: WHERE rta.resource_id = l_resource_id
4898: AND rta.person_id = per.person_id
4899: AND rta.person_id = assign.person_id

Line 5535: hr_all_organization_units hr

5531: ppa.work_type_name,
5532: hr.name
5533: FROM pa_project_assignments_v ppa,
5534: pa_resources_denorm res,
5535: hr_all_organization_units hr
5536: WHERE ppa.assignment_id = l_assignment_id
5537: AND res.resource_id = ppa.resource_id
5538: AND ppa.start_date BETWEEN res.resource_effective_start_date
5539: AND res.resource_effective_end_date

Line 6964: hr_all_organization_units hr,

6960: pap.location_id,
6961: hr.name organization_name,
6962: NVL(pt.administrative_flag,'N') admin_flag
6963: FROM pa_projects_all pap,
6964: hr_all_organization_units hr,
6965: pa_project_types_all pt
6966: WHERE pap.project_id = l_project_id
6967: AND pap.carrying_out_organization_id = hr.organization_id
6968: AND pap.org_id = pt.org_id -- Added for Bug 5389093

Line 7339: hr_all_organization_units hr

7335: ppa.work_type_name,
7336: hr.name
7337: FROM pa_project_assignments_v ppa,
7338: pa_resources_denorm res,
7339: hr_all_organization_units hr
7340: WHERE assignment_id = l_assignment_id
7341: AND res.resource_id = ppa.resource_id
7342: AND ppa.start_date BETWEEN res.resource_effective_start_date
7343: AND res.resource_effective_end_date