DBA Data[Home] [Help]

APPS.HR_QSV_SHD SQL Statements

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

Line: 58

    select
    quest_answer_val_id,
  questionnaire_answer_id,
  field_id,
  object_version_number,
  value
    from  hr_quest_answer_values
    where  quest_answer_val_id = p_quest_answer_val_id;
Line: 133

    select   quest_answer_val_id,
  questionnaire_answer_id,
  field_id,
  object_version_number,
  value
    from  hr_quest_answer_values
    where  quest_answer_val_id = p_quest_answer_val_id
    for  update nowait;