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_T_PVT dependencies on PA_PROJECTS_ALL

Line 881: , pa_projects_all ppa -- @pjdev115 ppa

877: , 'N' SECONDARY_RBS_FLAG
878: FROM
879: pa_budget_versions bv -- @pjdev115 bv
880: , pa_proj_fp_options fpo -- @pjdev115 fpo
881: , pa_projects_all ppa -- @pjdev115 ppa
882: WHERE 1=1
883: AND ppa.project_id = bv.project_id
884: AND bv.version_type is not NULL -- COST, REVENUE, etc. Should not be null.
885: AND bv.fin_plan_type_id is not NULL -- Old budgets model data is not picked up with this condition.

Line 943: , pa_projects_all ppa -- @pjdev115 ppa

939: , 'N' SECONDARY_RBS_FLAG
940: FROM
941: pa_budget_versions bv -- @pjdev115 bv
942: , pa_proj_fp_options fpo -- @pjdev115 fpo -- is there a work plan options table?
943: , pa_projects_all ppa -- @pjdev115 ppa
944: WHERE 1=1
945: AND ppa.project_id = bv.project_id
946: AND bv.version_type is not NULL -- COST, REVENUE, etc. Should not be null.
947: AND bv.fin_plan_type_id is not NULL -- Old budgets model data is not picked up with this condition.

Line 1009: , pa_projects_all ppa -- @pjdev115 ppa

1005: , 'Y' SECONDARY_RBS_FLAG
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.

Line 1117: , pa_projects_all ppa -- @pjdev115 ppa

1113: , 'N' SECONDARY_RBS_FLAG
1114: FROM
1115: pa_budget_versions bv -- @pjdev115 bv
1116: , pa_proj_fp_options fpo -- @pjdev115 fpo
1117: , pa_projects_all ppa -- @pjdev115 ppa
1118: WHERE 1=1
1119: AND ppa.project_id = bv.project_id
1120: AND bv.version_type is not NULL -- COST, REVENUE, etc. Should not be null.
1121: AND bv.fin_plan_type_id is not NULL -- Old budgets model data is not picked up with this condition.

Line 1184: , pa_projects_all ppa -- @pjdev115 ppa

1180: , 'N' SECONDARY_RBS_FLAG
1181: FROM
1182: pa_budget_versions bv -- @pjdev115 bv
1183: , pa_proj_fp_options fpo -- @pjdev115 fpo
1184: , pa_projects_all ppa -- @pjdev115 ppa
1185: WHERE 1=1
1186: AND ppa.project_id = bv.project_id
1187: AND bv.version_type is not NULL -- COST, REVENUE, etc. Should not be null.
1188: AND bv.fin_plan_type_id is not NULL -- Old budgets model data is not picked up with this condition.

Line 1255: , pa_projects_all ppa -- @pjdev115 ppa

1251: , 'Y' SECONDARY_RBS_FLAG
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.

Line 1786: , pa_projects_all ppa

1782: FROM
1783: PA_BUDGET_LINES bl
1784: , pa_resource_asSIGNments ra
1785: , PJI_FM_EXTR_PLNVER3_T ver
1786: , pa_projects_all ppa
1787: , PA_PROJ_ELEM_VER_STRUCTURE pevs
1788: WHERE
1789: ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
1790: AND ra.project_id = ver.PROJECT_ID

Line 2542: , pa_projects_all ppa

2538: FROM
2539: PA_BUDGET_LINES bl
2540: , pa_resource_asSIGNments ra
2541: , PJI_FM_EXTR_PLNVER3_T ver
2542: , pa_projects_all ppa
2543: , PA_PROJ_ELEM_VER_STRUCTURE pevs
2544: , PJI_FM_AGGR_DLY_RATES_T rates
2545: , pji_time_cal_period_v prd
2546: , PJI_ORG_EXTR_INFO oei

Line 2845: , pa_projects_all ppa

2841: FROM
2842: PA_BUDGET_LINES bl
2843: , pa_resource_asSIGNments ra
2844: , PJI_FM_EXTR_PLNVER3_T ver
2845: , pa_projects_all ppa
2846: , PA_PROJ_ELEM_VER_STRUCTURE pevs
2847: , PJI_FM_AGGR_DLY_RATES_T rates
2848: -- , pji_time_cal_period prd
2849: -- , PJI_ORG_EXTR_INFO oei

Line 3586: , pa_projects_all ppa

3582: FROM
3583: PA_BUDGET_LINES bl
3584: , pa_resource_asSIGNments ra
3585: , PJI_FM_EXTR_PLNVER3_T ver
3586: , pa_projects_all ppa
3587: , PA_PROJ_ELEM_VER_STRUCTURE pevs
3588: , PJI_FM_AGGR_DLY_RATES_T rates
3589: , pji_time_cal_period_v prd
3590: , PJI_ORG_EXTR_INFO oei

Line 3875: , pa_projects_all ppa

3871: FROM
3872: PA_BUDGET_LINES bl
3873: , pa_resource_asSIGNments ra
3874: , PJI_FM_EXTR_PLNVER3_T ver
3875: , pa_projects_all ppa
3876: , PA_PROJ_ELEM_VER_STRUCTURE pevs
3877: , PJI_FM_AGGR_DLY_RATES_T rates
3878: WHERE 1=1
3879: AND ra.resource_asSIGNment_id = bl.resource_asSIGNment_id

