APPS.ICX_CAT_SQE_PVT dependencies on ICX_CAT_ZONE_SECURE_ATTRIBUTES

Line 821: FROM icx_cat_zone_secure_attributes

817: l_err_loc := 300;
818: -- now get all the categories for that zone
819: SELECT ip_category_id
820: BULK COLLECT INTO l_category_ids
821: FROM icx_cat_zone_secure_attributes
822: WHERE zone_id = l_content_zone_ids(i)
823: AND securing_attribute = 'CATEGORY';
824:
825: l_err_loc := 400;

Line 829: FROM icx_cat_zone_secure_attributes

825: l_err_loc := 400;
826: -- now get all the suppliers and sites for that zone
827: SELECT supplier_id, supplier_site_id
828: BULK COLLECT INTO l_supplier_ids, l_supplier_site_ids
829: FROM icx_cat_zone_secure_attributes
830: WHERE zone_id = l_content_zone_ids(i)
831: AND securing_attribute = 'SUPPLIER';
832:
833: l_err_loc := 450;

Line 1113: FROM icx_cat_zone_secure_attributes

1109: l_err_loc := 300;
1110: -- now get all the categories for that zone
1111: SELECT ip_category_id
1112: BULK COLLECT INTO l_category_ids
1113: FROM icx_cat_zone_secure_attributes
1114: WHERE zone_id = l_content_zone_ids(i)
1115: AND securing_attribute = 'CATEGORY';
1116:
1117: l_err_loc := 400;

Line 1121: FROM icx_cat_zone_secure_attributes

1117: l_err_loc := 400;
1118: -- now get all the suppliers and sites for that zone
1119: SELECT supplier_id, supplier_site_id
1120: BULK COLLECT INTO l_supplier_ids, l_supplier_site_ids
1121: FROM icx_cat_zone_secure_attributes
1122: WHERE zone_id = l_content_zone_ids(i)
1123: AND securing_attribute = 'SUPPLIER';
1124:
1125: l_err_loc := 450;