[Home] [Help]
5750:
5751: IF ( l_tab.COUNT = 0 AND p_item_id IS NOT NULL ) THEN
5752:
5753: SELECT NVL( TO_CHAR ( property_num_value ), property_value ) BULK COLLECT INTO l_tab
5754: FROM cz_item_property_values
5755: WHERE property_id = p_property_id
5756: AND item_id = p_item_id
5757: AND deleted_flag = '0';
5758: