DBA Data[Home] [Help]

APPS.PA_CANDIDATE_PUB dependencies on HR_ALL_ORGANIZATION_UNITS

Line 2030: hr_all_organization_units hou

2026: res.resource_id,
2027: hou.name resource_organization_name,
2028: res.manager_id
2029: FROM pa_resources_denorm res,
2030: hr_all_organization_units hou
2031: WHERE res.resource_id = l_resource_id
2032: AND hou.organization_id = res.resource_organization_id
2033: AND p_start_date BETWEEN resource_effective_start_date
2034: AND resource_effective_end_date

Line 2046: hr_all_organization_units hr,

2042: pap.location_id,
2043: hr.name organization_name,
2044: NVL(pt.administrative_flag,'N') admin_flag
2045: FROM pa_projects_all pap,
2046: hr_all_organization_units hr,
2047: pa_project_types_all pt
2048: WHERE pap.project_id = l_project_id
2049: AND pap.carrying_out_organization_id =
2050: hr.organization_id