APPS.CS_ASSIGN_RESOURCE_PKG dependencies on JTF_RS_SKILL_LEVELS_VL

Line 1435: FROM jtf_rs_skill_levels_vl s,

1431: -- Removed the Category Filter as Category is another qualifier.
1432: CURSOR c_prod_skill(l_prod_id NUMBER,l_prod_org_id NUMBER,l_resource_id NUMBER
1433: ) IS
1434: SELECT s.skill_level
1435: FROM jtf_rs_skill_levels_vl s,
1436: jtf_rs_resource_skills rs
1437: WHERE rs.resource_id = l_resource_id
1438: AND rs.product_id = l_prod_id
1439: AND rs.product_org_id = l_prod_org_id

Line 1446: FROM jtf_rs_skill_levels_vl s,

1442:
1443: CURSOR c_plat_skill(l_platform_id NUMBER,l_platform_org_id NUMBER,
1444: l_resource_id NUMBER) IS
1445: SELECT s.skill_level
1446: FROM jtf_rs_skill_levels_vl s,
1447: jtf_rs_resource_skills rs
1448: WHERE rs.resource_id = l_resource_id
1449: AND rs.platform_id = l_platform_id
1450: AND rs.platform_org_id = l_platform_org_id

Line 1455: FROM jtf_rs_skill_levels_vl s,

1451: AND rs.skill_level_id = s.skill_level_id;
1452:
1453: CURSOR c_prob_skill(l_problem_code VARCHAR2,l_resource_id NUMBER) IS
1454: SELECT s.skill_level
1455: FROM jtf_rs_skill_levels_vl s,
1456: jtf_rs_resource_skills rs
1457: WHERE rs.resource_id = l_resource_id
1458: AND rs.problem_code = l_problem_code
1459: AND rs.skill_level_id = s.skill_level_id;

Line 1463: FROM jtf_rs_skill_levels_vl s,

1459: AND rs.skill_level_id = s.skill_level_id;
1460:
1461: CURSOR c_cat_skill(l_category_id NUMBER, l_resource_id NUMBER) IS
1462: SELECT s.skill_level
1463: FROM jtf_rs_skill_levels_vl s,
1464: jtf_rs_resource_skills rs
1465: WHERE rs.resource_id = l_resource_id
1466: AND rs.category_id = l_category_id
1467: AND rs.skill_level_id = s.skill_level_id;