[Home] [Help]
2363: l_creation_date := sysdate;
2364: l_created_by := FND_GLOBAL.USER_ID;
2365: l_last_update_login := FND_GLOBAL.LOGIN_ID;
2366:
2367: insert /*+ append parallel(hdr_i) */ into PJI_FP_TXN_ACCUM_HEADER hdr_i
2368: (
2369: TXN_ACCUM_HEADER_ID,
2370: PERSON_ID,
2371: EXPENDITURE_ORG_ID,
2399: LAST_UPDATE_LOGIN,
2400: CBS_ELEMENT_ID /* Added for CBS Changes */
2401: )
2402: select
2403: PJI_FP_TXN_ACCUM_HEADER_S.NEXTVAL TXN_ACCUM_HEADER_ID,
2404: PERSON_ID,
2405: EXPENDITURE_ORG_ID,
2406: EXPENDITURE_ORGANIZATION_ID,
2407: RESOURCE_CLASS_ID,
2471: not exists
2472: (select
2473: 1
2474: from
2475: PJI_FP_TXN_ACCUM_HEADER hdr
2476: where
2477: tmp6.PERSON_ID = hdr.PERSON_ID and
2478: tmp6.EXPENDITURE_ORG_ID = hdr.EXPENDITURE_ORG_ID and
2479: tmp6.EXPENDITURE_ORGANIZATION_ID = hdr.EXPENDITURE_ORGANIZATION_ID and
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
2660: tmp6.PERSON_ID = hdr.PERSON_ID and
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
2866: tmp6.EXPENDITURE_ORG_ID = hdr.EXPENDITURE_ORG_ID and
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
2918: tmp6.RECORD_TYPE = 'A' and
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
3115: tmp6.PERSON_ID = hdr.PERSON_ID and
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
3301: tmp6.PERSON_ID = hdr.PERSON_ID and
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
3367: tmp6.RECORD_TYPE = 'A' and
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
3549: tmp6.PERSON_ID = hdr.PERSON_ID and
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
3614: tmp6.RECORD_TYPE = 'M' and
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
3789: tmp6.PERSON_ID = hdr.PERSON_ID and
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
3849: tmp6.RECORD_TYPE = 'M' and