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 1786: PJI_FM_PROJ_BATCH_MAP map,

1782: tmp2.BILL_HRS_A,
1783: tmp2.CBS_ELEMENT_ID /*Added for CBS Changes */
1784: from
1785: PJI_FM_DNGL_FIN tmp2,
1786: PJI_FM_PROJ_BATCH_MAP map,
1787: PJI_ORG_EXTR_INFO prj_info,
1788: PJI_ORG_EXTR_INFO res_info,
1789: PJI_FM_AGGR_DLY_RATES prj_gl_rt,
1790: PJI_FM_AGGR_DLY_RATES prj_pa_rt

Line 3161: PJI_FM_PROJ_BATCH_MAP map,

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

Line 6088: from PJI_FM_PROJ_BATCH_MAP

6084:
6085: delete
6086: from PJI_RM_AGGR_RES6
6087: where PROJECT_ID in (select PROJECT_ID
6088: from PJI_FM_PROJ_BATCH_MAP
6089: where WORKER_ID = p_worker_id);
6090:
6091: end if;
6092:

Line 6172: from PJI_FM_PROJ_BATCH_MAP

6168:
6169: delete
6170: from PJI_FM_AGGR_FIN9
6171: where PROJECT_ID in (select PROJECT_ID
6172: from PJI_FM_PROJ_BATCH_MAP
6173: where WORKER_ID = p_worker_id);
6174:
6175: end if;
6176:

Line 6814: from PJI_FM_PROJ_BATCH_MAP

6810:
6811: delete
6812: from PJI_FM_AGGR_ACT5
6813: where PROJECT_ID in (select PROJECT_ID
6814: from PJI_FM_PROJ_BATCH_MAP
6815: where WORKER_ID = p_worker_id);
6816:
6817: elsif (l_extraction_type = 'INCREMENTAL') then
6818:

Line 6870: from PJI_FM_PROJ_BATCH_MAP map

6866: act5.G2_AR_APPR_INVOICE_AMOUNT = to_number(null),
6867: act5.G2_AR_AMOUNT_DUE = to_number(null),
6868: act5.G2_AR_AMOUNT_OVERDUE = to_number(null)
6869: where act5.PROJECT_ID in (select map.PROJECT_ID
6870: from PJI_FM_PROJ_BATCH_MAP map
6871: where map.WORKER_ID = p_worker_id) and
6872: not (nvl(act5.TXN_AR_INVOICE_AMOUNT , 0) = 0 and
6873: nvl(act5.TXN_AR_CASH_APPLIED_AMOUNT , 0) = 0 and
6874: nvl(act5.TXN_AR_INVOICE_WRITEOFF_AMOUNT , 0) = 0 and

Line 6923: from PJI_FM_PROJ_BATCH_MAP map

6919:
6920: delete
6921: from PJI_FM_AGGR_ACT5 act5
6922: where act5.PROJECT_ID in (select map.PROJECT_ID
6923: from PJI_FM_PROJ_BATCH_MAP map
6924: where map.WORKER_ID = p_worker_id) and
6925: nvl(act5.TXN_REVENUE , 0) = 0 and
6926: nvl(act5.TXN_FUNDING , 0) = 0 and
6927: nvl(act5.TXN_INITIAL_FUNDING_AMOUNT , 0) = 0 and