-- apps_master.getCustomerConfirm (PROCEDURE)
begin
SELECT * from m_customer2 c2 
	JOIN m_customer1 c1 on c2.CustomerID = c1.CustomerID 
	JOIN customer_location cl on c1.CustomerID =  cl.CustomerID
	WHERE c2.ActiveYN = 'Y' AND c2.CustomerID = customerID1;
end