DBA Data[Home] [Help]

APPS.PA_BURDEN_COSTING dependencies on PA_IND_COST_CODES

Line 2953: pa_ind_cost_codes icc

2949: where cmt.burden_sum_source_run_id = current_run_id
2950: and cmt.project_id = current_project_id
2951: and exists (select 1
2952: from pa_compiled_multipliers cm,
2953: pa_ind_cost_codes icc
2954: where cm.ind_compiled_set_id=cmt.cmt_ind_compiled_set_id
2955: and icc.ind_cost_code = cm.ind_cost_code
2956: and icc.expenditure_type is null));
2957: exception

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