DBA Data[Home] [Help]

APPS.JAI_GST_GENERAL_PKG dependencies on HZ_CUST_SITE_USES_ALL

Line 112: FROM hz_cust_site_uses_all A

108: ------------------------------------------------Cursors for Customer------------------------------------------
109:
110: CURSOR address_cur(p_party_site_id IN NUMBER) IS
111: SELECT nvl(cust_acct_site_id, 0) address_id
112: FROM hz_cust_site_uses_all A
113: WHERE A.site_use_id = NVL(p_party_site_id, 0);
114:
115: --Added the following cursors start*/
116: CURSOR c_gst_ass_value_cust(p_party_id NUMBER, p_address_id NUMBER, p_inventory_item_id NUMBER, p_uom_code VARCHAR2, p_ordered_date DATE) IS