DBA Data[Home] [Help]

APPS.JTF_RS_RESOURCE_SKILLS_PUB dependencies on JTF_RS_COMPONENTS_V

Line 195: FROM jtf_rs_components_v comp

191: p_product_org_id JTF_RS_RESOURCE_SKILLS.PRODUCT_ORG_ID%TYPE,
192: p_resource_id JTF_RS_RESOURCE_SKILLS.RESOURCE_ID%TYPE)
193: IS
194: SELECT component_id
195: FROM jtf_rs_components_v comp
196: WHERE comp.product_id = p_product_id
197: AND comp.product_org_id = p_product_org_id
198: AND NOT EXISTS ( SELECT null
199: FROM jtf_rs_resource_skills skills