APPS.PJI_FM_PLAN_MAINT_PVT dependencies on PA_RBS_PRJ_ASSIGNMENTS

Line 303: PA_RBS_PRJ_ASSIGNMENTS rpa,

299: PJI_PJP_RBS_HEADER rhd,
300: PA_BUDGET_VERSIONS bv,
301: PA_PROJ_FP_OPTIONS fpo,
302: PJI_PA_PROJ_EVENTS_LOG pel,
303: PA_RBS_PRJ_ASSIGNMENTS rpa,
304: PA_PROJECTS_ALL ppa,
305: PA_RBS_VERSIONS_B rvb --Added for bug#5728852
306: WHERE 1=1
307: AND ppa.project_id = map.project_id

Line 365: PA_RBS_PRJ_ASSIGNMENTS rpa,

361: PJI_PJP_RBS_HEADER rhd,
362: PA_BUDGET_VERSIONS bv,
363: PA_PROJ_FP_OPTIONS fpo,
364: PJI_PA_PROJ_EVENTS_LOG pel,
365: PA_RBS_PRJ_ASSIGNMENTS rpa,
366: PA_PROJECTS_ALL ppa,
367: PA_RBS_VERSIONS_B rvb,
368: (
369: SELECT -3 pvi FROM dual UNION ALL

Line 586: , PA_RBS_PRJ_ASSIGNMENTS rpa

582: pji_pjp_proj_batch_map map
583: , pa_projects_all ppa -- @pjdev115 ppa
584: , pa_budget_versions bv -- @pjdev115 bv
585: , pa_proj_fp_options fpo -- @pjdev115 fpo
586: , PA_RBS_PRJ_ASSIGNMENTS rpa
587: WHERE 1=1
588: AND ppa.project_id = bv.project_id
589: AND bv.version_type is not NULL -- COST, REVENUE, etc. Should not be null.
590: AND bv.fin_plan_type_id is not NULL -- Old budgets model data is not picked up with this condition.

Line 1994: , PA_RBS_PRJ_ASSIGNMENTS rpa

1990: FROM
1991: pa_budget_versions bv -- @pjdev115 bv
1992: , pa_proj_fp_options fpo -- @pjdev115 fpo
1993: , pa_projects_all ppa -- @pjdev115 ppa
1994: , PA_RBS_PRJ_ASSIGNMENTS rpa
1995: WHERE 1=1
1996: AND ppa.project_id = bv.project_id
1997: AND bv.version_type is not NULL -- COST, REVENUE, etc. Should not be null.
1998: AND bv.fin_plan_type_id is not NULL -- Old budgets model data is not picked up with this condition.

Line 2232: , PA_RBS_PRJ_ASSIGNMENTS rpa

2228: FROM
2229: pa_budget_versions bv -- @pjdev115 bv
2230: , pa_proj_fp_options fpo -- @pjdev115 fpo
2231: , pa_projects_all ppa -- @pjdev115 ppa
2232: , PA_RBS_PRJ_ASSIGNMENTS rpa
2233: , pji_pjp_proj_batch_map map
2234: WHERE ppa.project_id = bv.project_id
2235: AND bv.version_type IS NOT NULL
2236: AND bv.fin_plan_type_id IS NOT NULL

Line 2289: , PA_RBS_PRJ_ASSIGNMENTS rpa

2285: FROM
2286: pa_budget_versions bv -- @pjdev115 bv
2287: , pa_proj_fp_options fpo -- @pjdev115 fpo
2288: -- , pa_projects_all ppa -- @pjdev115 ppa
2289: , PA_RBS_PRJ_ASSIGNMENTS rpa
2290: , pji_pjp_proj_batch_map map
2291: , ( SELECT -3 plan_version_id FROM dual
2292: UNION ALL
2293: SELECT -4 plan_version_id FROM dual ) cbco

Line 2352: , PA_RBS_PRJ_ASSIGNMENTS rpa

2348: FROM
2349: pa_budget_versions bv -- @pjdev115 bv
2350: , pa_proj_fp_options fpo -- @pjdev115 fpo
2351: , pa_projects_all ppa -- @pjdev115 ppa
2352: , PA_RBS_PRJ_ASSIGNMENTS rpa
2353: , pji_pjp_proj_batch_map map
2354: , pji_pa_proj_events_log ev
2355: WHERE ppa.project_id = bv.project_id
2356: AND bv.version_type IS NOT NULL

Line 2626: , pa_rbs_prj_assignments rpa

2622: , bv.budget_version_id bvpvi
2623: , NVL(bv.wp_version_flag, 'N') wpf
2624: , bv.budget_status_code bsc
2625: FROM pa_proj_fp_options fpo
2626: , pa_rbs_prj_assignments rpa
2627: , pa_budget_versions bv
2628: , PJI_PJP_PROJ_BATCH_MAP map
2629: WHERE 1=1
2630: AND fpo.project_id (+)= rpa.project_id

Line 3058: , PA_RBS_PRJ_ASSIGNMENTS rpa

3054: FROM
3055: pa_budget_versions bv -- @pjdev115 bv
3056: , pa_proj_fp_options fpo -- @pjdev115 fpo
3057: , pa_projects_all ppa -- @pjdev115 ppa
3058: , PA_RBS_PRJ_ASSIGNMENTS rpa
3059: WHERE 1=1
3060: AND ppa.project_id = bv.project_id
3061: AND bv.version_type is not NULL -- COST, REVENUE, etc. Should not be null.
3062: AND bv.fin_plan_type_id is not NULL -- Old budgets model data is not picked up with this condition.

Line 7218: PA_RBS_PRJ_ASSIGNMENTS rpa,

7214: , l_last_update_login
7215: , bv.plan_type_code
7216: FROM
7217: PJI_FM_EXTR_PLNVER4 bv,
7218: PA_RBS_PRJ_ASSIGNMENTS rpa,
7219: PJI_PJP_RBS_HEADER head
7220: WHERE bv.project_id = rpa.project_id
7221: AND bv.worker_id = g_worker_id
7222: AND bv.RBS_STRUCT_VERSION_ID = rpa.RBS_VERSION_ID