APPS.PJI_FM_SUM_ACT dependencies on PJI_FM_EXTR_ARINV

Line 802: PJI_FM_EXTR_ARINV ar

798: 1, 1, 0), 0) AR_COUNT_DUE,
799: decode(sign(amount_overdue_remaining),
800: 1, 1, 0) AR_COUNT_OVERDUE
801: from
802: PJI_FM_EXTR_ARINV ar
803: where
804: ar.WORKER_ID = p_worker_id
805: )
806: group by

Line 826: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_ARINV' , 'NORMAL',null);

822: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_FUNDG' , 'NORMAL',null);
823: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_DREVN' , 'NORMAL',null);
824: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_DINVC' , 'NORMAL',null);
825: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_DINVCITM' , 'NORMAL',null);
826: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_ARINV' , 'NORMAL',null);
827:
828: commit;
829:
830: end BASE_SUMMARY;