DBA Data[Home] [Help]

APPS.PA_BURDEN_COSTING dependencies on PA_COST_BASE_COST_CODES

Line 3501: PA_COST_BASE_COST_CODES CBCC

3497: cbcc.cost_plus_structure, cbcc.cost_base
3498: from
3499: PA_COST_BASE_EXP_TYPES CBET,
3500: PA_COMPILED_MULTIPLIERS CM,
3501: PA_COST_BASE_COST_CODES CBCC
3502: WHERE cbet.expenditure_type = ei.ei_expenditure_type
3503: AND cbet.cost_base_type = 'INDIRECT COST'
3504: AND cm.ind_Compiled_set_id = ei.ind_compiled_set_id
3505: AND cm.cost_base = cbet.cost_base

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

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
3538: and cbcc.cost_base = gtemp.cost_base
3539: and cbcc.cost_base_type = 'INDIRECT COST'
3540: and cbcc.ind_cost_code = icc.ind_cost_code