APPS.PJI_RM_SUM_EXTR dependencies on PJI_RM_ORG_BATCH_MAP

Line 78: PJI_RM_ORG_BATCH_MAP orgs,

74: tmp1.CONF_OVERCOM_HRS_S,
75: tmp1.PROV_OVERCOM_HRS_S
76: from
77: PJI_RM_DNGL_RES tmp1,
78: PJI_RM_ORG_BATCH_MAP orgs,
79: PJI_ORG_EXTR_INFO res_map
80: where
81: tmp1.WORKER_ID = 0 and
82: orgs.WORKER_ID = p_worker_id and

Line 189: from pji_rm_org_batch_map

185: cursor c_update_fid is
186: select fid.ROWID as row_id
187: from pa_forecast_item_details fid
188: where fid.expenditure_organization_id in (select organization_id
189: from pji_rm_org_batch_map
190: where worker_id = p_worker_id)
191: and fid.pji_summarized_flag = 'N';
192:
193: begin

Line 556: pji_rm_org_batch_map bat

552: , bat.end_date END_DATE
553: , fid.PJI_SUMMARIZED_FLAG
554: , ceil(ROWNUM / PJI_RM_SUM_MAIN.g_commit_threshold)
555: FROM
556: pji_rm_org_batch_map bat
557: , pa_forecast_item_details fid
558: , pji_rm_rext_fcstitem fcst
559: WHERE
560: bat.WORKER_ID = p_worker_id and

Line 1122: PJI_RM_ORG_BATCH_MAP map,

1118: -rmr.UNASSIGNED_HRS_S UNASSIGNED_HRS_S,
1119: -rmr.CONF_OVERCOM_HRS_S CONF_OVERCOM_HRS_S,
1120: -rmr.PROV_OVERCOM_HRS_S PROV_OVERCOM_HRS_S
1121: from
1122: PJI_RM_ORG_BATCH_MAP map,
1123: PJI_RM_RES_WT_F rmr,
1124: PJI_ORG_EXTR_INFO info
1125: where
1126: l_extraction_type = 'PARTIAL' and

Line 1197: PJI_RM_ORG_BATCH_MAP map,

1193: -rmr.PROV_OVERCOM_HRS_S PROV_OVERCOM_HRS_S
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