APPS.CS_ASSIGN_RESOURCE_PKG dependencies on JTF_RS_SKILL_LEVELS_VL

Line 1228: FROM jtf_rs_skill_levels_vl s,

1224: -- Removed the Category Filter as Category is another qualifier.
1225: CURSOR c_prod_skill(l_prod_id NUMBER,l_prod_org_id NUMBER,l_resource_id NUMBER
1226: ) IS
1227: SELECT s.skill_level
1228: FROM jtf_rs_skill_levels_vl s,
1229: jtf_rs_resource_skills rs
1230: WHERE rs.resource_id = l_resource_id
1231: AND rs.product_id = l_prod_id
1232: AND rs.product_org_id = l_prod_org_id

Line 1239: FROM jtf_rs_skill_levels_vl s,

1235:
1236: CURSOR c_plat_skill(l_platform_id NUMBER,l_platform_org_id NUMBER,
1237: l_resource_id NUMBER) IS
1238: SELECT s.skill_level
1239: FROM jtf_rs_skill_levels_vl s,
1240: jtf_rs_resource_skills rs
1241: WHERE rs.resource_id = l_resource_id
1242: AND rs.platform_id = l_platform_id
1243: AND rs.platform_org_id = l_platform_org_id

Line 1248: FROM jtf_rs_skill_levels_vl s,

1244: AND rs.skill_level_id = s.skill_level_id;
1245:
1246: CURSOR c_prob_skill(l_problem_code VARCHAR2,l_resource_id NUMBER) IS
1247: SELECT s.skill_level
1248: FROM jtf_rs_skill_levels_vl s,
1249: jtf_rs_resource_skills rs
1250: WHERE rs.resource_id = l_resource_id
1251: AND rs.problem_code = l_problem_code
1252: AND rs.skill_level_id = s.skill_level_id;

Line 1256: FROM jtf_rs_skill_levels_vl s,

1252: AND rs.skill_level_id = s.skill_level_id;
1253:
1254: CURSOR c_cat_skill(l_category_id NUMBER, l_resource_id NUMBER) IS
1255: SELECT s.skill_level
1256: FROM jtf_rs_skill_levels_vl s,
1257: jtf_rs_resource_skills rs
1258: WHERE rs.resource_id = l_resource_id
1259: AND rs.category_id = l_category_id
1260: AND rs.skill_level_id = s.skill_level_id;