DBA Data[Home] [Help]

APPS.PA_BURDEN_COSTING dependencies on PA_COST_BASE_COST_CODES

Line 3343: PA_COST_BASE_COST_CODES CBCC

3339: cbcc.cost_plus_structure, cbcc.cost_base
3340: from
3341: PA_COST_BASE_EXP_TYPES CBET,
3342: PA_COMPILED_MULTIPLIERS CM,
3343: PA_COST_BASE_COST_CODES CBCC
3344: WHERE cbet.expenditure_type = ei.ei_expenditure_type
3345: AND cbet.cost_base_type = 'INDIRECT COST'
3346: AND cm.ind_Compiled_set_id = ei.ind_compiled_set_id
3347: AND cm.cost_base = cbet.cost_base

Line 3378: and exists ( select 1 from pa_ind_cost_codes icc, pa_cost_base_cost_codes cbcc

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
3380: and cbcc.cost_base = gtemp.cost_base
3381: and cbcc.cost_base_type = 'INDIRECT COST'
3382: and cbcc.ind_cost_code = icc.ind_cost_code