DBA Data[Home] [Help]

APPS.PJI_PMV_PROFITABILITY dependencies on PA_PROJECTS_ALL

Line 3273: , pa_projects_all prj

3269: FROM
3270: pji_project_classes PJM
3271: , pji_pmv_cls_dim_tmp PTM
3272: , pji_pmv_orgz_dim_tmp org
3273: , pa_projects_all prj
3274: WHERE
3275: pjm.project_class_id = ptm.id
3276: AND prj.project_id = pjm.project_id
3277: AND prj.carrying_out_organization_id = org.ID;

Line 3283: , pa_projects_all prj

3279: INSERT into pji_pmv_prj_dim_tmp (id, name)
3280: SELECT DISTINCT prj.project_id, '-1' name
3281: FROM
3282: pji_pmv_orgz_dim_tmp org
3283: , pa_projects_all prj
3284: WHERE
3285: prj.carrying_out_organization_id = org.ID;
3286: end if;
3287:

Line 3816: FROM PA_PROJECTS_ALL

3812: , PROJECT_TYPE
3813: INTO l_detail_tab(i).PROJECT_NAME
3814: , l_detail_tab(i).PROJECT_NUMBER
3815: , l_detail_tab(i).PROJECT_TYPE
3816: FROM PA_PROJECTS_ALL
3817: WHERE PROJECT_ID = l_detail_tab(i).PROJECT_ID;
3818:
3819:
3820: /*