APPS.INV_ITEM_CATEGORY_PUB dependencies on DUAL

Line 1605: FROM dual;

1601: l_sys_date DATE := Sysdate;
1602:
1603: CURSOR new_category_id IS
1604: SELECT mtl_categories_s.nextval
1605: FROM dual;
1606: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1607: BEGIN
1608: -- Standard Start of API savepoint
1609: SAVEPOINT Create_Category_PUB;

Line 2166: FROM dual

2162: l_valid_category_exists VARCHAR(1);
2163:
2164: CURSOR category_assignment_exists(p_category_id NUMBER) IS
2165: SELECT 'x'
2166: FROM dual
2167: WHERE exists
2168: ( SELECT category_id
2169: FROM mtl_item_categories
2170: WHERE category_id = p_category_id

Line 2175: FROM dual

2171: );
2172:
2173: CURSOR default_category_exists(p_category_id NUMBER) IS
2174: SELECT 'x'
2175: FROM dual
2176: WHERE exists
2177: ( SELECT default_category_id
2178: FROM mtl_category_sets_b
2179: WHERE default_category_id = p_category_id

Line 2185: FROM dual

2181:
2182:
2183: CURSOR valid_category_exists(p_category_id NUMBER) IS
2184: SELECT 'x'
2185: FROM dual
2186: WHERE exists
2187: ( SELECT category_id
2188: FROM mtl_category_set_valid_cats
2189: WHERE category_id = p_category_id