APPS.CS_ASSIGN_RESOURCE_CON_PKG dependencies on JTF_RS_SKILL_LEVELS_VL

Line 1503: FROM jtf_rs_skill_levels_vl s,

1499: AND incident_severity_id = l_incident_severity_id;
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

Line 1513: FROM jtf_rs_skill_levels_vl s,

1509: -- and nvl(rs.category_id,0) = nvl(l_cat_id,0)
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

Line 1522: FROM jtf_rs_skill_levels_vl s,

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

Line 1531: FROM jtf_rs_skill_levels_vl s,

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