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 883: , pa_projects_all ppa -- @pjdev115 ppa

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

Line 945: , pa_projects_all ppa -- @pjdev115 ppa

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

Line 1011: , pa_projects_all ppa -- @pjdev115 ppa

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

Line 1119: , pa_projects_all ppa -- @pjdev115 ppa

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

Line 1186: , pa_projects_all ppa -- @pjdev115 ppa

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

Line 1257: , pa_projects_all ppa -- @pjdev115 ppa

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

Line 1828: , pa_projects_all ppa

1824: FROM
1825: PA_BUDGET_LINES bl
1826: , pa_resource_asSIGNments ra
1827: , PJI_FM_EXTR_PLNVER3_T ver
1828: , pa_projects_all ppa
1829: , PA_PROJ_ELEM_VER_STRUCTURE pevs
1830: WHERE
1831: ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
1832: AND ra.project_id = ver.PROJECT_ID

Line 2609: , pa_projects_all ppa

2605: FROM
2606: PA_BUDGET_LINES bl
2607: , pa_resource_asSIGNments ra
2608: , PJI_FM_EXTR_PLNVER3_T ver
2609: , pa_projects_all ppa
2610: , PA_PROJ_ELEM_VER_STRUCTURE pevs
2611: , PJI_FM_AGGR_DLY_RATES_T rates
2612: , pji_time_cal_period_v prd
2613: , PJI_ORG_EXTR_INFO oei

Line 2915: , pa_projects_all ppa

2911: FROM
2912: PA_BUDGET_LINES bl
2913: , pa_resource_asSIGNments ra
2914: , PJI_FM_EXTR_PLNVER3_T ver
2915: , pa_projects_all ppa
2916: , PA_PROJ_ELEM_VER_STRUCTURE pevs
2917: , PJI_FM_AGGR_DLY_RATES_T rates
2918: -- , pji_time_cal_period prd
2919: -- , PJI_ORG_EXTR_INFO oei

Line 3670: , pa_projects_all ppa

3666: FROM
3667: PA_BUDGET_LINES bl
3668: , pa_resource_asSIGNments ra
3669: , PJI_FM_EXTR_PLNVER3_T ver
3670: , pa_projects_all ppa
3671: , PA_PROJ_ELEM_VER_STRUCTURE pevs
3672: , PJI_FM_AGGR_DLY_RATES_T rates
3673: , pji_time_cal_period_v prd
3674: , PJI_ORG_EXTR_INFO oei

Line 3962: , pa_projects_all ppa

3958: FROM
3959: PA_BUDGET_LINES bl
3960: , pa_resource_asSIGNments ra
3961: , PJI_FM_EXTR_PLNVER3_T ver
3962: , pa_projects_all ppa
3963: , PA_PROJ_ELEM_VER_STRUCTURE pevs
3964: , PJI_FM_AGGR_DLY_RATES_T rates
3965: WHERE 1=1
3966: AND ra.resource_asSIGNment_id = bl.resource_asSIGNment_id

Line 4951: , pa_projects_all ppa

4947: , ver.plan_type_code plan_type_code /* 4471527 */
4948: FROM
4949: PJI_FM_EXTR_PLAN_LINES bl
4950: , PJI_FM_EXTR_PLNVER3_T ver
4951: , pa_projects_all ppa
4952: , PA_PROJ_ELEM_VER_STRUCTURE pevs
4953: , pji_fp_rmap_fpr_update_t rwid
4954: WHERE 1=1
4955: AND bl.project_id = ver.project_id

Line 5218: , pa_projects_all ppa

5214: FROM pa_budget_lines bl
5215: , pa_budget_versions bv -- added for bug 5842896
5216: , pji_time_cal_period_v prd
5217: , PJI_FM_EXTR_PLNVER3_T ver
5218: , pa_projects_all ppa
5219: ,PJI_ORG_EXTR_INFO inf
5220: WHERE bl.budget_version_id = ver.plan_version_id
5221: AND bl.budget_version_id = bv.budget_version_id -- added for bug 5842896
5222: AND bv.project_id = ppa.project_id -- added for bug 5842896

