[Home] [Help]
5626:
5627: IF ( l_tab.COUNT = 0 AND p_item_id IS NOT NULL ) THEN
5628:
5629: SELECT NVL( TO_CHAR ( property_num_value ), property_value ) BULK COLLECT INTO l_tab
5630: FROM cz_item_property_values
5631: WHERE property_id = p_property_id
5632: AND item_id = p_item_id
5633: AND deleted_flag = '0';
5634: