APPS.PJI_FM_SUM_PSI dependencies on PJI_FP_TXN_ACCUM_HEADER

Line 2345: insert /*+ append parallel(hdr_i) */ into PJI_FP_TXN_ACCUM_HEADER hdr_i

2341: l_creation_date := sysdate;
2342: l_created_by := FND_GLOBAL.USER_ID;
2343: l_last_update_login := FND_GLOBAL.LOGIN_ID;
2344:
2345: insert /*+ append parallel(hdr_i) */ into PJI_FP_TXN_ACCUM_HEADER hdr_i
2346: (
2347: TXN_ACCUM_HEADER_ID,
2348: PERSON_ID,
2349: EXPENDITURE_ORG_ID,

Line 2379: PJI_FP_TXN_ACCUM_HEADER_S.NEXTVAL TXN_ACCUM_HEADER_ID,

2375: CREATED_BY,
2376: LAST_UPDATE_LOGIN
2377: )
2378: select
2379: PJI_FP_TXN_ACCUM_HEADER_S.NEXTVAL TXN_ACCUM_HEADER_ID,
2380: PERSON_ID,
2381: EXPENDITURE_ORG_ID,
2382: EXPENDITURE_ORGANIZATION_ID,
2383: RESOURCE_CLASS_ID,

Line 2447: PJI_FP_TXN_ACCUM_HEADER hdr

2443: not exists
2444: (select
2445: 1
2446: from
2447: PJI_FP_TXN_ACCUM_HEADER hdr
2448: where
2449: tmp6.PERSON_ID = hdr.PERSON_ID and
2450: tmp6.EXPENDITURE_ORG_ID = hdr.EXPENDITURE_ORG_ID and
2451: tmp6.EXPENDITURE_ORGANIZATION_ID = hdr.EXPENDITURE_ORGANIZATION_ID and

Line 2624: PJI_FP_TXN_ACCUM_HEADER hdr

2620: l_created_by CREATED_BY,
2621: l_last_update_login LAST_UPDATE_LOGIN
2622: from
2623: PJI_FM_AGGR_FIN6 tmp6,
2624: PJI_FP_TXN_ACCUM_HEADER hdr
2625: where
2626: tmp6.WORKER_ID = p_worker_id and
2627: tmp6.RECORD_TYPE = 'A' and
2628: tmp6.PERSON_ID = hdr.PERSON_ID and

Line 2827: PJI_FP_TXN_ACCUM_HEADER hdr

2823: tmp6.G2_PR_COMMITTED_COST,
2824: tmp6.G2_OTH_COMMITTED_COST
2825: from
2826: PJI_FM_AGGR_FIN6 tmp6,
2827: PJI_FP_TXN_ACCUM_HEADER hdr
2828: where
2829: tmp6.WORKER_ID = p_worker_id and
2830: tmp6.PERSON_ID = hdr.PERSON_ID and
2831: tmp6.EXPENDITURE_ORG_ID = hdr.EXPENDITURE_ORG_ID and

Line 3008: PJI_FP_TXN_ACCUM_HEADER hdr

3004: l_created_by CREATED_BY,
3005: l_last_update_login LAST_UPDATE_LOGIN
3006: from
3007: PJI_FM_AGGR_FIN6 tmp6,
3008: PJI_FP_TXN_ACCUM_HEADER hdr
3009: where
3010: tmp6.WORKER_ID = p_worker_id and
3011: tmp6.RECORD_TYPE = 'A' and
3012: tmp6.PERSON_ID = hdr.PERSON_ID and

Line 3191: PJI_FP_TXN_ACCUM_HEADER hdr

3187: l_created_by CREATED_BY,
3188: l_last_update_login LAST_UPDATE_LOGIN
3189: from
3190: PJI_FM_AGGR_FIN6 tmp6,
3191: PJI_FP_TXN_ACCUM_HEADER hdr
3192: where
3193: tmp6.WORKER_ID = p_worker_id and
3194: tmp6.RECORD_TYPE = 'M' and
3195: tmp6.PERSON_ID = hdr.PERSON_ID and

Line 3364: PJI_FP_TXN_ACCUM_HEADER hdr

3360: l_created_by CREATED_BY,
3361: l_last_update_login LAST_UPDATE_LOGIN
3362: from
3363: PJI_FM_AGGR_FIN6 tmp6,
3364: PJI_FP_TXN_ACCUM_HEADER hdr
3365: where
3366: tmp6.WORKER_ID = p_worker_id and
3367: tmp6.RECORD_TYPE = 'M' and
3368: tmp6.PERSON_ID = hdr.PERSON_ID and