APPS.JAI_AR_TRX_HEADERS_PKG dependencies on HZ_CUST_SITE_USES_ALL

Line 30: FROM hz_cust_site_uses_all hzcsu, hz_cust_acct_sites_all hzcas

26: lv_regno JAI_CMN_CUS_ADDRESSES.vat_Reg_no%type;
27:
28: CURSOR c_get_address is
29: SELECT hzcas.cust_acct_site_id
30: FROM hz_cust_site_uses_all hzcsu, hz_cust_acct_sites_all hzcas
31: WHERE hzcas.cust_acct_site_id = hzcsu.cust_acct_site_id
32: AND hzcsu.site_use_id = pn_site_use_id
33: AND hzcas.cust_account_id = pn_customer_id;
34:

Line 958: FROM hz_cust_site_uses_all A

954: v_service_type VARCHAR2(30);
955:
956: Cursor address_cur(p_ship_to_site_use_id IN Number) IS
957: SELECT cust_acct_site_id address_id
958: FROM hz_cust_site_uses_all A
959: WHERE A.site_use_id = p_ship_to_site_use_id;
960:
961: CURSOR price_list_cur(p_customer_id IN Number,
962: p_inventory_item_id IN Number,