APPS.PJI_RM_SUM_EXTR dependencies on PJI_RM_AGGR_RES6

Line 155: PJI_RM_AGGR_RES6 res6,

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
159: res6.PROJECT_ID = map.PROJECT_ID and

Line 401: PJI_RM_AGGR_RES6 res6,

397: res6.JOB_ID,
398: res6.WORK_TYPE_ID,
399: res6.PROJECT_ID
400: from
401: PJI_RM_AGGR_RES6 res6,
402: PJI_PJI_RMAP_RES res6_r
403: where
404: res6_r.WORKER_ID = p_worker_id and
405: res6.ROWID = res6_r.STG_ROWID

Line 817: PJI_RM_AGGR_RES6 res6

813: res6.WORK_TYPE_ID,
814: res6.PROJECT_ID
815: from
816: PJI_PJI_RMAP_RES res6_r,
817: PJI_RM_AGGR_RES6 res6
818: where
819: res6_r.WORKER_ID = p_worker_id and
820: res6.ROWID = res6_r.STG_ROWID
821: ) tmp1

Line 949: from PJI_RM_AGGR_RES6

945: return;
946: end if;
947:
948: delete
949: from PJI_RM_AGGR_RES6
950: where ROWID in (select STG_ROWID
951: from PJI_PJI_RMAP_RES
952: where WORKER_ID = p_worker_id);
953: