DBA Data[Home] [Help]

APPS.PJI_FM_SUM_EXTR dependencies on PJI_FM_DNGL_ACT

Line 283: PJI_FM_DNGL_ACT tmp2

279: PROJECT_ID,
280: GL_TIME_ID,
281: PA_TIME_ID
282: from
283: PJI_FM_DNGL_ACT tmp2
284: where
285: WORKER_ID = 0
286: ) tmp2,
287: (

Line 3157: PJI_FM_DNGL_ACT tmp2,

3153: tmp2.AR_APPR_INVOICE_COUNT,
3154: tmp2.AR_COUNT_DUE,
3155: tmp2.AR_COUNT_OVERDUE
3156: from
3157: PJI_FM_DNGL_ACT tmp2,
3158: PJI_FM_PROJ_BATCH_MAP map,
3159: PJI_ORG_EXTR_INFO prj_info,
3160: PJI_FM_AGGR_DLY_RATES gl_rt,
3161: PJI_FM_AGGR_DLY_RATES pa_rt

Line 3234: from PJI_FM_DNGL_ACT act

3230: return;
3231: end if;
3232:
3233: delete /*+ parallel(act) */
3234: from PJI_FM_DNGL_ACT act
3235: where WORKER_ID = 0 and
3236: ROWID in (select ROW_ID
3237: from PJI_FM_AGGR_ACT2
3238: where WORKER_ID = p_worker_id);

Line 5721: insert into PJI_FM_DNGL_ACT

5717: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_EXTR.MOVE_DANGLING_ACT_ROWS(p_worker_id);')) then
5718: return;
5719: end if;
5720:
5721: insert into PJI_FM_DNGL_ACT
5722: (
5723: WORKER_ID,
5724: DANGLING_GL_RATE_FLAG,
5725: DANGLING_GL_RATE2_FLAG,