DBA Data[Home] [Help]

APPS.PJI_PMV_CAPITAL_COST dependencies on PA_PROJECTS_ALL

Line 3434: , pa_projects_all prj

3430: FROM
3431: pji_project_classes PJM
3432: , pji_pmv_cls_dim_tmp PTM
3433: , pji_pmv_orgz_dim_tmp org
3434: , pa_projects_all prj
3435: WHERE
3436: pjm.project_class_id = ptm.id
3437: AND prj.project_id = pjm.project_id
3438: AND prj.carrying_out_organization_id = org.ID;

Line 3456: , pa_projects_all prj

3452: FROM pji_project_classes
3453: WHERE class_category = '$PROJECT_TYPE$CAPITAL') PJC
3454: , pji_pmv_cls_dim_tmp PTM
3455: , pji_pmv_orgz_dim_tmp org
3456: , pa_projects_all prj
3457: WHERE 1=1
3458: AND pjm.project_class_id = ptm.id
3459: AND prj.project_id = pjc.project_id
3460: AND prj.project_id = pjm.project_id

Line 3469: , pa_projects_all prj

3465: SELECT DISTINCT prj.project_id, '-1' name
3466: FROM
3467: pji_project_classes PJM
3468: , pji_pmv_orgz_dim_tmp org
3469: , pa_projects_all prj
3470: WHERE
3471: prj.project_id = pjm.project_id
3472: AND prj.carrying_out_organization_id = org.ID
3473: AND pjm.class_category = '$PROJECT_TYPE$CAPITAL';

Line 3940: FROM PA_PROJECTS_ALL

3936: , PROJECT_TYPE
3937: INTO l_detail_tab(i).PROJECT_NAME
3938: , l_detail_tab(i).PROJECT_NUMBER
3939: , l_detail_tab(i).PROJECT_TYPE
3940: FROM PA_PROJECTS_ALL
3941: WHERE PROJECT_ID = l_detail_tab(i).PROJECT_ID;
3942:
3943:
3944: /*