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 3160: PJI_FM_DNGL_ACT tmp2,

3156: tmp2.AR_APPR_INVOICE_COUNT,
3157: tmp2.AR_COUNT_DUE,
3158: tmp2.AR_COUNT_OVERDUE
3159: from
3160: PJI_FM_DNGL_ACT tmp2,
3161: PJI_FM_PROJ_BATCH_MAP map,
3162: PJI_ORG_EXTR_INFO prj_info,
3163: PJI_FM_AGGR_DLY_RATES gl_rt,
3164: PJI_FM_AGGR_DLY_RATES pa_rt

Line 3237: from PJI_FM_DNGL_ACT act

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

Line 5731: insert into PJI_FM_DNGL_ACT

5727: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_EXTR.MOVE_DANGLING_ACT_ROWS(p_worker_id);')) then
5728: return;
5729: end if;
5730:
5731: insert into PJI_FM_DNGL_ACT
5732: (
5733: WORKER_ID,
5734: DANGLING_GL_RATE_FLAG,
5735: DANGLING_GL_RATE2_FLAG,