DBA Data[Home] [Help]

APPS.JAI_CMN_TAX_DEFAULTATION_PKG dependencies on JAI_INV_ITM_TAXCTG_DTLS

Line 38: FROM JAI_INV_ITM_TAXCTG_DTLS a

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

Line 130: FROM JAI_INV_ITM_TAXCTG_DTLS a

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