606: if is_attribute_used = 'N' then
607: begin
608: select 'Y'
609: into is_attribute_used 610: from qp_limits 611: where (nvl(multival_attr1_context,'x') = nvl(l_context_code,'y') and
612: nvl(multival_attribute1,'x') = nvl(p_SEG_rec.segment_mapping_column,'y')) or
613: (nvl(multival_attr2_context,'x') = nvl(l_context_code,'y') and
614: nvl(multival_attribute2,'x') = nvl(p_SEG_rec.segment_mapping_column,'y')) and