DBA Data[Home] [Help]

APPS.PJI_FM_PLAN_MAINT_T_PVT dependencies on PA_RBS_PRJ_ASSIGNMENTS

Line 1010: , PA_RBS_PRJ_ASSIGNMENTS rpa

1006: FROM
1007: pa_budget_versions bv -- @pjdev115 bv
1008: , pa_proj_fp_options fpo -- @pjdev115 fpo -- is there a work plan options table?
1009: , pa_projects_all ppa -- @pjdev115 ppa
1010: , PA_RBS_PRJ_ASSIGNMENTS rpa
1011: WHERE 1=1
1012: AND ppa.project_id = bv.project_id
1013: AND bv.version_type is not NULL -- COST, REVENUE, etc. Should not be null.
1014: AND bv.fin_plan_type_id is not NULL -- Old budgets model data is not picked up with this condition.

Line 1256: , PA_RBS_PRJ_ASSIGNMENTS rpa

1252: FROM
1253: pa_budget_versions bv -- @pjdev115 bv
1254: , pa_proj_fp_options fpo -- @pjdev115 fpo
1255: , pa_projects_all ppa -- @pjdev115 ppa
1256: , PA_RBS_PRJ_ASSIGNMENTS rpa
1257: WHERE 1=1
1258: AND ppa.project_id = bv.project_id
1259: AND bv.version_type is not NULL -- COST, REVENUE, etc. Should not be null.
1260: AND bv.fin_plan_type_id is not NULL -- Old budgets model data is not picked up with this condition.

Line 8962: FROM pa_rbs_prj_assignments rpa

8958: , l_creation_date
8959: , l_created_by
8960: , l_last_update_login
8961: , bv.plan_type_code /*4471527 */
8962: FROM pa_rbs_prj_assignments rpa
8963: , PJI_FM_EXTR_PLNVER3_T bv
8964: , pji_pjp_rbs_header head
8965: WHERE bv.project_id = rpa.project_id
8966: AND bv.RBS_STRUCT_VERSION_ID = rpa.RBS_VERSION_ID