DBA Data[Home] [Help]

APPS.JTF_ASSIGN_PUB dependencies on JTF_RS_SKILL_LEVELS_VL

Line 3778: jtf_rs_skill_levels_vl b

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
3782: product_id = p_inventory_item_id AND

Line 5215: jtf_rs_skill_levels_vl b

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
5219: product_id = p_inventory_item_id AND