AND ((P.NCG_FIS_MGR IN ('H', 'I')))

##</code><code>##

$sub_name_for_codes =~ s/AND \(\(P.NCG_FIS_MGR IN \('.*'\)\)\) / 
                         AND Fiscal Manager Name like $fis_mgr_name_value /g;

##</code><code>##

AND P.PROJECT_ID IN ('521590', '529302', '529808', '528230') AND I.NC_NAME LIKE 'Thom%'

##</code><code>##

$sub_name_for_codes =~ s/AND P.PROJECT_ID IN \('.*'\) AND I.NC_NAME LIKE / 
                         AND Investigator like /g;