APPS.AMS_DIALOG_REGS_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 68

   select attendant_contact_id,
          system_status_code
   from ams_event_registrations
   where confirmation_code = p_confirmation_code;

Line: 233

   select system_status_code
   from ams_event_registrations
   where confirmation_code = p_confirmation_code;

Line: 294

   x_reg_det_rec.last_update_date := p_reg_det_rec.last_update_date;

Line: 295

   x_reg_det_rec.last_updated_by := p_reg_det_rec.last_updated_by;

Line: 298

   x_reg_det_rec.last_update_login := p_reg_det_rec.last_update_login;

Line: 455

   x_reg_det_rec.update_reg_rec := p_reg_det_rec.update_reg_rec;