DBA Data[Home] [Help]

APPS.PJI_FM_PLAN_MAINT_T_PVT dependencies on PA_RBS_PRJ_ASSIGNMENTS

Line 1012: , PA_RBS_PRJ_ASSIGNMENTS rpa

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

Line 1258: , PA_RBS_PRJ_ASSIGNMENTS rpa

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

Line 9110: FROM pa_rbs_prj_assignments rpa

9106: , l_creation_date
9107: , l_created_by
9108: , l_last_update_login
9109: , bv.plan_type_code /*4471527 */
9110: FROM pa_rbs_prj_assignments rpa
9111: , PJI_FM_EXTR_PLNVER3_T bv
9112: , pji_pjp_rbs_header head
9113: WHERE bv.project_id = rpa.project_id
9114: AND bv.RBS_STRUCT_VERSION_ID = rpa.RBS_VERSION_ID