-- pelapak_external.upOwnerNoPhoto (PROCEDURE)
BEGIN
UPDATE  m_user1, m_user3
	SET m_user1.UserFullName = fullname,
	m_user3.UserGender = gender,
	m_user1.UserPhone = phone,
	m_user3.UserDOB = dob,
	m_user1.UserEmail = email,
	m_user1.lastUpdated = NOW(),
	m_user3.lastUpdated = NOW(),
	m_user1.activeYN = 'Y',
	m_user3.activeYN = 'Y',
	m_user1.UpdatedBy = updatedBy1,
	m_user3.UpdatedBy = updatedBy1
	WHERE
	m_user1.UserID = m_user3.UserID AND
	m_user1.UserID = updatedBy1;
END