Line 4852: , pa_projects_all ppa

4848: , ver.plan_type_code plan_type_code /* 4471527 */
4849: FROM
4850: PJI_FM_EXTR_PLAN_LINES bl
4851: , PJI_FM_EXTR_PLNVER3_T ver
4852: , pa_projects_all ppa
4853: , PA_PROJ_ELEM_VER_STRUCTURE pevs
4854: , pji_fp_rmap_fpr_update_t rwid
4855: WHERE 1=1
4856: AND bl.project_id = ver.project_id

Line 5118: , pa_projects_all ppa

5114: FROM pa_budget_lines bl
5115: , pa_budget_versions bv -- added for bug 5842896
5116: , pji_time_cal_period_v prd
5117: , PJI_FM_EXTR_PLNVER3_T ver
5118: , pa_projects_all ppa
5119: ,PJI_ORG_EXTR_INFO inf
5120: WHERE bl.budget_version_id = ver.plan_version_id
5121: AND bl.budget_version_id = bv.budget_version_id -- added for bug 5842896
5122: AND bv.project_id = ppa.project_id -- added for bug 5842896

Line 5158: , pa_projects_all ppa

5154: , l_gl1_mau mau1
5155: , l_gl2_mau mau2
5156: FROM pa_resource_assignments ra
5157: , PJI_FM_EXTR_PLNVER3_T ver
5158: , pa_projects_all ppa
5159: WHERE ra.budget_version_id = ver.plan_version_id
5160: AND ver.wp_flag = 'N'
5161: AND ver.baselined_flag = 'Y'
5162: AND ver.time_phased_type_code = 'N'

Line 5785: , pa_projects_all ppa

5781: , null TIME_DANGLING_FLAG
5782: -- , 0 prg_level
5783: , fact.plan_type_code plan_type_code -- 4471527
5784: FROM pji_fp_aggr_pjp1_t fact
5785: , pa_projects_all ppa
5786: , ( SELECT g_global1_currency_code curr_code, 0.01 mau FROM DUAL
5787: UNION
5788: SELECT g_global2_currency_code curr_code, 0.01 mau FROM DUAL
5789: ) curr

Line 5897: , pa_projects_all ppa

5893: , null TIME_DANGLING_FLAG
5894: -- , 0 prg_level
5895: , fact.plan_type_code plan_type_code -- 4471527
5896: FROM pji_fp_xbs_accum_f fact
5897: , pa_projects_all ppa
5898: , ( SELECT g_global1_currency_code curr_code, 0.01 mau FROM DUAL
5899: UNION
5900: SELECT g_global2_currency_code curr_code, 0.01 mau FROM DUAL
5901: ) curr

Line 6630: l_struct_sharing_code pa_projects_all.structure_sharing_code%TYPE;

6626: p_new_pub_version_id IN NUMBER
6627: , p_prev_pub_version_id IN NUMBER := NULL ) IS
6628:
6629: l_project_id NUMBER;
6630: l_struct_sharing_code pa_projects_all.structure_sharing_code%TYPE;
6631: l_prev_pub_version_id NUMBER;
6632: l_curr_wking_version_id NUMBER;
6633: l_actual_plan_version_id NUMBER;
6634: l_copied_from_version_id NUMBER;

Line 6663: FROM pa_projects_all

6659: WHERE budget_version_id = p_new_pub_version_id ;
6660:
6661: SELECT structure_sharing_code
6662: INTO l_struct_sharing_code
6663: FROM pa_projects_all
6664: WHERE project_id = l_project_id;
6665:
6666: l_prev_pub_version_id := p_prev_pub_version_id;
6667:

Line 7073: , PA_PROJECTS_ALL ppa

7069: , ver.plan_type_code plan_type_code /* 4471527 */
7070: FROM
7071: PJI_FM_EXTR_PLAN_LINES bl
7072: , PJI_FM_EXTR_PLNVER3_T ver
7073: , PA_PROJECTS_ALL ppa
7074: , PA_PROJ_ELEM_VER_STRUCTURE pevs
7075: , pji_fp_rmap_fpr_update_t rwid
7076: WHERE 1=1
7077: AND bl.project_id = ver.project_id

Line 7139: , PA_PROJECTS_ALL ppa

7135: FROM
7136: PA_BUDGET_LINES bl
7137: , PA_RESOURCE_ASSIGNMENTS ra
7138: , PJI_FM_EXTR_PLNVER3_T ver
7139: , PA_PROJECTS_ALL ppa
7140: , PA_PROJ_ELEM_VER_STRUCTURE pevs
7141: WHERE
7142: ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
7143: AND ra.project_id = ver.PROJECT_ID

Line 9581: , pa_projects_all proj

9577: , imp.pa_period_type -- pa
9578: ) period_type
9579: FROM pa_implementations_all imp
9580: , gl_sets_of_books sob
9581: , pa_projects_all proj
9582: , pji_fm_extr_plnver3_t ver
9583: , ( SELECT 1 cal_type FROM DUAL -- 1 GL, 2 PA.
9584: UNION ALL
9585: SELECT 2 FROM DUAL