DBA Data[Home] [Help]

APPS.PJI_RM_SUM_EXTR dependencies on PJI_PJI_PROJ_BATCH_MAP

Line 154: PJI_PJI_PROJ_BATCH_MAP map,

150: select /*+ ordered */
151: p_worker_id WORKER_ID,
152: res6.ROWID STG_ROWID
153: from
154: PJI_PJI_PROJ_BATCH_MAP map,
155: PJI_RM_AGGR_RES6 res6,
156: PJI_RESOURCES_DENORM denorm
157: where
158: map.WORKER_ID = p_worker_id and

Line 1159: PJI_PJI_PROJ_BATCH_MAP map,

1155: to_number(null) UNASSIGNED_HRS_S,
1156: to_number(null) CONF_OVERCOM_HRS_S,
1157: to_number(null) PROV_OVERCOM_HRS_S
1158: from
1159: PJI_PJI_PROJ_BATCH_MAP map,
1160: PJI_RM_RES_WT_F rmr,
1161: PJI_ORG_EXTR_INFO info
1162: where
1163: l_extraction_type = 'PARTIAL' and

Line 1198: PJI_PJI_PROJ_BATCH_MAP fm_map,

1194: from
1195: PJI_RES_DELTA delta,
1196: PJI_RM_RES_WT_F rmr,
1197: PJI_RM_ORG_BATCH_MAP map,
1198: PJI_PJI_PROJ_BATCH_MAP fm_map,
1199: PJI_ORG_EXTR_INFO info
1200: where
1201: l_extraction_type = 'PARTIAL' and
1202: delta.CHANGE_TYPE = 'N' and