APPS.CS_ASSIGN_RESOURCE_CON_PKG dependencies on JTF_RS_SKILL_LEVELS_VL

Line 1410: FROM jtf_rs_skill_levels_vl s,

1406: AND incident_severity_id = l_incident_severity_id;
1407:
1408: CURSOR C_PROD_SKILL(l_prod_id NUMBER,l_prod_org_id NUMBER,l_resource_id NUMBER) IS
1409: SELECT s.skill_level
1410: FROM jtf_rs_skill_levels_vl s,
1411: jtf_rs_resource_skills rs
1412: WHERE rs.resource_id = l_resource_id
1413: AND rs.product_id = l_prod_id
1414: AND rs.product_org_id = l_prod_org_id

Line 1420: FROM jtf_rs_skill_levels_vl s,

1416: -- and nvl(rs.category_id,0) = nvl(l_cat_id,0)
1417:
1418: CURSOR C_PLAT_SKILL(l_platform_id NUMBER,l_platform_org_id NUMBER,l_resource_id NUMBER) IS
1419: SELECT s.skill_level
1420: FROM jtf_rs_skill_levels_vl s,
1421: jtf_rs_resource_skills rs
1422: WHERE rs.resource_id = l_resource_id
1423: AND rs.platform_id = l_platform_id
1424: AND rs.platform_org_id = l_platform_org_id

Line 1429: FROM jtf_rs_skill_levels_vl s,

1425: AND rs.skill_level_id = s.skill_level_id;
1426:
1427: CURSOR C_PROB_SKILL(l_problem_code VARCHAR2,l_resource_id NUMBER) IS
1428: SELECT s.skill_level
1429: FROM jtf_rs_skill_levels_vl s,
1430: jtf_rs_resource_skills rs
1431: WHERE rs.resource_id = l_resource_id
1432: AND rs.problem_code = l_problem_code
1433: AND rs.skill_level_id = s.skill_level_id;

Line 1438: FROM jtf_rs_skill_levels_vl s,

1434:
1435: -- Added cursor to fetch the Category Skill for ER# 2527963.
1436: CURSOR c_cat_skill(l_category_id NUMBER, l_resource_id NUMBER) IS
1437: SELECT s.skill_level
1438: FROM jtf_rs_skill_levels_vl s,
1439: jtf_rs_resource_skills rs
1440: WHERE rs.resource_id = l_resource_id
1441: AND rs.category_id = l_category_id
1442: AND rs.skill_level_id = s.skill_level_id;