APPS.HR_QSF_SHD SQL Statements

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

Line: 59

    select
    field_id,
  questionnaire_template_id,
  name,
  type,
  html_text,
  sql_required_flag,
  sql_text,
  object_version_number
  ,validation_type
  ,validation_detail
  ,display_sequence
    from  hr_quest_fields
    where  field_id = p_field_id;

Line: 140

    select   field_id,
  questionnaire_template_id,
  name,
  type,
  html_text,
  sql_required_flag,
  sql_text,
  object_version_number
  ,validation_type
  ,validation_detail
  ,display_sequence
    from  hr_quest_fields
    where  field_id = p_field_id
    for  update nowait;