DBA Data[Home] [Help]

APPS.PA_BURDEN_COSTING dependencies on PA_IND_COST_CODES

Line 2809: pa_ind_cost_codes icc

2805: where cmt.burden_sum_source_run_id = current_run_id
2806: and cmt.project_id = current_project_id
2807: and exists (select 1
2808: from pa_compiled_multipliers cm,
2809: pa_ind_cost_codes icc
2810: where cm.ind_compiled_set_id=cmt.cmt_ind_compiled_set_id
2811: and icc.ind_cost_code = cm.ind_cost_code
2812: and icc.expenditure_type is null));
2813: exception

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