APPS.JTF_ASSIGN_PUB dependencies on JTF_RS_RESOURCE_SKILLS

Line 3777: FROM jtf_rs_resource_skills a,

3773:
3774:
3775: CURSOR cur_resource_skills (p_res_id NUMBER) IS
3776: SELECT skill_level, level_name
3777: FROM jtf_rs_resource_skills a,
3778: jtf_rs_skill_levels_vl b
3779: WHERE a.skill_level_id = b.skill_level_id AND
3780: a.resource_id = p_res_id AND
3781: (category_id = p_category_id OR category_id IS NULL) AND

Line 5214: FROM jtf_rs_resource_skills a,

5210:
5211:
5212: CURSOR cur_resource_skills (p_res_id NUMBER) IS
5213: SELECT skill_level, level_name
5214: FROM jtf_rs_resource_skills a,
5215: jtf_rs_skill_levels_vl b
5216: WHERE a.skill_level_id = b.skill_level_id AND
5217: a.resource_id = p_res_id AND
5218: (category_id = p_category_id OR category_id IS NULL) AND