ALTER   proc [dbo].[CM_ATTACH_FILE_By_RefMaster] @p_REF_MASTER varchar(15)
AS
BEGIN
	select A. * from CM_ATTACH_FILE A where
	1=1
	AND (A.REF_MASTER = @p_REF_MASTER OR A.REF_ID = @p_REF_MASTER)
	AND ((A.[TYPE] IN ('TR_CONTRACT','TR_REQUEST_DOC_FILE','PL_REQUEST_DOC_FILE') AND
			(A.REF_ID IN (SELECT TR_REQUEST_DOC_FILE_ID FROM TR_REQUEST_DOC_FILE WHERE REQ_ID =@p_REF_MASTER) OR A.REF_ID IN (SELECT PL_REQUEST_DOC_FILE_ID FROM PL_REQUEST_DOC_FILE WHERE REQ_ID =@p_REF_MASTER)))
			OR (A.TYPE NOT IN ('TR_CONTRACT','TR_REQUEST_DOC_FILE','PL_REQUEST_DOC_FILE')))

END