APPS.PJI_FM_SUM_ROLLUP_ACT dependencies on PJI_PJI_PROJ_BATCH_MAP

Line 29: PJI_PJI_PROJ_BATCH_MAP map,

25: select
26: p_worker_id WORKER_ID,
27: act5.ROWID STG_ROWID
28: from
29: PJI_PJI_PROJ_BATCH_MAP map,
30: PJI_FM_AGGR_ACT5 act5
31: where
32: map.WORKER_ID = p_worker_id and
33: act5.PROJECT_ID = map.PROJECT_ID;

Line 767: PJI_PJI_PROJ_BATCH_MAP map

763: select
764: map.PROJECT_ID,
765: map.NEW_PROJECT_ORGANIZATION_ID
766: from
767: PJI_PJI_PROJ_BATCH_MAP map
768: where
769: map.NEW_PROJECT_ORGANIZATION_ID <> map.PROJECT_ORGANIZATION_ID
770: ) map
771: where

Line 877: PJI_PJI_PROJ_BATCH_MAP map,

873: to_number(null) LOST_BACKLOG,
874: to_number(null) ACTIVE_BACKLOG,
875: to_number(null) REVENUE_AT_RISK
876: from
877: PJI_PJI_PROJ_BATCH_MAP map,
878: PJI_AC_PROJ_F acp,
879: FII_TIME_RPT_STRUCT cal,
880: PJI_ORG_EXTR_INFO info
881: where

Line 955: PJI_PJI_PROJ_BATCH_MAP map,

951: to_number(null) ACTIVE_BACKLOG,
952: to_number(null) REVENUE_AT_RISK
953:
954: from
955: PJI_PJI_PROJ_BATCH_MAP map,
956: PJI_AC_PROJ_F acp,
957: PJI_ORG_EXTR_INFO info,
958: FII_TIME_CAL_RPT_STRUCT cal
959: where

Line 1036: PJI_PJI_PROJ_BATCH_MAP map,

1032: to_number(null) ACTIVE_BACKLOG,
1033: to_number(null) REVENUE_AT_RISK
1034:
1035: from
1036: PJI_PJI_PROJ_BATCH_MAP map,
1037: PJI_AC_PROJ_F acp,
1038: PJI_ORG_EXTR_INFO info,
1039: PJI_TIME_PA_RPT_STR_MV cal
1040: where

Line 2183: PJI_PJI_PROJ_BATCH_MAP map,

2179: to_number(null) LOST_BACKLOG,
2180: to_number(null) ACTIVE_BACKLOG,
2181: to_number(null) REVENUE_AT_RISK
2182: from
2183: PJI_PJI_PROJ_BATCH_MAP map,
2184: PJI_AC_PROJ_F acp
2185: where
2186: nvl(p_backlog_flag, 'N') = 'N' and
2187: l_extraction_type = 'PARTIAL' and

Line 2610: FROM PJI_PJI_PROJ_BATCH_MAP map

2606: IS
2607: SELECT
2608: map.PROJECT_ID
2609: , map.NEW_PROJECT_ORGANIZATION_ID
2610: FROM PJI_PJI_PROJ_BATCH_MAP map
2611: WHERE 1=1
2612: AND map.WORKER_ID = c_worker_id
2613: AND map.PROJECT_ORGANIZATION_ID <> map.NEW_PROJECT_ORGANIZATION_ID
2614: ;