1317: CURSOR get_project_info IS
1318: SELECT proj.name,
1319: proj.segment1,
1320: hou.name,
1321: PA_PROJECT_PARTIES_UTILS.GET_PROJECT_MANAGER(proj.project_id),
1322: PA_PROJECT_PARTIES_UTILS.GET_PROJECT_MANAGER_NAME,
1323: PA_PROJECTS_MAINT_UTILS.GET_PRIMARY_CUSTOMER_NAME(proj.project_id)
1324: FROM pa_projects_all proj,
1325: HR_ALL_ORGANIZATION_UNITS HOU
1318: SELECT proj.name,
1319: proj.segment1,
1320: hou.name,
1321: PA_PROJECT_PARTIES_UTILS.GET_PROJECT_MANAGER(proj.project_id),
1322: PA_PROJECT_PARTIES_UTILS.GET_PROJECT_MANAGER_NAME,
1323: PA_PROJECTS_MAINT_UTILS.GET_PRIMARY_CUSTOMER_NAME(proj.project_id)
1324: FROM pa_projects_all proj,
1325: HR_ALL_ORGANIZATION_UNITS HOU
1326: WHERE proj.project_id = p_project_id