APPS.PJI_FM_SUM_EXTR dependencies on PJI_FM_AGGR_DLY_RATES

Line 87: insert /*+ append */ into PJI_FM_AGGR_DLY_RATES

83: l_extract_commitments := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
84: (PJI_FM_SUM_MAIN.g_process,
85: 'EXTRACT_COMMITMENTS');
86:
87: insert /*+ append */ into PJI_FM_AGGR_DLY_RATES
88: (
89: WORKER_ID,
90: PF_CURRENCY_CODE,
91: TIME_ID,

Line 357: PJI_FM_AGGR_DLY_RATES rates

353: --map.PROJECT_ID = tmp2.PROJECT_ID and --6894858
354: map.PROJECT_ORG_ID = prj_info.ORG_ID
355: )
356: ) tmp,
357: PJI_FM_AGGR_DLY_RATES rates
358: where
359: -1 = rates.WORKER_ID (+) and
360: tmp.PF_CURRENCY_CODE = rates.PF_CURRENCY_CODE (+) and
361: tmp.TIME_ID = rates.TIME_ID (+) and

Line 1789: PJI_FM_AGGR_DLY_RATES prj_gl_rt,

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
1791: where
1792: tmp2.WORKER_ID = 0 and
1793: tmp2.RECORD_TYPE = 'A' and

Line 1790: PJI_FM_AGGR_DLY_RATES prj_pa_rt

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
1791: where
1792: tmp2.WORKER_ID = 0 and
1793: tmp2.RECORD_TYPE = 'A' and
1794: map.WORKER_ID = p_worker_id and

Line 3163: PJI_FM_AGGR_DLY_RATES gl_rt,

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
3166: tmp2.WORKER_ID = 0 and
3167: map.WORKER_ID = p_worker_id and

Line 3164: PJI_FM_AGGR_DLY_RATES pa_rt

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
3166: tmp2.WORKER_ID = 0 and
3167: map.WORKER_ID = p_worker_id and
3168: map.PROJECT_ID = tmp2.PROJECT_ID and

Line 4328: PJI_FM_AGGR_DLY_RATES prj_gl_rt,

4324: tmp1.TXN_CURRENCY_CODE,
4325: tmp1.CBS_ELEMENT_ID /* Added for CBS Changes */
4326: ) tmp1,
4327: PJI_ORG_EXTR_INFO res_info,
4328: PJI_FM_AGGR_DLY_RATES prj_gl_rt,
4329: PJI_FM_AGGR_DLY_RATES prj_pa_rt
4330: where
4331: tmp1.EXPENDITURE_ORGANIZATION_ID is not null and
4332: decode(l_params_cost_flag, 'Y', tmp1.PROJECT_ORG_ID, -1)

Line 4329: PJI_FM_AGGR_DLY_RATES prj_pa_rt

4325: tmp1.CBS_ELEMENT_ID /* Added for CBS Changes */
4326: ) tmp1,
4327: PJI_ORG_EXTR_INFO res_info,
4328: PJI_FM_AGGR_DLY_RATES prj_gl_rt,
4329: PJI_FM_AGGR_DLY_RATES prj_pa_rt
4330: where
4331: tmp1.EXPENDITURE_ORGANIZATION_ID is not null and
4332: decode(l_params_cost_flag, 'Y', tmp1.PROJECT_ORG_ID, -1)
4333: = prj_info.ORG_ID and

Line 5633: PJI_FM_AGGR_DLY_RATES gl_rt,

5629: sum(tmp1.AR_COUNT_OVERDUE) AR_COUNT_OVERDUE
5630: from
5631: PJI_FM_AGGR_ACT1 tmp1,
5632: PJI_ORG_EXTR_INFO prj_info,
5633: PJI_FM_AGGR_DLY_RATES gl_rt,
5634: PJI_FM_AGGR_DLY_RATES pa_rt
5635: where
5636: tmp1.WORKER_ID = p_worker_id and
5637: tmp1.PROJECT_ORG_ID = prj_info.ORG_ID and

Line 5634: PJI_FM_AGGR_DLY_RATES pa_rt

5630: from
5631: PJI_FM_AGGR_ACT1 tmp1,
5632: PJI_ORG_EXTR_INFO prj_info,
5633: PJI_FM_AGGR_DLY_RATES gl_rt,
5634: PJI_FM_AGGR_DLY_RATES pa_rt
5635: where
5636: tmp1.WORKER_ID = p_worker_id and
5637: tmp1.PROJECT_ORG_ID = prj_info.ORG_ID and
5638: gl_rt.WORKER_ID = -1 and

Line 5702: from PJI_FM_AGGR_DLY_RATES

5698: tmp1.TXN_CURRENCY_CODE
5699: ) tmp1;
5700:
5701: delete
5702: from PJI_FM_AGGR_DLY_RATES
5703: where WORKER_ID = -1;
5704:
5705: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_EXTR.ACT_SUMMARY(p_worker_id);');
5706: