APPS.CS_ASSIGN_RESOURCE_PKG dependencies on JTF_RS_RESOURCE_SKILLS

Line 1436: jtf_rs_resource_skills rs

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
1440: --AND NVL(rs.category_id,0) = NVL(l_cat_id,0)

Line 1447: jtf_rs_resource_skills rs

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

Line 1456: jtf_rs_resource_skills rs

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

Line 1464: jtf_rs_resource_skills rs

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