DBA Data[Home] [Help]

APPS.PA_PROGRESS_REPORT_WORKFLOW dependencies on HR_ALL_ORGANIZATION_UNITS

Line 2490: /* Changed the query to base tables pa_projects_all and hr_all_organization_units instead of view

2486: IS
2487:
2488: CURSOR get_project_info(l_project_id number) IS
2489: SELECT
2490: /* Changed the query to base tables pa_projects_all and hr_all_organization_units instead of view
2491: pa_project_lists_v to improve performance. Bug :4940945 */
2492: ppa.name,
2493: PA_PROJECTS_MAINT_UTILS.GET_PRIMARY_CUSTOMER_NAME(PPA.PROJECT_ID) customer_name,
2494: --project_type,

Line 2505: FROM pa_projects_all ppa, hr_all_organization_units hou

2501: --completion_date,
2502: hou.name carrying_out_organization_name
2503: --project_status_name,
2504: --description
2505: FROM pa_projects_all ppa, hr_all_organization_units hou
2506: WHERE ppa.project_id = l_project_id
2507: and ppa.CARRYING_OUT_ORGANIZATION_ID = hou.ORGANIZATION_ID
2508: and rownum = 1;
2509: /* changes end for bug 4940945 */