34:
35: -- to get tax_category_id
36: CURSOR tax_catg_id_cur(p_tax_category_list IN VARCHAR2, p_inventory_item_id IN NUMBER) IS
37: SELECT tax_category_id
38: FROM JAI_INV_ITM_TAXCTG_DTLS a
39: WHERE a.tax_category_list = p_tax_category_list
40: AND a.inventory_item_id = p_inventory_item_id;
41:
42: BEGIN
126:
127: -- to get tax_category_id
128: CURSOR tax_catg_id_cur(p_tax_category_list IN VARCHAR2, p_inventory_item_id IN NUMBER) IS
129: SELECT tax_category_id
130: FROM JAI_INV_ITM_TAXCTG_DTLS a
131: WHERE a.tax_category_list = p_tax_category_list
132: AND a.inventory_item_id = p_inventory_item_id;
133:
134: BEGIN