APPS.HR_TMPLT SQL Statements

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

Line: 14

      select full_item_name
      into l_return
      from hr_form_items_b
      where form_item_id = p_item_id
      and application_id = p_application_id
      and form_id = p_form_id;

Line: 30

      select formula_name
      into l_return
      from ff_formulas_f
      where formula_id = p_formula_id
      and sysdate between effective_start_date and effective_end_date;

Line: 44

    SELECT
      ff.formula_name
    FROM
      pay_status_processing_rules_f pspr,
      ff_formulas_f ff
    WHERE
      pspr.element_type_id = p_element_type_id AND
      p_effective_date BETWEEN pspr.effective_start_date AND
                               pspr.effective_end_date AND
      pspr.formula_id = ff.formula_id AND
      p_effective_date BETWEEN ff.effective_start_date AND
                               ff.effective_end_date;

Line: 78

      select legislation_code
      into l_leg_code
      from ff_formulas_f
      where formula_id = p_formula_id
      and sysdate between effective_start_date and effective_end_date;

Line: 87

        select territory_short_name
        into l_return
        from fnd_territories_vl
        where territory_code = l_leg_code;

Line: 102

      select business_group_id
      into l_bus_group_id
      from ff_formulas_f
      where formula_id = p_formula_id
      and sysdate between effective_start_date and effective_end_date;

Line: 111

        select name
        into l_return
        from per_business_groups
        where business_group_id = l_bus_group_id;

Line: 129

      select tab_page_name
      into l_return
      from hr_form_tab_pages_b
      where form_tab_page_id = p_form_tab_page_id
      and form_canvas_id = p_form_canvas_id;

Line: 146

      select template_name
      into l_return
      from hr_form_templates_b
      where form_template_id = p_form_template_id;

Line: 163

      select application_short_name
      into l_return
      from hr_form_templates_b hft,
           fnd_application fa
      where hft.form_template_id = p_form_template_id
      and fa.application_id = hft.application_id;

Line: 182

      select form_name
      into l_return
      from hr_form_templates_b hft,
           fnd_form ff
      where hft.form_template_id = p_form_template_id
      and ff.application_id = hft.application_id
      and ff.form_id = hft.form_id;

Line: 200

   IS SELECT
     bcf.category_name
   FROM
     pay_balance_categories_f bcf
   WHERE
     bcf.balance_category_id = p_category_id AND
     SYSDATE BETWEEN bcf.effective_start_date AND
                     bcf.effective_end_date;