Line 5259: , pa_projects_all ppa

5255: , l_gl1_mau mau1
5256: , l_gl2_mau mau2
5257: FROM pa_resource_assignments ra
5258: , PJI_FM_EXTR_PLNVER3_T ver
5259: , pa_projects_all ppa
5260: WHERE ra.budget_version_id = ver.plan_version_id
5261: AND ver.wp_flag = 'N'
5262: AND ver.baselined_flag = 'Y'
5263: AND ver.time_phased_type_code = 'N'

Line 5886: , pa_projects_all ppa

5882: , null TIME_DANGLING_FLAG
5883: -- , 0 prg_level
5884: , fact.plan_type_code plan_type_code -- 4471527
5885: FROM pji_fp_aggr_pjp1_t fact
5886: , pa_projects_all ppa
5887: , ( SELECT g_global1_currency_code curr_code, 0.01 mau FROM DUAL
5888: UNION
5889: SELECT g_global2_currency_code curr_code, 0.01 mau FROM DUAL
5890: ) curr

Line 5998: , pa_projects_all ppa

5994: , null TIME_DANGLING_FLAG
5995: -- , 0 prg_level
5996: , fact.plan_type_code plan_type_code -- 4471527
5997: FROM pji_fp_xbs_accum_f fact
5998: , pa_projects_all ppa
5999: , ( SELECT g_global1_currency_code curr_code, 0.01 mau FROM DUAL
6000: UNION
6001: SELECT g_global2_currency_code curr_code, 0.01 mau FROM DUAL
6002: ) curr

Line 6753: l_struct_sharing_code pa_projects_all.structure_sharing_code%TYPE;

6749: p_new_pub_version_id IN NUMBER
6750: , p_prev_pub_version_id IN NUMBER := NULL ) IS
6751:
6752: l_project_id NUMBER;
6753: l_struct_sharing_code pa_projects_all.structure_sharing_code%TYPE;
6754: l_prev_pub_version_id NUMBER;
6755: l_curr_wking_version_id NUMBER;
6756: l_actual_plan_version_id NUMBER;
6757: l_copied_from_version_id NUMBER;

Line 6786: FROM pa_projects_all

6782: WHERE budget_version_id = p_new_pub_version_id ;
6783:
6784: SELECT structure_sharing_code
6785: INTO l_struct_sharing_code
6786: FROM pa_projects_all
6787: WHERE project_id = l_project_id;
6788:
6789: l_prev_pub_version_id := p_prev_pub_version_id;
6790:

Line 7202: , PA_PROJECTS_ALL ppa

7198: , ver.plan_type_code plan_type_code /* 4471527 */
7199: FROM
7200: PJI_FM_EXTR_PLAN_LINES bl
7201: , PJI_FM_EXTR_PLNVER3_T ver
7202: , PA_PROJECTS_ALL ppa
7203: , PA_PROJ_ELEM_VER_STRUCTURE pevs
7204: , pji_fp_rmap_fpr_update_t rwid
7205: WHERE 1=1
7206: AND bl.project_id = ver.project_id

Line 7272: , PA_PROJECTS_ALL ppa

7268: FROM
7269: PA_BUDGET_LINES bl
7270: , PA_RESOURCE_ASSIGNMENTS ra
7271: , PJI_FM_EXTR_PLNVER3_T ver
7272: , PA_PROJECTS_ALL ppa
7273: , PA_PROJ_ELEM_VER_STRUCTURE pevs
7274: WHERE
7275: ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
7276: AND ra.project_id = ver.PROJECT_ID

Line 9736: , pa_projects_all proj

9732: , imp.pa_period_type -- pa
9733: ) period_type
9734: FROM pa_implementations_all imp
9735: , gl_sets_of_books sob
9736: , pa_projects_all proj
9737: , pji_fm_extr_plnver3_t ver
9738: , ( SELECT 1 cal_type FROM DUAL -- 1 GL, 2 PA.
9739: UNION ALL
9740: SELECT 2 FROM DUAL