eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PJI_FM_PLAN_MAINT_PVT dependencies on PA_PROJ_FP_OPTIONS

Line 239: pa_proj_fp_options fpo,

235: FROM
236: pji_pjp_proj_batch_map map,
237: pji_pjp_rbs_header rhd,
238: pa_budget_versions bv,
239: pa_proj_fp_options fpo,
240: pji_pa_proj_events_log pel,
241: pa_projects_all ppa,
242: pa_rbs_versions_b rvb --Added for bug#5728852
243: WHERE 1=1

Line 301: PA_PROJ_FP_OPTIONS fpo,

297: FROM
298: PJI_PJP_PROJ_BATCH_MAP map,
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

Line 363: PA_PROJ_FP_OPTIONS fpo,

359: FROM
360: PJI_PJP_PROJ_BATCH_MAP map,
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,

Line 501: , pa_proj_fp_options fpo

497: FROM
498: pji_pjp_proj_batch_map map
499: , pa_projects_all ppa
500: , pa_budget_versions bv
501: , pa_proj_fp_options fpo
502: WHERE 1=1
503: AND ppa.project_id = bv.project_id
504: AND bv.version_type is not NULL -- COST, REVENUE, etc. Should not be null.
505: AND bv.fin_plan_type_id is not NULL -- Old budgets model data is not picked up with this condition.

Line 585: , pa_proj_fp_options fpo -- @pjdev115 fpo

581: FROM
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.

Line 697: PA_PROJ_FP_OPTIONS fpo

693: PA_PROJECTS_ALL ppa,
694: PA_BUDGET_VERSIONS pbv,
695: pji_pjp_wbs_header head,
696: PA_PROJ_ELEM_VER_STRUCTURE ppevs,
697: PA_PROJ_FP_OPTIONS fpo
698: WHERE
699: -- map.PROJECT_ACTIVE_FLAG = 'Y' AND
700: map.PROJECT_ID = head.PROJECT_ID AND
701: head.WP_FLAG = 'Y' AND

Line 1727: , pa_proj_fp_options fpo -- @pjdev115 fpo

1723: , 'N'
1724: ) lp_flag
1725: FROM
1726: pa_budget_versions bv -- @pjdev115 bv
1727: , pa_proj_fp_options fpo -- @pjdev115 fpo
1728: , pa_projects_all ppa -- @pjdev115 ppa
1729: WHERE 1=1
1730: AND ppa.project_id = bv.project_id
1731: AND bv.version_type is not NULL -- COST, REVENUE, etc. Should not be null.

Line 1915: , pa_proj_fp_options fpo -- @pjdev115 fpo

1911: , 'N'
1912: ) lp_flag
1913: FROM
1914: pa_budget_versions bv -- @pjdev115 bv
1915: , pa_proj_fp_options fpo -- @pjdev115 fpo
1916: , pa_projects_all ppa -- @pjdev115 ppa
1917: WHERE 1=1
1918: AND ppa.project_id = bv.project_id
1919: AND bv.version_type is not NULL -- COST, REVENUE, etc. Should not be null.

Line 1992: , pa_proj_fp_options fpo -- @pjdev115 fpo

1988: , 'N'
1989: ) lp_flag
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

Line 2076: , pa_proj_fp_options fpo -- @pjdev115 fpo

2072: , 'N'
2073: ) lp_flag
2074: FROM
2075: pa_budget_versions bv -- @pjdev115 bv
2076: , pa_proj_fp_options fpo -- @pjdev115 fpo
2077: , pa_projects_all ppa -- @pjdev115 ppa
2078: , pji_pjp_proj_batch_map map
2079: WHERE 1=1
2080: AND ppa.project_id = bv.project_id

Line 2131: , pa_proj_fp_options fpo

2127: , 'N'
2128: ) lp_flag
2129: FROM
2130: pa_budget_versions bv
2131: , pa_proj_fp_options fpo
2132: , pji_pjp_proj_batch_map map
2133: , ( SELECT -3 plan_version_id FROM dual
2134: UNION ALL
2135: SELECT -4 plan_version_id FROM dual ) cbco

