APPS.INV_ITEM_CATEGORY_PUB dependencies on DUAL

Line 1586: FROM dual;

1582: l_sys_date DATE := Sysdate;
1583:
1584: CURSOR new_category_id IS
1585: SELECT mtl_categories_s.nextval
1586: FROM dual;
1587: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1588: BEGIN
1589: -- Standard Start of API savepoint
1590: SAVEPOINT Create_Category_PUB;

Line 2147: FROM dual

2143: l_valid_category_exists VARCHAR(1);
2144:
2145: CURSOR category_assignment_exists(p_category_id NUMBER) IS
2146: SELECT 'x'
2147: FROM dual
2148: WHERE exists
2149: ( SELECT category_id
2150: FROM mtl_item_categories
2151: WHERE category_id = p_category_id

Line 2156: FROM dual

2152: );
2153:
2154: CURSOR default_category_exists(p_category_id NUMBER) IS
2155: SELECT 'x'
2156: FROM dual
2157: WHERE exists
2158: ( SELECT default_category_id
2159: FROM mtl_category_sets_b
2160: WHERE default_category_id = p_category_id

Line 2166: FROM dual

2162:
2163:
2164: CURSOR valid_category_exists(p_category_id NUMBER) IS
2165: SELECT 'x'
2166: FROM dual
2167: WHERE exists
2168: ( SELECT category_id
2169: FROM mtl_category_set_valid_cats
2170: WHERE category_id = p_category_id