-- apps_master.getDataSessionHA (PROCEDURE)
begin
SELECT * FROM apps_master.m_user1 u 
JOIN apps_master.m_role r ON u.RoleID = r.RoleID
WHERE 	r.RoleName = 'HA' AND
	u.UserName = nip AND
	u.UserPassword = userPassword1 AND 
	u.ActiveYN = 'Y';
end