SELECT DISTINCT A4M.ACCN_NO, A4M.PRJ_TITLE, MODECODE_1_DESC, MODECODE_2_DESC, MODECODE_3_DESC,v_locations.MODECODE_1, v_locations.MODECODE_2, v_locations.MODECODE_3,
v_locations.MODECODE_1 + ' ' + v_locations.MODECODE_2 + ' ' + v_locations.MODECODE_3 AS MODECODE
FROM v_locations,
a416_main
V_CLEAN_PROJECTS
A4M, a416_national_program np
WHERE
STATE_CODE = '#url.STATE_CODE#'
and np_code = #val(url.NP_CODE)#
and np_percent >= 30
and np.accn_no = A4M.accn_no
and A4M.MODECODE_1 = v_locations.MODECODE_1
and A4M.MODECODE_2 = v_locations.MODECODE_2
and A4M.MODECODE_3 = v_locations.MODECODE_3
and A4M.MODECODE_4 = v_locations.MODECODE_4
and a4m.status_code = 'a'
ORDER BY v_locations.MODECODE_1, v_locations.MODECODE_2, v_locations.MODECODE_3
select NPTitle from dbo.NPrograms
where NPNumber = #val(url.npnumber)#
#desc#
#PTITLE#
#application.bc#