APPS.CS_ASSIGN_RESOURCE_CON_PKG dependencies on JTF_RS_RESOURCE_SKILLS

Line 1411: jtf_rs_resource_skills rs

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
1415: AND rs.skill_level_id = s.skill_level_id;

Line 1421: jtf_rs_resource_skills rs

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
1425: AND rs.skill_level_id = s.skill_level_id;

Line 1430: jtf_rs_resource_skills rs

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;
1434:

Line 1439: jtf_rs_resource_skills rs

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;
1443: