APPS.PA_BURDEN_COSTING dependencies on PA_EI_CDL_CM_GTEMP

Line 1051: insert into PA_EI_CDL_CM_GTEMP(

1047: */
1048: /* Insert into global temp table with the Ei's selected by get_compile_cursor Bug# 5406802 */
1049: /* Modified expenditure item date for 5907315*/
1050: FORALL i in 1..l_eiid_tbl.count
1051: insert into PA_EI_CDL_CM_GTEMP(
1052: PROJECT_ID ,TASK_ID ,ORGANIZATION_ID
1053: ,PA_DATE ,PA_PERIOD_NAME ,ATTRIBUTE1
1054: ,ATTRIBUTE2 ,ATTRIBUTE3 ,ATTRIBUTE4
1055: ,ATTRIBUTE5 ,ATTRIBUTE6 ,ATTRIBUTE7

Line 3410: insert into PA_EI_CDL_CM_GTEMP(

3406: */
3407: /* Modified expenditure item date for bug 5907315*/
3408: /* Bug# 9373031: Added hint for performane issue */
3409:
3410: insert into PA_EI_CDL_CM_GTEMP(
3411: PROJECT_ID ,TASK_ID ,ORGANIZATION_ID
3412: ,PA_DATE ,PA_PERIOD_NAME ,ATTRIBUTE1
3413: ,ATTRIBUTE2 ,ATTRIBUTE3 ,ATTRIBUTE4
3414: ,ATTRIBUTE5 ,ATTRIBUTE6 ,ATTRIBUTE7

Line 3494: UPDATE PA_EI_CDL_CM_GTEMP ei

3490:
3491: IF SQL%ROWCOUNT > 0 THEN
3492:
3493: /* The sub query should return only one row, if not we have to use distinct clause*/
3494: UPDATE PA_EI_CDL_CM_GTEMP ei
3495: set (COST_PLUS_STRUCTURE ,COST_BASE) =
3496: (select /*+ ORDERED */ distinct
3497: cbcc.cost_plus_structure, cbcc.cost_base
3498: from

Line 3533: UPDATE PA_EI_CDL_CM_GTEMP gtemp

3529: BEGIN
3530:
3531: l_eiid.delete;
3532: l_linenum.delete; /*added for the bug#5949107*/
3533: UPDATE PA_EI_CDL_CM_GTEMP gtemp
3534: set BURDEN_SUM_REJECTION_CODE = 'BCC_EXP_TYPE_NULL'
3535: WHERE BURDEN_SUM_REJECTION_CODE IS NULL
3536: and exists ( select 1 from pa_ind_cost_codes icc, pa_cost_base_cost_codes cbcc
3537: where cbcc.cost_plus_structure = gtemp.cost_plus_structure