DBA Data[Home] [Help]

APPS.JAI_CMN_TAX_DEFAULTATION_PKG dependencies on JAI_INV_ITM_TAXCTG_DTLS

Line 70: FROM JAI_INV_ITM_TAXCTG_DTLS a

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

Line 162: FROM JAI_INV_ITM_TAXCTG_DTLS a

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