APPS.HR_QSA_BUS SQL Statements

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

Line: 28

    select inf.org_information14
      from hr_organization_information inf
         , hr_quest_answers                qsa
     where qsa.questionnaire_answer_id = p_questionnaire_answer_id
       and inf.organization_id   = qsa.business_group_id
       and inf.org_information_context || '' = 'Business Group Information';

Line: 120

    select business_group_id
      from hr_questionnaires qsn
     where qsn.questionnaire_template_id = p_questionnaire_template_id;

Line: 128

    select null
      from per_appraisal_templates pat,
     per_appraisals pa
     where p_questionnaire_template_id = pat.questionnaire_template_id
       and p_type_object_id = pa.appraisal_id
       and pa.appraisal_template_id = pat.appraisal_template_id;

Line: 267

     select business_group_id
       from per_appraisals pa
      where p_type_object_id = pa.appraisal_id;

Line: 275

     select business_group_id, participation_in_table, participation_in_column
       from per_participants pp
      where p_type_object_id = pp.participant_id;

Line: 283

    select null
      from hr_quest_answers qsa
     where qsa.type_object_id = p_type_object_id
       and qsa.type = p_type;

Line: 385

procedure chk_row_delete
  (p_questionnaire_answer_id
    in  hr_quest_answers.questionnaire_answer_id%TYPE
  )
  is
  --
  l_proc   varchar2(72) := g_package || 'chk_row_delete';

Line: 397

    select null
      from hr_quest_answer_values qsv
     where qsv.questionnaire_answer_id = p_questionnaire_answer_id;

Line: 424

end chk_row_delete;

Line: 429

Procedure insert_validate(p_rec in hr_qsa_shd.g_rec_type
       ,p_effective_date in date
       ) is
--
  l_proc  varchar2(72) := g_package||'insert_validate';

Line: 459

End insert_validate;

Line: 464

Procedure update_validate(p_rec in hr_qsa_shd.g_rec_type
       ,p_effective_date in date) is
--
  l_proc  varchar2(72) := g_package||'update_validate';

Line: 477

End update_validate;

Line: 482

Procedure delete_validate(p_rec in hr_qsa_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'delete_validate';

Line: 491

  chk_row_delete(p_questionnaire_answer_id
      => p_rec.questionnaire_answer_id);

Line: 495

End delete_validate;

Line: 508

    select pbg.legislation_code
      from per_business_groups pbg
         , hr_quest_answers qsa
     where qsa.questionnaire_answer_id = p_questionnaire_answer_id
       and pbg.business_group_id = qsa.business_group_id;