Line 2230: , pa_proj_fp_options fpo -- @pjdev115 fpo

2226: , 'N'
2227: ) lp_flag
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

Line 2287: , pa_proj_fp_options fpo -- @pjdev115 fpo

2283: , 'N'
2284: ) lp_flag
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

Line 2350: , pa_proj_fp_options fpo -- @pjdev115 fpo

2346: , 'N'
2347: ) lp_flag
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

Line 2413: , pa_proj_fp_options fpo

2409: , 'N'
2410: ) lp_flag
2411: FROM
2412: pa_budget_versions bv
2413: , pa_proj_fp_options fpo
2414: , PJI_PA_PROJ_EVENTS_LOG ev
2415: , (SELECT -3 plan_version_id FROM DUAL
2416: UNION ALL
2417: SELECT -4 plan_version_id FROM DUAL

Line 2477: , pa_proj_fp_options fpo

2473: , 'N'
2474: ) lp_flag
2475: FROM
2476: pa_budget_versions bv
2477: , pa_proj_fp_options fpo
2478: , pji_pa_proj_events_log ev
2479: , pji_pjp_wbs_header hd1 -- sup
2480: , pji_pjp_wbs_header hd2 -- sub
2481: , pji_xbs_denorm den

Line 2548: , pa_proj_fp_options fpo

2544: , 'N'
2545: ) lp_flag
2546: FROM
2547: pa_budget_versions bv
2548: , pa_proj_fp_options fpo
2549: , PJI_PA_PROJ_EVENTS_LOG ev
2550: , pji_pjp_wbs_header hd1 -- sup
2551: , pji_pjp_wbs_header hd2 -- sub
2552: , pji_xbs_denorm den

Line 2625: FROM pa_proj_fp_options fpo

2621: , fpo.fin_plan_version_id fpopvi
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

Line 2896: , pa_proj_fp_options fpo -- @pjdev115 fpo

2892: , 'N'
2893: ) lp_flag
2894: FROM
2895: pa_budget_versions bv -- @pjdev115 bv
2896: , pa_proj_fp_options fpo -- @pjdev115 fpo
2897: , pa_projects_all ppa -- @pjdev115 ppa
2898: WHERE 1=1
2899: AND ppa.project_id = bv.project_id
2900: AND bv.version_type is not NULL -- COST, REVENUE, etc. Should not be null.

Line 2975: , pa_proj_fp_options fpo -- @pjdev115 fpo

2971: , 'N'
2972: ) lp_flag
2973: FROM
2974: pa_budget_versions bv -- @pjdev115 bv
2975: , pa_proj_fp_options fpo -- @pjdev115 fpo
2976: , pa_projects_all ppa -- @pjdev115 ppa
2977: WHERE 1=1
2978: AND ppa.project_id = bv.project_id
2979: AND bv.version_type is not NULL -- COST, REVENUE, etc. Should not be null.

Line 3056: , pa_proj_fp_options fpo -- @pjdev115 fpo

3052: , 'N'
3053: ) lp_flag
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

Line 4743: , pa_proj_fp_options fpo -- @pjdev115 fpo

4739: , rl.PLAN_TYPE_CODE
4740: FROM
4741: pji_fp_xbs_accum_f rl
4742: , pa_budget_versions bv -- @pjdev115 bv
4743: , pa_proj_fp_options fpo -- @pjdev115 fpo
4744: WHERE
4745: rl.project_id = bv.project_id
4746: AND bv.version_type IS NOT NULL
4747: AND bv.fin_plan_type_id IS NOT NULL

Line 4823: , pa_proj_fp_options fpo

4819: , bv.current_original_flag current_original_flag
4820: , DECODE(bv.baselined_date, NULL, 'N', 'Y') baselined_flag
4821: FROM PJI_FM_EXTR_PLAN_LINES epl
4822: , pa_budget_versions bv
4823: , pa_proj_fp_options fpo
4824: WHERE
4825: epl.plan_version_id = bv.budget_version_id
4826: AND fpo.project_id = bv.project_id
4827: AND bv.fin_plan_type_id = fpo.fin_plan_type_id