APPS.PJI_FM_SUM_PSI dependencies on PJI_FM_AGGR_FIN6

Line 507: insert /*+ append parallel(tmp6_i) */ into PJI_FM_AGGR_FIN6 tmp6_i

503: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_PSI.AGGREGATE_FPR_PERIODS(p_worker_id);')) then
504: return;
505: end if;
506:
507: insert /*+ append parallel(tmp6_i) */ into PJI_FM_AGGR_FIN6 tmp6_i
508: (
509: WORKER_ID,
510: RECORD_TYPE,
511: PERSON_ID,

Line 2466: PJI_FM_AGGR_FIN6 tmp6

2462: SYSTEM_LINKAGE_FUNCTION,
2463: NAMED_ROLE , /* Added for bug 9108213 (base bug 9099907) */
2464: to_number(null) AS CBS_ELEMENT_ID /* Added for CBS Changes */
2465: from
2466: PJI_FM_AGGR_FIN6 tmp6
2467: where
2468: WORKER_ID = p_worker_id
2469: ) tmp6
2470: where

Line 2655: PJI_FM_AGGR_FIN6 tmp6,

2651: l_created_by CREATED_BY,
2652: l_last_update_login LAST_UPDATE_LOGIN,
2653: tmp6.CBS_ELEMENT_ID CBS_ELEMENT_ID /* Added for CBS Changes */
2654: from
2655: PJI_FM_AGGR_FIN6 tmp6,
2656: PJI_FP_TXN_ACCUM_HEADER hdr
2657: where
2658: tmp6.WORKER_ID = p_worker_id and
2659: tmp6.RECORD_TYPE = 'A' and

Line 2861: PJI_FM_AGGR_FIN6 tmp6,

2857: tmp6.G2_PR_COMMITTED_COST,
2858: tmp6.G2_OTH_COMMITTED_COST,
2859: tmp6.CBS_ELEMENT_ID /* Added for CBS Changes */
2860: from
2861: PJI_FM_AGGR_FIN6 tmp6,
2862: PJI_FP_TXN_ACCUM_HEADER hdr
2863: where
2864: tmp6.WORKER_ID = p_worker_id and
2865: tmp6.PERSON_ID = hdr.PERSON_ID and

Line 2913: PJI_FM_AGGR_FIN6 tmp6,

2909: )
2910: select
2911: distinct tmp6.PROJECT_ID
2912: from
2913: PJI_FM_AGGR_FIN6 tmp6,
2914: PJI_FP_TXN_ACCUM_HEADER hdr,
2915: pa_projects_all prj
2916: where
2917: tmp6.WORKER_ID = p_worker_id and

Line 3110: PJI_FM_AGGR_FIN6 tmp6,

3106: tmp6.G2_PO_COMMITTED_COST,
3107: tmp6.G2_PR_COMMITTED_COST,
3108: tmp6.G2_OTH_COMMITTED_COST
3109: from
3110: PJI_FM_AGGR_FIN6 tmp6,
3111: PJI_FP_TXN_ACCUM_HEADER hdr,
3112: pa_projects_all prj
3113: where
3114: tmp6.WORKER_ID = p_worker_id and

Line 3296: PJI_FM_AGGR_FIN6 tmp6,

3292: l_created_by CREATED_BY,
3293: l_last_update_login LAST_UPDATE_LOGIN,
3294: tmp6.CBS_ELEMENT_ID CBS_ELEMENT_ID /* Added for CBS Changes */
3295: from
3296: PJI_FM_AGGR_FIN6 tmp6,
3297: PJI_FP_TXN_ACCUM_HEADER hdr
3298: where
3299: tmp6.WORKER_ID = p_worker_id and
3300: tmp6.RECORD_TYPE = 'A' and

Line 3362: PJI_FM_AGGR_FIN6 tmp6,

3358: )
3359: select
3360: tmp6.PROJECT_ID
3361: from
3362: PJI_FM_AGGR_FIN6 tmp6,
3363: PJI_FP_TXN_ACCUM_HEADER hdr,
3364: pa_projects_all prj
3365: where
3366: tmp6.WORKER_ID = p_worker_id and

Line 3544: PJI_FM_AGGR_FIN6 tmp6,

3540: l_created_by CREATED_BY,
3541: l_last_update_login LAST_UPDATE_LOGIN,
3542: tmp6.CBS_ELEMENT_ID CBS_ELEMENT_ID /* Added for CBS Changes */
3543: from
3544: PJI_FM_AGGR_FIN6 tmp6,
3545: PJI_FP_TXN_ACCUM_HEADER hdr
3546: where
3547: tmp6.WORKER_ID = p_worker_id and
3548: tmp6.RECORD_TYPE = 'M' and

Line 3609: PJI_FM_AGGR_FIN6 tmp6,

3605: )
3606: select
3607: tmp6.PROJECT_ID
3608: from
3609: PJI_FM_AGGR_FIN6 tmp6,
3610: PJI_FP_TXN_ACCUM_HEADER hdr,
3611: pa_projects_all prj
3612: where
3613: tmp6.WORKER_ID = p_worker_id and

Line 3784: PJI_FM_AGGR_FIN6 tmp6,

3780: l_created_by CREATED_BY,
3781: l_last_update_login LAST_UPDATE_LOGIN,
3782: tmp6.CBS_ELEMENT_ID CBS_ELEMENT_ID /* Added for CBS Changes */
3783: from
3784: PJI_FM_AGGR_FIN6 tmp6,
3785: PJI_FP_TXN_ACCUM_HEADER hdr
3786: where
3787: tmp6.WORKER_ID = p_worker_id and
3788: tmp6.RECORD_TYPE = 'M' and

Line 3844: PJI_FM_AGGR_FIN6 tmp6,

3840: )
3841: select
3842: tmp6.PROJECT_ID
3843: from
3844: PJI_FM_AGGR_FIN6 tmp6,
3845: PJI_FP_TXN_ACCUM_HEADER hdr,
3846: pa_projects_all prj
3847: where
3848: tmp6.WORKER_ID = p_worker_id and

Line 4972: 'PJI_FM_AGGR_FIN6',

4968: 'NORMAL',
4969: null);
4970:
4971: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,
4972: 'PJI_FM_AGGR_FIN6',
4973: 'NORMAL',
4974: null);
4975:
4976: end CLEANUP;