DBA Data[Home] [Help]

APPS.JAI_GST_TAX_DEFAULTATION_PKG dependencies on JAI_CMN_CUS_ADDRESSES

Line 201: FROM JAI_CMN_CUS_ADDRESSES a

197:
198: -- to get cust state
199: CURSOR cur_state(p_address_id IN NUMBER DEFAULT 0) IS
200: SELECT STATE_CODE
201: FROM JAI_CMN_CUS_ADDRESSES a
202: WHERE A.customer_id = pn_customer_id
203: AND A.address_id = p_address_id;
204:
205: v_address_id NUMBER;

Line 456: FROM JAI_CMN_CUS_ADDRESSES a

452:
453: -- to get tax_category_list
454: CURSOR tax_catg_list_cur(pn_customer_id IN NUMBER, p_address_id IN NUMBER DEFAULT 0) IS
455: SELECT tax_category_list
456: FROM JAI_CMN_CUS_ADDRESSES a
457: WHERE A.customer_id = pn_customer_id
458: AND A.address_id = p_address_id;
459:
460: CURSOR tax_catg_id_cur(p_tax_category_list IN VARCHAR2, pn_inventory_item_id IN NUMBER, p_inter_flag IN VARCHAR2) IS