100: IS
101: SELECT
102: name
103: FROM
104: qp_list_headers
105: WHERE list_header_id = pn_list_header_id;
106:
107: -- Check same UOM ,whether item and item category that contains the same item existing in a same price list.
108: CURSOR check_item_category_cur
192: and a.list_header_id = pn_list_header_id;
193:
194: ln_excise_list_id NUMBER;
195: ln_vat_list_id NUMBER;
196: lv_av_list_name qp_list_headers.name%type;
197: ln_category_id NUMBER;
198: ln_category_count NUMBER; /* Added for bug 10103931 */
199: le_multi_row EXCEPTION;
200: