[Home] [Help]
4616: k:=p_id_tbl.first;
4617: while k is not null loop
4618: select id
4619: bulk collect into l_id_tbl
4620: from okc_price_adj_attribs
4621: where pat_id = p_id_tbl(k);
4622: IF (l_debug = 'Y') THEN
4623: my_debug('13610 : select rowcount'||SQL%ROWCOUNT, 1);
4624: END IF;
6176:
6177: cursor l_attribs(p_id number) is
6178: select flex_title,pricing_context,pricing_attribute,
6179: pricing_attr_value_from, pricing_attr_value_to,comparison_operator
6180: From okc_price_adj_attribs
6181: where pat_id=p_id;
6182: pbh_index number;
6183: l_row l_cle%rowtype;
6184: l_attrib_row l_attribs%rowtype;