APPS.HR_TEMPLATE_WINDOW_INFO SQL Statements

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

Line: 18

    SELECT twn.template_window_id
          ,fwn.window_name
          ,wnp.height
          ,wpt.title
          ,wnp.width
          ,wnp.x_position
          ,wnp.y_position
          ,wnp.information_category
          ,wnp.information1
          ,wnp.information2
          ,wnp.information3
          ,wnp.information4
          ,wnp.information5
          ,wnp.information6
          ,wnp.information7
          ,wnp.information8
          ,wnp.information9
          ,wnp.information10
          ,wnp.information11
          ,wnp.information12
          ,wnp.information13
          ,wnp.information14
          ,wnp.information15
          ,wnp.information16
          ,wnp.information17
          ,wnp.information18
          ,wnp.information19
          ,wnp.information20
          ,wnp.information21
          ,wnp.information22
          ,wnp.information23
          ,wnp.information24
          ,wnp.information25
          ,wnp.information26
          ,wnp.information27
          ,wnp.information28
          ,wnp.information29
          ,wnp.information30
      FROM hr_window_properties_tl wpt
          ,hr_window_properties_b wnp
          ,hr_template_windows_b twn
          ,hr_form_windows_b fwn
     WHERE wpt.language (+) = userenv('LANG')
       AND wpt.window_property_id (+) = wnp.window_property_id
       AND wnp.template_window_id (+) = twn.template_window_id
       AND twn.form_window_id (+) = fwn.form_window_id
       AND twn.form_template_id (+) = p_form_template_id
       AND fwn.form_id = p_form_id
       AND fwn.application_id = p_application_id;