APPS.ICX_CAT_STORE_ASSIGNMENT_PKG dependencies on ICX_CAT_SHOP_STORES_B

Line 9: xStoreId ICX_CAT_SHOP_STORES_B.STORE_ID%TYPE;

5: p_contentId IN NUMBER)
6: RETURN NUMBER IS
7: xErrLoc INTEGER := 0;
8: xCount INTEGER := 0;
9: xStoreId ICX_CAT_SHOP_STORES_B.STORE_ID%TYPE;
10:
11: CURSOR store_assignments(p_contentType IN VARCHAR2,
12: p_contentId IN NUMBER) IS
13: SELECT

Line 17: icx_Cat_shop_stores_b stores

13: SELECT
14: DISTINCT stores.store_id
15: FROM
16: icx_cat_store_contents contents,
17: icx_Cat_shop_stores_b stores
18: WHERE
19: contents.content_type = p_contentType AND
20: contents.content_id = p_contentId AND
21: contents.store_id = stores.store_id;