450: Select 'Y'
451: INTO l_error_flag
452: From Dual
453: Where Exists (Select null
454: from pa_cost_base_cost_codes icc
455: ,pa_cost_base_exp_types exp
456: ,pa_cost_bases base
457: where icc.cost_base = exp.cost_base
458: and icc.cost_plus_structure = exp.cost_plus_structure
464: and icc.cost_base_type = 'INDIRECT COST') ;
465: */
466: Select count(*)
467: INTO l_cwkbdCount
468: from pa_cost_base_cost_codes icc
469: ,pa_cost_base_exp_types exp
470: ,pa_cost_bases base
471: where icc.cost_base = exp.cost_base
472: and icc.cost_plus_structure = exp.cost_plus_structure