APPS.ICX_CAT_SQE_PVT dependencies on ICX_CAT_CONTENT_ZONES_TL

Line 819: FROM icx_cat_content_zones_b zones, icx_cat_content_zones_tl zonestl

815: SELECT zones.zone_id, zonestl.name, supplier_attribute_action_flag, category_attribute_action_flag,
816: items_without_supplier_flag, items_without_shop_catg_flag, sqe_sequence
817: BULK COLLECT INTO l_content_zone_ids, l_content_zone_names, l_supplier_attr_action_flags,
818: l_category_attr_action_flags, l_items_without_supplier_flags, l_items_without_shop_cat_flags, l_sqe_sequences
819: FROM icx_cat_content_zones_b zones, icx_cat_content_zones_tl zonestl
820: WHERE zones.type = 'LOCAL'
821: AND zones.category_attribute_action_flag IN ('INCLUDE', 'EXCLUDE')
822: AND zones.zone_id = zonestl.zone_id
823: AND zonestl.language = USERENV('LANG');

Line 1112: FROM icx_cat_content_zones_b zones, icx_cat_content_zones_tl zonestl

1108: SELECT zones.zone_id, zonestl.name, supplier_attribute_action_flag, category_attribute_action_flag,
1109: items_without_supplier_flag, items_without_shop_catg_flag, sqe_sequence
1110: BULK COLLECT INTO l_content_zone_ids, l_content_zone_names, l_supplier_attr_action_flags,
1111: l_category_attr_action_flags, l_items_without_supplier_flags, l_items_without_shop_cat_flags, l_sqe_sequences
1112: FROM icx_cat_content_zones_b zones, icx_cat_content_zones_tl zonestl
1113: WHERE zones.type = 'LOCAL'
1114: AND zones.zone_id = zonestl.zone_id
1115: AND zonestl.language = USERENV('LANG');
1116: