chg.registration_type, 
CI_CHANGE_REGISTRATION_TYPES.WAITING.id
)