APPS.AHL_VWP_VISITS_PUB SQL Statements

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

Line: 192

 SELECT name FROM ahl_unit_config_headers
 WHERE unit_config_header_id = c_uc_header_id;

Line: 196

 SELECT unit_config_header_id FROM ahl_unit_config_headers
 WHERE name = c_uc_name;

Line: 200

 SELECT name FROM pa_projects
 WHERE project_id = c_proj_template_id
   AND template_flag = 'Y';

Line: 226

  p_x_visit_rec.LAST_UPDATE_DATE := null;

Line: 227

  p_x_visit_rec.LAST_UPDATED_BY := null;

Line: 230

  p_x_visit_rec.LAST_UPDATE_LOGIN := null;

Line: 245

  p_x_visit_rec.SIMULATION_DELETE_FLAG := null;