DBA Data[Home] [Help]

APPS.PA_PROJECT_STRUCTURE_PVT1 dependencies on HR_ALL_ORGANIZATION_UNITS

Line 12657: hr_all_organization_units hou,

12653: CURSOR get_project_info(c_project_id NUMBER) IS
12654: select ppa.name name, ppa.segment1,
12655: hou.name carrying_out_org_name, ppl.full_name
12656: from pa_projects_all ppa,
12657: hr_all_organization_units hou,
12658: per_all_people_f ppl,
12659: pa_project_parties ppp
12660: where ppa.carrying_out_organization_id = hou.organization_id
12661: and ppa.project_id = ppp.project_id (+)