DBA Data[Home] [Help]

APPS.JAI_GST_TAX_DEFAULTATION_PKG dependencies on HZ_CUST_SITE_USES_ALL

Line 195: FROM hz_cust_site_uses_all A

191:
192: -- to get address_id
193: CURSOR cur_address IS
194: SELECT cust_acct_site_id address_id
195: FROM hz_cust_site_uses_all A
196: WHERE A.site_use_id = pn_ship_to_site_use_id;
197:
198: -- to get cust state
199: CURSOR cur_state(p_address_id IN NUMBER DEFAULT 0) IS

Line 450: FROM hz_cust_site_uses_all A

446:
447: -- to get address_id
448: CURSOR address_cur(pn_ship_to_site_use_id IN NUMBER) IS
449: SELECT cust_acct_site_id address_id
450: FROM hz_cust_site_uses_all A
451: WHERE A.site_use_id = pn_ship_to_site_use_id;
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