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 337: pji_pa_proj_events_log pel,

333: pji_pjp_proj_batch_map map,
334: pji_pjp_rbs_header rhd,
335: pa_budget_versions bv,
336: pa_proj_fp_options fpo,
337: pji_pa_proj_events_log pel,
338: pa_projects_all ppa,
339: pa_rbs_versions_b rvb --Added for bug#5728852
340: WHERE 1=1
341: AND ppa.project_id = map.project_id

Line 399: PJI_PA_PROJ_EVENTS_LOG pel,

395: PJI_PJP_PROJ_BATCH_MAP map,
396: PJI_PJP_RBS_HEADER rhd,
397: PA_BUDGET_VERSIONS bv,
398: PA_PROJ_FP_OPTIONS fpo,
399: PJI_PA_PROJ_EVENTS_LOG pel,
400: PA_RBS_PRJ_ASSIGNMENTS rpa,
401: PA_PROJECTS_ALL ppa,
402: PA_RBS_VERSIONS_B rvb --Added for bug#5728852
403: WHERE 1=1

Line 461: PJI_PA_PROJ_EVENTS_LOG pel,

457: PJI_PJP_PROJ_BATCH_MAP map,
458: PJI_PJP_RBS_HEADER rhd,
459: PA_BUDGET_VERSIONS bv,
460: PA_PROJ_FP_OPTIONS fpo,
461: PJI_PA_PROJ_EVENTS_LOG pel,
462: PA_RBS_PRJ_ASSIGNMENTS rpa,
463: PA_PROJECTS_ALL ppa,
464: PA_RBS_VERSIONS_B rvb,
465: (

Line 1083: FROM pji_pa_proj_events_log

1079: , NVL(SUM(DECODE(event_type, 'RBS_PRG', 1, 0)) , 0)
1080: INTO l_prg_change_exists
1081: , l_rbs_assoc_exists
1082: , l_rbs_prg_exists
1083: FROM pji_pa_proj_events_log
1084: WHERE 1=1
1085: AND worker_id = g_worker_id;
1086:
1087: BEGIN

Line 1400: pji_pa_proj_events_log ev

1396: (project_id, plan_version_id, plan_type_id)
1397: SELECT DISTINCT hd9.project_id, hd9.plan_version_id, hd9.plan_type_id
1398: FROM -- pji_pjp_wbs_header hd2
1399: -- pa_proj_elem_ver_structure hd2
1400: pji_pa_proj_events_log ev
1401: , Pa_XBS_DENORM den
1402: , pji_pjp_wbs_header hd9 -- SUP
1403: WHERE
1404: den.struct_version_id IS NULL

Line 1429: , pji_pa_proj_events_log ev

1425: SELECT /*+ ordered */
1426: DISTINCT hd2.project_id, hd2.plan_version_id, hd2.plan_type_id
1427: FROM
1428: pji_pjp_proj_batch_map map
1429: , pji_pa_proj_events_log ev
1430: , pji_pjp_wbs_header hd9 -- SUP
1431: , pji_xbs_denorm den
1432: , pji_pjp_wbs_header hd2 -- SUB
1433: WHERE

Line 1461: , pji_pa_proj_events_log ev

1457: (project_id, plan_version_id, plan_type_id)
1458: SELECT /*+ LEADING(MAP) */ /* leading hint added for bug 9337307 */
1459: DISTINCT hd9.project_id, hd9.plan_version_id, hd9.plan_type_id
1460: FROM pji_pjp_proj_batch_map map
1461: , pji_pa_proj_events_log ev
1462: , pji_pjp_wbs_header hd9 -- SUP
1463: WHERE
1464: map.worker_id = g_worker_id
1465: AND ev.worker_id = g_worker_id

Line 1491: , pji_pa_proj_events_log ev

1487: SELECT DISTINCT hd9.project_id, hd9.plan_version_id, hd9.plan_type_id
1488: FROM pji_xbs_denorm den
1489: , pji_pjp_wbs_header hd1 -- SUB
1490: , pji_pjp_proj_batch_map map
1491: , pji_pa_proj_events_log ev
1492: , pji_pjp_wbs_header hd9 -- SUP
1493: WHERE
1494: den.struct_version_id IS NULL
1495: AND hd1.wbs_version_id = den.sub_id -- struct_version_id

Line 1528: , pji_pa_proj_events_log ev

1524: (project_id, plan_version_id, plan_type_id)
1525: SELECT /*+ ordered */
1526: DISTINCT hd9.project_id, hd9.plan_version_id, hd9.plan_type_id
1527: FROM pji_pjp_proj_batch_map map
1528: , pji_pa_proj_events_log ev
1529: -- , PA_BUDGET_VERSIONS bv
1530: , pji_xbs_denorm den
1531: , pji_pjp_wbs_header wh1 -- sup
1532: , pji_pjp_wbs_header hd9 -- SUb!!

Line 1565: , pji_pa_proj_events_log ev

1561: SELECT DISTINCT hd9.project_id, hd9.plan_version_id, hd9.plan_type_id
1562: FROM pji_xbs_denorm den
1563: , pji_pjp_wbs_header hd2 -- SUB
1564: , pji_pjp_proj_batch_map map
1565: , pji_pa_proj_events_log ev
1566: , pji_pjp_wbs_header hd9 -- SUP
1567: WHERE
1568: den.struct_version_id IS NULL
1569: AND hd9.wbs_version_id = den.sup_id -- struct_version_id

Line 1756: from pji_pa_proj_events_log

1752: into l_RBS_ASSOC_exists
1753: from dual
1754: where exists
1755: ( select 'x'
1756: from pji_pa_proj_events_log
1757: where worker_id = g_worker_id
1758: and event_type = 'RBS_ASSOC'
1759: );
1760:

Line 1777: from pji_pa_proj_events_log

1773: into l_RBS_PRG_exists
1774: from dual
1775: where exists
1776: ( select 'x'
1777: from pji_pa_proj_events_log
1778: where worker_id = g_worker_id
1779: and event_type = 'RBS_PRG'
1780: );
1781:

Line 1797: from pji_pa_proj_events_log

1793: into l_PRG_CHANGE_exists
1794: from dual
1795: where exists
1796: ( select 'x'
1797: from pji_pa_proj_events_log
1798: where worker_id = g_worker_id
1799: and event_type = 'PRG_CHANGE'
1800: );
1801:

Line 2882: , pji_pa_proj_events_log ev

2878: , 'N'
2879: ) lp_flag
2880: FROM
2881: pji_pjp_proj_batch_map map
2882: , pji_pa_proj_events_log ev
2883: , pa_budget_versions bv -- @pjdev115 bv
2884: , pa_proj_fp_options fpo -- @pjdev115 fpo
2885: -- , pa_projects_all ppa -- @pjdev115 ppa
2886: , PA_RBS_PRJ_ASSIGNMENTS rpa

