DBA Data[Home] [Help]

APPS.PA_PROJECT_STRUCTURE_PVT1 dependencies on HR_ALL_ORGANIZATION_UNITS

Line 12285: hr_all_organization_units hou,

12281: CURSOR get_project_info(c_project_id NUMBER) IS
12282: select ppa.name name, ppa.segment1,
12283: hou.name carrying_out_org_name, ppl.full_name
12284: from pa_projects_all ppa,
12285: hr_all_organization_units hou,
12286: per_all_people_f ppl,
12287: pa_project_parties ppp
12288: where ppa.carrying_out_organization_id = hou.organization_id
12289: and ppa.project_id = ppp.project_id (+)