DBA Data[Home] [Help]

APPS.JTF_ASSIGN_PUB dependencies on JTF_RS_SKILL_LEVELS_VL

Line 3815: jtf_rs_skill_levels_vl b

3811:
3812: CURSOR cur_resource_skills (p_res_id NUMBER) IS
3813: SELECT skill_level, level_name
3814: FROM jtf_rs_resource_skills a,
3815: jtf_rs_skill_levels_vl b
3816: WHERE a.skill_level_id = b.skill_level_id AND
3817: a.resource_id = p_res_id AND
3818: (category_id = p_category_id OR category_id IS NULL) AND
3819: product_id = p_inventory_item_id AND

Line 5279: jtf_rs_skill_levels_vl b

5275:
5276: CURSOR cur_resource_skills (p_res_id NUMBER) IS
5277: SELECT skill_level, level_name
5278: FROM jtf_rs_resource_skills a,
5279: jtf_rs_skill_levels_vl b
5280: WHERE a.skill_level_id = b.skill_level_id AND
5281: a.resource_id = p_res_id AND
5282: (category_id = p_category_id OR category_id IS NULL) AND
5283: product_id = p_inventory_item_id AND