Line 2942: pji_pa_proj_events_log ev

2938: , 'N')
2939: , 'N'
2940: ) lp_flag
2941: FROM
2942: pji_pa_proj_events_log ev
2943: , PA_RBS_PRJ_ASSIGNMENTS rpa
2944: , pa_budget_versions bv -- @pjdev115 bv
2945: , pa_proj_fp_options fpo -- @pjdev115 fpo
2946: , pa_projects_all ppa -- @pjdev115 ppa

Line 3006: PJI_PA_PROJ_EVENTS_LOG ev

3002: , 'N')
3003: , 'N'
3004: ) lp_flag
3005: FROM
3006: PJI_PA_PROJ_EVENTS_LOG ev
3007: , pa_budget_versions bv
3008: , pa_proj_fp_options fpo
3009: , (SELECT -3 plan_version_id FROM DUAL
3010: UNION ALL

Line 3070: pji_pa_proj_events_log ev

3066: , 'N')
3067: , 'N'
3068: ) lp_flag
3069: FROM
3070: pji_pa_proj_events_log ev
3071: , pji_pjp_wbs_header hd1 -- sup
3072: , pji_xbs_denorm den
3073: , pji_pjp_wbs_header hd2 -- sub
3074: , pa_budget_versions bv

Line 3142: PJI_PA_PROJ_EVENTS_LOG ev

3138: , 'N')
3139: , 'N'
3140: ) lp_flag
3141: FROM
3142: PJI_PA_PROJ_EVENTS_LOG ev
3143: , pji_pjp_wbs_header hd1 -- sup
3144: , pji_xbs_denorm den
3145: , pji_pjp_wbs_header hd2 -- sub
3146: , pa_budget_versions bv

Line 3262: FROM pji_pa_proj_events_log

3258: AND den.struct_type = 'PRG'
3259: AND den.sup_level < den.sub_level
3260: AND NVL(den.relationship_type, 'WF') IN ('LF', 'WF') -- Excluding 'LW'
3261: AND EXISTS ( SELECT DISTINCT 1
3262: FROM pji_pa_proj_events_log
3263: WHERE event_type = 'PRG_CHANGE'
3264: AND worker_id = g_worker_id )
3265: )
3266: -- Added for Bug# 8838371 ends

Line 3465: pji_pa_proj_events_log ev

3461: , 'N')
3462: , 'N'
3463: ) lp_flag
3464: FROM
3465: pji_pa_proj_events_log ev
3466: , PA_RBS_PRJ_ASSIGNMENTS rpa
3467: , pa_budget_versions bv -- @pjdev115 bv
3468: , pa_proj_fp_options fpo -- @pjdev115 fpo
3469: , pa_projects_all ppa -- @pjdev115 ppa

Line 3529: PJI_PA_PROJ_EVENTS_LOG ev

3525: , 'N')
3526: , 'N'
3527: ) lp_flag
3528: FROM
3529: PJI_PA_PROJ_EVENTS_LOG ev
3530: , pa_budget_versions bv
3531: , pa_proj_fp_options fpo
3532: , (SELECT -3 plan_version_id FROM DUAL
3533: UNION ALL

Line 3593: pji_pa_proj_events_log ev

3589: , 'N')
3590: , 'N'
3591: ) lp_flag
3592: FROM
3593: pji_pa_proj_events_log ev
3594: , pji_pjp_wbs_header hd1 -- sup
3595: , pji_xbs_denorm den
3596: , pji_pjp_wbs_header hd2 -- sub
3597: , pa_budget_versions bv

Line 3665: PJI_PA_PROJ_EVENTS_LOG ev

3661: , 'N')
3662: , 'N'
3663: ) lp_flag
3664: FROM
3665: PJI_PA_PROJ_EVENTS_LOG ev
3666: , pji_pjp_wbs_header hd1 -- sup
3667: , pji_xbs_denorm den
3668: , pji_pjp_wbs_header hd2 -- sub
3669: , pa_budget_versions bv

Line 3785: FROM pji_pa_proj_events_log

3781: AND den.struct_type = 'PRG'
3782: AND den.sup_level < den.sub_level
3783: AND NVL(den.relationship_type, 'WF') IN ('LF', 'WF') -- Excluding 'LW'
3784: AND EXISTS ( SELECT DISTINCT 1
3785: FROM pji_pa_proj_events_log
3786: WHERE event_type = 'PRG_CHANGE'
3787: AND worker_id = g_worker_id )
3788: )
3789: -- Added for Bug# 8838371 ends