APPS.JTF_RS_RESOURCE_SKILLS_PVT dependencies on JTF_RS_PRODUCTS_V

Line 131: FROM JTF_RS_PRODUCTS_V

127: CURSOR product_id_cur(ll_product_id JTF_RS_RESOURCE_SKILLS.PRODUCT_ID%TYPE,
128: ll_product_org_id JTF_RS_RESOURCE_SKILLS.product_org_id%TYPE)
129: IS
130: SELECT product_id
131: FROM JTF_RS_PRODUCTS_V
132: WHERE product_id = ll_product_id
133: AND product_org_id = ll_product_org_id
134: AND enabled_flag = 'Y';
135:

Line 145: FROM JTF_RS_PRODUCTS_V p

141: lpco_category_id JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE,
142: lpco_product_org_id JTF_RS_RESOURCE_SKILLS.product_org_id%TYPE)
143: IS
144: SELECT p.product_id
145: FROM JTF_RS_PRODUCTS_V p
146: WHERE p.product_id = lpco_product_id
147: AND p.product_org_id = lpco_product_org_id
148: AND p.enabled_flag = 'Y'
149: AND EXISTS ( SELECT null FROM MTL_ITEM_CATEGORIES c