APPS.ICX_CAT_SQE_PVT dependencies on ICX_CAT_ZONE_SECURE_ATTRIBUTES

Line 832: FROM icx_cat_zone_secure_attributes

828: l_err_loc := 300;
829: -- now get all the categories for that zone
830: SELECT ip_category_id
831: BULK COLLECT INTO l_category_ids
832: FROM icx_cat_zone_secure_attributes
833: WHERE zone_id = l_content_zone_ids(i)
834: AND securing_attribute = 'CATEGORY';
835:
836: l_err_loc := 400;

Line 840: FROM icx_cat_zone_secure_attributes

836: l_err_loc := 400;
837: -- now get all the suppliers and sites for that zone
838: SELECT supplier_id, supplier_site_id
839: BULK COLLECT INTO l_supplier_ids, l_supplier_site_ids
840: FROM icx_cat_zone_secure_attributes
841: WHERE zone_id = l_content_zone_ids(i)
842: AND securing_attribute = 'SUPPLIER';
843:
844: l_err_loc := 450;

Line 1124: FROM icx_cat_zone_secure_attributes

1120: l_err_loc := 300;
1121: -- now get all the categories for that zone
1122: SELECT ip_category_id
1123: BULK COLLECT INTO l_category_ids
1124: FROM icx_cat_zone_secure_attributes
1125: WHERE zone_id = l_content_zone_ids(i)
1126: AND securing_attribute = 'CATEGORY';
1127:
1128: l_err_loc := 400;

Line 1132: FROM icx_cat_zone_secure_attributes

1128: l_err_loc := 400;
1129: -- now get all the suppliers and sites for that zone
1130: SELECT supplier_id, supplier_site_id
1131: BULK COLLECT INTO l_supplier_ids, l_supplier_site_ids
1132: FROM icx_cat_zone_secure_attributes
1133: WHERE zone_id = l_content_zone_ids(i)
1134: AND securing_attribute = 'SUPPLIER';
1135:
1136: l_err_loc := 450;