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 PJI_PA_PROJ_EVENTS_LOG

Line 240: pji_pa_proj_events_log pel,

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
244: AND ppa.project_id = map.project_id

Line 302: PJI_PA_PROJ_EVENTS_LOG pel,

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
306: WHERE 1=1

Line 364: PJI_PA_PROJ_EVENTS_LOG pel,

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,
368: (

Line 986: FROM pji_pa_proj_events_log

982: , NVL(SUM(DECODE(event_type, 'RBS_PRG', 1, 0)) , 0)
983: INTO l_prg_change_exists
984: , l_rbs_assoc_exists
985: , l_rbs_prg_exists
986: FROM pji_pa_proj_events_log
987: WHERE 1=1
988: AND worker_id = g_worker_id;
989:
990:

Line 1302: pji_pa_proj_events_log ev

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
1306: den.struct_version_id IS NULL

Line 1331: , pji_pa_proj_events_log ev

1327: SELECT /*+ ordered */
1328: DISTINCT hd2.project_id, hd2.plan_version_id, hd2.plan_type_id
1329: FROM
1330: pji_pjp_proj_batch_map map
1331: , pji_pa_proj_events_log ev
1332: , pji_pjp_wbs_header hd9 -- SUP
1333: , pji_xbs_denorm den
1334: , pji_pjp_wbs_header hd2 -- SUB
1335: WHERE

Line 1362: , pji_pa_proj_events_log ev

1358: INSERT INTO pji_fm_extr_plnver3_t
1359: (project_id, plan_version_id, plan_type_id)
1360: SELECT DISTINCT hd9.project_id, hd9.plan_version_id, hd9.plan_type_id
1361: FROM pji_pjp_proj_batch_map map
1362: , pji_pa_proj_events_log ev
1363: , pji_pjp_wbs_header hd9 -- SUP
1364: WHERE
1365: map.worker_id = g_worker_id
1366: AND ev.worker_id = g_worker_id

Line 1392: , pji_pa_proj_events_log ev

1388: SELECT DISTINCT hd9.project_id, hd9.plan_version_id, hd9.plan_type_id
1389: FROM pji_xbs_denorm den
1390: , pji_pjp_wbs_header hd1 -- SUB
1391: , pji_pjp_proj_batch_map map
1392: , pji_pa_proj_events_log ev
1393: , pji_pjp_wbs_header hd9 -- SUP
1394: WHERE
1395: den.struct_version_id IS NULL
1396: AND hd1.wbs_version_id = den.sub_id -- struct_version_id

Line 1429: , pji_pa_proj_events_log ev

1425: (project_id, plan_version_id, plan_type_id)
1426: SELECT /*+ ordered */
1427: DISTINCT hd9.project_id, hd9.plan_version_id, hd9.plan_type_id
1428: FROM pji_pjp_proj_batch_map map
1429: , pji_pa_proj_events_log ev
1430: -- , PA_BUDGET_VERSIONS bv
1431: , pji_xbs_denorm den
1432: , pji_pjp_wbs_header wh1 -- sup
1433: , pji_pjp_wbs_header hd9 -- SUb!!

Line 1466: , pji_pa_proj_events_log ev

1462: SELECT DISTINCT hd9.project_id, hd9.plan_version_id, hd9.plan_type_id
1463: FROM pji_xbs_denorm den
1464: , pji_pjp_wbs_header hd2 -- SUB
1465: , pji_pjp_proj_batch_map map
1466: , pji_pa_proj_events_log ev
1467: , pji_pjp_wbs_header hd9 -- SUP
1468: WHERE
1469: den.struct_version_id IS NULL
1470: AND hd9.wbs_version_id = den.sup_id -- struct_version_id

Line 2354: , pji_pa_proj_events_log ev

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
2357: AND bv.fin_plan_type_id IS NOT NULL
2358: AND fpo.project_id = bv.project_id

Line 2414: , PJI_PA_PROJ_EVENTS_LOG ev

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
2418: ) cbcov

Line 2478: , pji_pa_proj_events_log ev

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
2482: WHERE bv.version_type IS NOT NULL

Line 2549: , PJI_PA_PROJ_EVENTS_LOG ev

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
2553: , (SELECT -3 plan_version_id FROM DUAL

Line 2669: FROM pji_pa_proj_events_log

2665: AND ver3.worker_id = g_worker_id
2666: )
2667: */
2668: AND EXISTS ( SELECT DISTINCT 1
2669: FROM pji_pa_proj_events_log
2670: WHERE event_type = 'PRG_CHANGE'
2671: AND worker_id = g_worker_id )
2672: );
2673: