APPS.JTF_RS_RESOURCE_SKILLS_PVT dependencies on JTF_RS_ITEM_CATEGORIES_V

Line 94: FROM JTF_RS_ITEM_CATEGORIES_V

90: -- Check category_id is valid
91: CURSOR category_id_cur(ll_category_id JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE)
92: IS
93: SELECT category_id
94: FROM JTF_RS_ITEM_CATEGORIES_V
95: WHERE category_id = ll_category_id
96: AND nvl(enabled_flag, 'Y') <> 'N'
97: AND trunc(sysdate) < nvl(disable_date, sysdate);
98:

Line 106: FROM JTF_RS_ITEM_CATEGORIES_V cat,

102: CURSOR category_catset_id_cur(ll_category_id JTF_RS_RESOURCE_SKILLS.CATEGORY_ID%TYPE,
103: ll_catset_id NUMBER )
104: IS
105: SELECT cat.category_id
106: FROM JTF_RS_ITEM_CATEGORIES_V cat,
107: mtl_category_set_valid_cats ic
108: WHERE cat.category_id = ll_category_id
109: AND nvl(cat.enabled_flag, 'Y') <> 'N'
110: AND trunc(sysdate) < nvl(cat.disable_date, sysdate)