DBA Data[Home] [Help]

APPS.JTF_RS_RESOURCE_SKILLS_PUB dependencies on JTF_RS_PRODUCTS_V

Line 420: FROM jtf_rs_products_v a

416: CURSOR unrated_product_curr( p_category_id JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE,
417: p_resource_id JTF_RS_RESOURCE_SKILLS.RESOURCE_ID%TYPE)
418: IS
419: SELECT a.product_id
420: FROM jtf_rs_products_v a
421: WHERE a.product_org_id = p_product_org_id
422: AND nvl(a.enabled_flag, 'Y') <> 'N'
423: AND EXISTS(SELECT null
424: FROM mtl_item_categories c