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_people_f per,
144: per_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 4868: hr_all_organization_units hr

4864: CURSOR l_resource_csr (l_resource_id IN NUMBER, l_start_date IN DATE) IS
4865: SELECT res.resource_name,
4866: hr.name
4867: FROM pa_resources_denorm res,
4868: hr_all_organization_units hr
4869: WHERE res.resource_id = l_resource_id
4870: AND hr.organization_id = res.resource_organization_id
4871: AND l_start_date between resource_effective_start_date and resource_effective_end_date;
4872: */

Line 4879: hr_all_organization_units hou,

4875: SELECT per.full_name resource_name,
4876: hou.name
4877: FROM per_people_f per,
4878: per_assignments_f assign,
4879: hr_all_organization_units hou,
4880: pa_resource_txn_attributes rta
4881: WHERE rta.resource_id = l_resource_id
4882: AND rta.person_id = per.person_id
4883: AND rta.person_id = assign.person_id

Line 5519: hr_all_organization_units hr

5515: ppa.work_type_name,
5516: hr.name
5517: FROM pa_project_assignments_v ppa,
5518: pa_resources_denorm res,
5519: hr_all_organization_units hr
5520: WHERE ppa.assignment_id = l_assignment_id
5521: AND res.resource_id = ppa.resource_id
5522: AND ppa.start_date BETWEEN res.resource_effective_start_date
5523: AND res.resource_effective_end_date

Line 6948: hr_all_organization_units hr,

6944: pap.location_id,
6945: hr.name organization_name,
6946: NVL(pt.administrative_flag,'N') admin_flag
6947: FROM pa_projects_all pap,
6948: hr_all_organization_units hr,
6949: pa_project_types_all pt
6950: WHERE pap.project_id = l_project_id
6951: AND pap.carrying_out_organization_id = hr.organization_id
6952: AND pap.org_id = pt.org_id -- Added for Bug 5389093

Line 7323: hr_all_organization_units hr

7319: ppa.work_type_name,
7320: hr.name
7321: FROM pa_project_assignments_v ppa,
7322: pa_resources_denorm res,
7323: hr_all_organization_units hr
7324: WHERE assignment_id = l_assignment_id
7325: AND res.resource_id = ppa.resource_id
7326: AND ppa.start_date BETWEEN res.resource_effective_start_date
7327: AND res.resource_effective_end_date