DBA Data[Home] [Help]

APPS.PJI_RM_SUM_EXTR dependencies on PJI_RM_DNGL_RES

Line 77: PJI_RM_DNGL_RES tmp1,

73: tmp1.UNASSIGNED_HRS_S,
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

Line 116: from PJI_RM_DNGL_RES res

112: return;
113: end if;
114:
115: delete /*+ parallel(res) */
116: from PJI_RM_DNGL_RES res
117: where WORKER_ID = 0 and
118: ROWID in (select ROW_ID
119: from PJI_RM_AGGR_RES1
120: where WORKER_ID = p_worker_id);

Line 870: insert into PJI_RM_DNGL_RES

866: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_RM_SUM_EXTR.MOVE_DANGLING_ROWS(p_worker_id);')) then
867: return;
868: end if;
869:
870: insert into PJI_RM_DNGL_RES
871: (
872: WORKER_ID,
873: DANGLING_FLAG,
874: RECORD_TYPE,