DBA Data[Home] [Help]

APPS.HR_QSN_SHD SQL Statements

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

Line: 60

    select
    questionnaire_template_id,
  name,
  text,
  available_flag,
  business_group_id,
  object_version_number
    from  hr_questionnaires
    where  questionnaire_template_id = p_questionnaire_template_id;
Line: 136

    select   questionnaire_template_id,
  name,
  text,
  available_flag,
  business_group_id,
  object_version_number
    from  hr_questionnaires
    where  questionnaire_template_id = p_questionnaire_template_id
    for  update nowait;