eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_FORM_TEMPLATE_INFO SQL Statements

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

Line: 23


    SELECT tmp.form_template_id
          ,tmp.application_id
          ,tmp.form_id
          ,tmp.template_name
          ,tmp.legislation_code
          ,tmp.enabled_flag
          ,tmp.help_target
          ,tmp.information_category
          ,tmp.information1
          ,tmp.information2
          ,tmp.information3
          ,tmp.information4
          ,tmp.information5
          ,tmp.information6
          ,tmp.information7
          ,tmp.information8
          ,tmp.information9
          ,tmp.information10
          ,tmp.information11
          ,tmp.information12
          ,tmp.information13
          ,tmp.information14
          ,tmp.information15
          ,tmp.information16
          ,tmp.information17
          ,tmp.information18
          ,tmp.information19
          ,tmp.information20
          ,tmp.information21
          ,tmp.information22
          ,tmp.information23
          ,tmp.information24
          ,tmp.information25
          ,tmp.information26
          ,tmp.information27
          ,tmp.information28
          ,tmp.information29
          ,tmp.information30
      FROM hr_form_templates tmp
     WHERE tmp.form_template_id = p_form_template_id;

Line: 133


    SELECT tmp.form_template_id
      FROM hr_form_templates_b tmp
     WHERE tmp.application_id = p_application_id
       AND tmp.form_id = p_form_id
       AND tmp.template_name = p_template_name
       AND (  tmp.legislation_code = p_legislation_code
           OR (   tmp.legislation_code IS NULL
              AND p_legislation_code IS NULL));

Line: 147


    SELECT tmp.form_template_id
      FROM hr_form_templates_b tmp
     WHERE tmp.application_id = p_application_id
       AND tmp.form_id = p_form_id
       AND tmp.template_name = p_template_name
       AND tmp.legislation_code IS NULL;

Line: 228


    SELECT fnc.application_id
          ,fnc.form_id
      FROM fnd_form_functions fnc
     WHERE fnc.function_name = p_function_name;