APPS.JTF_AM_FILTER_RESOURCE_PVT SQL Statements

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

Line: 24

  SELECT r1.rule_id
         , r1.product_id_passed
         , r1.category_id_passed
         , r1.problem_code_passed
         , r1.component_id_passed
    FROM jtf_am_skill_rules r1
   WHERE r1.document_type = l_document_type
     AND r1.product_id_passed    = l_product_id_passed
     AND r1.category_id_passed   = l_category_id_passed
     AND r1.problem_code_passed = l_problem_code_passed
     AND r1.component_id_passed = l_component_id_passed
     AND r1.active_flag = 'Y';

Line: 41

  SELECT sk.detail_id
         , sk.check_product_id
         , sk.check_problem_code
         , sk.check_category_id
         , sk.check_component_id
    FROM jtf_am_skill_rule_dtls  sk
   WHERE sk.rule_id = l_rule_id
     AND sk.active_flag = 'Y'
   ORDER BY rank;

Line: 95

   l_stmt_more := 'SELECT  s.skill_level , s.level_name '||
                   ' FROM  jtf_rs_resource_skills r, jtf_rs_skill_levels_vl s ' ||
                  ' WHERE  r.skill_level_id = s.skill_level_id '||
                   '  AND  r.resource_id   = :x_resource_id ';

Line: 143

        bind_table.delete;

Line: 356

       x_assign_resources_tbl.delete;

Line: 511

        l_resource_id.delete;

Line: 512

        l_resource_type.delete;

Line: 558

      x_assign_resources_tbl.delete;