APPS.JTF_RS_SKILLS_REPORT_PUB SQL Statements

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

Line: 20

    select group_name
    from jtf_rs_groups_vl
    where group_id = l_group_id;

Line: 25

    select resource_id
    from jtf_rs_group_members
    where group_id = l_group_id;

Line: 43

    select resource_id ,level
    from jtf_rs_resource_extns
    where level > 1
    connect by source_mgr_id = prior source_id
    start with resource_id = l_resource_id;

Line: 52

    select resource_name
    from jtf_rs_resource_extns_vl
    where resource_id = l_resource_id;

Line: 134

      select fnl.meaning skill_type, rsl.level_name, rsk.category_id, rsk.component_id,
             rsk.subcategory, rsk.problem_code, rsk.product_id, rsk.platform_id
      from fnd_lookups fnl, jtf_rs_resource_skills rsk,
           jtf_rs_skill_levels_vl rsl
      where lookup_type      = 'JTF_RS_SKILL_CAT_TYPE'
      and rsk.subcategory    = lookup_code
      and rsk.skill_level_id = rsl.skill_level_id
      and rsk.resource_id    = p_resource_id;

Line: 146

      select resource_name, resource_number
      from jtf_rs_resource_extns_vl
      where resource_id = p_resource_id;

Line: 151

      select problem_name
      from jtf_rs_problem_codes_v
      where problem_code = l_problem_code;

Line: 156

      select platform_name
      from jtf_rs_platforms_v
      where platform_id = l_platform_id;

Line: 161

      select product_name
      from jtf_rs_products_v
      where product_id = l_product_id;

Line: 166

      select category_name
      from jtf_rs_item_categories_v
      where category_id = l_category_id;

Line: 171

      select component_name
      from jtf_rs_components_v
      where component_id = l_component_id;