66:
67: -- to get tax_category_id
68: CURSOR tax_catg_id_cur(p_tax_category_list IN VARCHAR2, p_inventory_item_id IN NUMBER) IS
69: SELECT tax_category_id
70: FROM JAI_INV_ITM_TAXCTG_DTLS a
71: WHERE a.tax_category_list = p_tax_category_list
72: AND a.inventory_item_id = p_inventory_item_id;
73:
74: BEGIN
158:
159: -- to get tax_category_id
160: CURSOR tax_catg_id_cur(p_tax_category_list IN VARCHAR2, p_inventory_item_id IN NUMBER) IS
161: SELECT tax_category_id
162: FROM JAI_INV_ITM_TAXCTG_DTLS a
163: WHERE a.tax_category_list = p_tax_category_list
164: AND a.inventory_item_id = p_inventory_item_id;
165:
166: BEGIN