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_ELEM_VER_STRUCTURE

Line 533: EXISTS ( select 1 from PA_PROJ_ELEM_VER_STRUCTURE ppevs where

529: fpo.FIN_PLAN_TYPE_ID <> l_workplan_type_id and
530: DECODE(BITAND(l_refresh_code,g_all_plans),g_all_plans,'N',DECODE(BITAND(l_refresh_code,g_wk_plans),g_wk_plans,'Y','N'))='Y'
531: )
532: OR --Pull Reversals for Work plan Working Versions / LPub Vers / Baselined Versions when l_refresh_code=2,8,16,30. ignore if l_refresh_code>=62
533: EXISTS ( select 1 from PA_PROJ_ELEM_VER_STRUCTURE ppevs where
534: bv.FIN_PLAN_TYPE_ID =l_workplan_type_id and
535: bv.PROJECT_STRUCTURE_VERSION_ID = ppevs.ELEMENT_VERSION_ID and
536: (
537: decode(BITAND(l_refresh_code,g_all_plans),g_all_plans,'N',

Line 696: PA_PROJ_ELEM_VER_STRUCTURE ppevs,

692: pji_pjp_proj_batch_map map,
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

Line 1221: , PA_PROJ_ELEM_VER_STRUCTURE ppevs1

1217: , pji_fm_extr_plan_lines epl
1218: , pji_pjp_wbs_header hd2 -- SUB
1219: , pji_xbs_denorm den
1220: , pji_pjp_wbs_header hd9 -- SUP
1221: , PA_PROJ_ELEM_VER_STRUCTURE ppevs1
1222: , PA_PROJ_ELEM_VER_STRUCTURE ppevs2
1223: WHERE
1224: den.struct_version_id IS NULL
1225: AND hd2.plan_type_id = hd9.plan_type_id

Line 1222: , PA_PROJ_ELEM_VER_STRUCTURE ppevs2

1218: , pji_pjp_wbs_header hd2 -- SUB
1219: , pji_xbs_denorm den
1220: , pji_pjp_wbs_header hd9 -- SUP
1221: , PA_PROJ_ELEM_VER_STRUCTURE ppevs1
1222: , PA_PROJ_ELEM_VER_STRUCTURE ppevs2
1223: WHERE
1224: den.struct_version_id IS NULL
1225: AND hd2.plan_type_id = hd9.plan_type_id
1226: AND hd2.wbs_version_id = den.sub_id -- struct_version_id

Line 1301: -- pa_proj_elem_ver_structure hd2

1297: INSERT INTO pji_fm_extr_plnver3_t
1298: (project_id, plan_version_id, plan_type_id)
1299: SELECT DISTINCT hd9.project_id, hd9.plan_version_id, hd9.plan_type_id
1300: FROM -- pji_pjp_wbs_header hd2
1301: -- pa_proj_elem_ver_structure hd2
1302: pji_pa_proj_events_log ev
1303: , Pa_XBS_DENORM den
1304: , pji_pjp_wbs_header hd9 -- SUP
1305: WHERE

Line 3515: , PA_PROJ_ELEM_VER_STRUCTURE pevs

3511: PJI_FM_EXTR_PLNVER4 ver
3512: , pa_resource_asSIGNments ra
3513: , PA_BUDGET_LINES bl
3514: , pa_projects_all ppa
3515: , PA_PROJ_ELEM_VER_STRUCTURE pevs
3516: WHERE
3517: ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
3518: AND ra.project_id = ver.PROJECT_ID
3519: AND ra.budget_version_id = ver.plan_version_id

Line 4099: , PA_PROJ_ELEM_VER_STRUCTURE pevs

4095: PJI_FM_EXTR_PLNVER4 ver
4096: , PA_RESOURCE_ASSIGNMENTS ra
4097: , PA_BUDGET_LINES bl
4098: , PA_PROJECTS_ALL ppa
4099: , PA_PROJ_ELEM_VER_STRUCTURE pevs
4100: WHERE
4101: ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
4102: AND (
4103: (

Line 4171: , PA_PROJ_ELEM_VER_STRUCTURE pevs

4167: FROM
4168: PJI_FM_EXTR_PLNVER4 ver
4169: , PJI_FM_EXTR_PLAN_LINES bl
4170: , PA_PROJECTS_ALL ppa
4171: , PA_PROJ_ELEM_VER_STRUCTURE pevs
4172: WHERE 1=1
4173: AND ver.wp_flag = 'Y'
4174: AND bl.project_id = ver.project_id
4175: AND bl.plan_version_id = ver.plan_version_id

Line 8335: , PA_PROJ_ELEM_VER_STRUCTURE pevs

8331: , pji_time_cal_period_v prd
8332: , PJI_FM_AGGR_DLY_RATES rates
8333: , pji_fp_txn_accum_header hdr
8334: , pa_rbs_txn_accum_map map
8335: , PA_PROJ_ELEM_VER_STRUCTURE pevs
8336: WHERE 1=1
8337: AND ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
8338: AND ra.project_id = ver.PROJECT_ID
8339: AND ra.budget_version_id = ver.plan_version_id

Line 8642: , PA_PROJ_ELEM_VER_STRUCTURE pevs

8638: , pji_pjp_rbs_header rhdr
8639: , PJI_FM_AGGR_DLY_RATES rates
8640: , pji_fp_txn_accum_header hdr
8641: , pa_rbs_txn_accum_map map
8642: , PA_PROJ_ELEM_VER_STRUCTURE pevs
8643: WHERE 1=1
8644: AND ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
8645: AND ra.project_id = ver.PROJECT_ID
8646: AND ra.budget_version_id = ver.plan_version_id

Line 9496: , PA_PROJ_ELEM_VER_STRUCTURE pevs

9492: , pa_projects_all ppa
9493: , PJI_ORG_EXTR_INFO oei
9494: , pji_time_cal_period_v prd
9495: , PJI_FM_AGGR_DLY_RATES rates
9496: , PA_PROJ_ELEM_VER_STRUCTURE pevs
9497: WHERE 1=1
9498: AND ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
9499: AND ra.project_id = ver.PROJECT_ID
9500: AND ra.budget_version_id = ver.plan_version_id

Line 9785: , PA_PROJ_ELEM_VER_STRUCTURE pevs

9781: , pa_resource_asSIGNments ra
9782: , PA_BUDGET_LINES bl
9783: , pa_projects_all ppa
9784: , PJI_FM_AGGR_DLY_RATES rates
9785: , PA_PROJ_ELEM_VER_STRUCTURE pevs
9786: WHERE 1=1
9787: AND ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
9788: AND ra.project_id = ver.PROJECT_ID
9789: AND ra.budget_version_id = ver.plan_version_id

Line 10456: , PA_PROJ_ELEM_VER_STRUCTURE pevs

10452: PJI_FM_EXTR_PLNVER4 ver
10453: , PA_RESOURCE_ASSIGNMENTS ra
10454: , PA_BUDGET_LINES bl
10455: , PA_PROJECTS_ALL ppa
10456: , PA_PROJ_ELEM_VER_STRUCTURE pevs
10457: WHERE
10458: ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
10459: AND ra.project_id = ver.PROJECT_ID
10460: AND ra.budget_version_id = ver.plan_version_id

Line 11033: , PA_PROJ_ELEM_VER_STRUCTURE pevs

11029: FROM
11030: PJI_FM_EXTR_PLNVER4 ver
11031: , PJI_FM_EXTR_PLAN_LINES bl
11032: , PA_PROJECTS_ALL ppa
11033: , PA_PROJ_ELEM_VER_STRUCTURE pevs
11034: WHERE 1=1
11035: AND ver.wp_flag = 'Y'
11036: AND bl.project_id = ver.project_id
11037: AND bl.plan_version_id = ver.plan_version_id