eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PJI_FM_SUM_EXTR dependencies on PJI_FM_PROJ_BATCH_MAP

Line 202: PJI_FM_PROJ_BATCH_MAP map,

198: 'RECVR_PA', prj_info.PF_CURRENCY_CODE,
199: 'EXP', res_info.PF_CURRENCY_CODE) PF_CURRENCY_CODE
200: from -- bug 3092751: changes in table order
201: PJI_ORG_EXTR_INFO prj_info,
202: PJI_FM_PROJ_BATCH_MAP map,
203: (
204: select /*+ full(tmp2) parallel(tmp2) */
205: distinct
206: PROJECT_ID,

Line 275: PJI_FM_PROJ_BATCH_MAP map,

271: 'PA', tmp2.PA_TIME_ID) TIME_ID,
272: prj_info.PF_CURRENCY_CODE
273: from -- bug 3092751: changes in table order
274: PJI_ORG_EXTR_INFO prj_info,
275: PJI_FM_PROJ_BATCH_MAP map,
276: (
277: select /*+ parallel(tmp2) full(tmp2) */
278: distinct
279: PROJECT_ID,

Line 308: PJI_FM_PROJ_BATCH_MAP map,

304: 'PA', tmp2.PA_TIME_ID) TIME_ID,
305: prj_info.PF_CURRENCY_CODE
306: from
307: PJI_ORG_EXTR_INFO prj_info,
308: PJI_FM_PROJ_BATCH_MAP map,
309: /* commented and changed as below for bug 6894858
310: (
311: select /*+ parallel(cmt) full(cmt)
312: distinct

Line 1783: PJI_FM_PROJ_BATCH_MAP map,

1779: tmp2.TOTAL_HRS_A,
1780: tmp2.BILL_HRS_A
1781: from
1782: PJI_FM_DNGL_FIN tmp2,
1783: PJI_FM_PROJ_BATCH_MAP map,
1784: PJI_ORG_EXTR_INFO prj_info,
1785: PJI_ORG_EXTR_INFO res_info,
1786: PJI_FM_AGGR_DLY_RATES prj_gl_rt,
1787: PJI_FM_AGGR_DLY_RATES prj_pa_rt

Line 3158: PJI_FM_PROJ_BATCH_MAP map,

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
3162: where

Line 6078: from PJI_FM_PROJ_BATCH_MAP

6074:
6075: delete
6076: from PJI_RM_AGGR_RES6
6077: where PROJECT_ID in (select PROJECT_ID
6078: from PJI_FM_PROJ_BATCH_MAP
6079: where WORKER_ID = p_worker_id);
6080:
6081: end if;
6082:

Line 6162: from PJI_FM_PROJ_BATCH_MAP

6158:
6159: delete
6160: from PJI_FM_AGGR_FIN9
6161: where PROJECT_ID in (select PROJECT_ID
6162: from PJI_FM_PROJ_BATCH_MAP
6163: where WORKER_ID = p_worker_id);
6164:
6165: end if;
6166:

Line 6434: from PJI_FM_PROJ_BATCH_MAP

6430:
6431: delete
6432: from PJI_FM_AGGR_ACT5
6433: where PROJECT_ID in (select PROJECT_ID
6434: from PJI_FM_PROJ_BATCH_MAP
6435: where WORKER_ID = p_worker_id);
6436:
6437: elsif (l_extraction_type = 'INCREMENTAL') then
6438:

Line 6490: from PJI_FM_PROJ_BATCH_MAP map

6486: act5.G2_AR_APPR_INVOICE_AMOUNT = to_number(null),
6487: act5.G2_AR_AMOUNT_DUE = to_number(null),
6488: act5.G2_AR_AMOUNT_OVERDUE = to_number(null)
6489: where act5.PROJECT_ID in (select map.PROJECT_ID
6490: from PJI_FM_PROJ_BATCH_MAP map
6491: where map.WORKER_ID = p_worker_id) and
6492: not (nvl(act5.TXN_AR_INVOICE_AMOUNT , 0) = 0 and
6493: nvl(act5.TXN_AR_CASH_APPLIED_AMOUNT , 0) = 0 and
6494: nvl(act5.TXN_AR_INVOICE_WRITEOFF_AMOUNT , 0) = 0 and

Line 6543: from PJI_FM_PROJ_BATCH_MAP map

6539:
6540: delete
6541: from PJI_FM_AGGR_ACT5 act5
6542: where act5.PROJECT_ID in (select map.PROJECT_ID
6543: from PJI_FM_PROJ_BATCH_MAP map
6544: where map.WORKER_ID = p_worker_id) and
6545: nvl(act5.TXN_REVENUE , 0) = 0 and
6546: nvl(act5.TXN_FUNDING , 0) = 0 and
6547: nvl(act5.TXN_INITIAL_FUNDING_AMOUNT , 0) = 0 and