APPS.ICX_CAT_STORE_ASSIGNMENT_PKG dependencies on ICX_CAT_STORE_CONTENTS

Line 16: icx_cat_store_contents contents,

12: p_contentId IN NUMBER) IS
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

Line 57: icx_cat_store_contents contents,

53: p_contentId IN NUMBER) IS
54: SELECT
55: DISTINCT name
56: FROM
57: icx_cat_store_contents contents,
58: icx_Cat_shop_stores_vl stores
59: WHERE
60: contents.content_type = p_contentType AND
61: contents.content_id = p_contentId AND