APPS.CCT_JTFRESOURCEROUTING_PUB dependencies on PER_COMPETENCES

Line 41: per_competences comp

37: jtf_rs_roles_b roles
38: where res.resource_id in
39: ((SELECT DISTINCT comp_ele.person_id
40: FROM per_competence_elements comp_ele,
41: per_competences comp
42: WHERE (upper(comp_ele.competence_type) = upper(p_competency_type) and
43: upper(comp.name) = upper(p_competency_name) and
44: comp.competence_id = comp_ele.competence_id)))
45: and res.resource_id=res_roles.role_resource_id