APPS.CS_ASSIGN_RESOURCE_CON_PKG dependencies on JTF_RS_RESOURCE_SKILLS

Line 1504: jtf_rs_resource_skills rs

1500:
1501: CURSOR C_PROD_SKILL(l_prod_id NUMBER,l_prod_org_id NUMBER,l_resource_id NUMBER) IS
1502: SELECT s.skill_level
1503: FROM jtf_rs_skill_levels_vl s,
1504: jtf_rs_resource_skills rs
1505: WHERE rs.resource_id = l_resource_id
1506: AND rs.product_id = l_prod_id
1507: AND rs.product_org_id = l_prod_org_id
1508: AND rs.skill_level_id = s.skill_level_id;

Line 1514: jtf_rs_resource_skills rs

1510:
1511: CURSOR C_PLAT_SKILL(l_platform_id NUMBER,l_platform_org_id NUMBER,l_resource_id NUMBER) IS
1512: SELECT s.skill_level
1513: FROM jtf_rs_skill_levels_vl s,
1514: jtf_rs_resource_skills rs
1515: WHERE rs.resource_id = l_resource_id
1516: AND rs.platform_id = l_platform_id
1517: AND rs.platform_org_id = l_platform_org_id
1518: AND rs.skill_level_id = s.skill_level_id;

Line 1523: jtf_rs_resource_skills rs

1519:
1520: CURSOR C_PROB_SKILL(l_problem_code VARCHAR2,l_resource_id NUMBER) IS
1521: SELECT s.skill_level
1522: FROM jtf_rs_skill_levels_vl s,
1523: jtf_rs_resource_skills rs
1524: WHERE rs.resource_id = l_resource_id
1525: AND rs.problem_code = l_problem_code
1526: AND rs.skill_level_id = s.skill_level_id;
1527:

Line 1532: jtf_rs_resource_skills rs

1528: -- Added cursor to fetch the Category Skill for ER# 2527963.
1529: CURSOR c_cat_skill(l_category_id NUMBER, l_resource_id NUMBER) IS
1530: SELECT s.skill_level
1531: FROM jtf_rs_skill_levels_vl s,
1532: jtf_rs_resource_skills rs
1533: WHERE rs.resource_id = l_resource_id
1534: AND rs.category_id = l_category_id
1535: AND rs.skill_level_id = s.skill_level_id;
1536: