APPS.PA_BURDEN_COSTING dependencies on PA_EI_CDL_CM_GTEMP

Line 1024: insert into PA_EI_CDL_CM_GTEMP(

1020: */
1021: /* Insert into global temp table with the Ei's selected by get_compile_cursor Bug# 5406802 */
1022: /* Modified expenditure item date for 5907315*/
1023: FORALL i in 1..l_eiid_tbl.count
1024: insert into PA_EI_CDL_CM_GTEMP(
1025: PROJECT_ID ,TASK_ID ,ORGANIZATION_ID
1026: ,PA_DATE ,PA_PERIOD_NAME ,ATTRIBUTE1
1027: ,ATTRIBUTE2 ,ATTRIBUTE3 ,ATTRIBUTE4
1028: ,ATTRIBUTE5 ,ATTRIBUTE6 ,ATTRIBUTE7

Line 3264: insert into PA_EI_CDL_CM_GTEMP(

3260: /* Bug 5896943: Inserting prvdr_accrual_date in place of expenditure_item_date
3261: for period accrual transactions so that the reversal BTC's will be in the future period.
3262: */
3263: /* Modified expenditure item date for bug 5907315*/
3264: insert into PA_EI_CDL_CM_GTEMP(
3265: PROJECT_ID ,TASK_ID ,ORGANIZATION_ID
3266: ,PA_DATE ,PA_PERIOD_NAME ,ATTRIBUTE1
3267: ,ATTRIBUTE2 ,ATTRIBUTE3 ,ATTRIBUTE4
3268: ,ATTRIBUTE5 ,ATTRIBUTE6 ,ATTRIBUTE7

Line 3336: UPDATE PA_EI_CDL_CM_GTEMP ei

3332:
3333: IF SQL%ROWCOUNT > 0 THEN
3334:
3335: /* The sub query should return only one row, if not we have to use distinct clause*/
3336: UPDATE PA_EI_CDL_CM_GTEMP ei
3337: set (COST_PLUS_STRUCTURE ,COST_BASE) =
3338: (select /*+ ORDERED */ distinct
3339: cbcc.cost_plus_structure, cbcc.cost_base
3340: from

Line 3375: UPDATE PA_EI_CDL_CM_GTEMP gtemp

3371: BEGIN
3372:
3373: l_eiid.delete;
3374: l_linenum.delete; /*added for the bug#5949107*/
3375: UPDATE PA_EI_CDL_CM_GTEMP gtemp
3376: set BURDEN_SUM_REJECTION_CODE = 'BCC_EXP_TYPE_NULL'
3377: WHERE BURDEN_SUM_REJECTION_CODE IS NULL
3378: and exists ( select 1 from pa_ind_cost_codes icc, pa_cost_base_cost_codes cbcc
3379: where cbcc.cost_plus_structure = gtemp.cost_plus_structure