APPS.JAI_OPEN_API_PKG dependencies on HZ_CUST_SITE_USES_ALL

Line 3753: FROM hz_cust_site_uses_all A -- Removed ra_site_uses_all from Bug# 4434287

3749:
3750: -- to get address_id
3751: CURSOR address_cur(p_ship_to_site_use_id IN NUMBER) IS
3752: SELECT cust_acct_site_id address_id
3753: FROM hz_cust_site_uses_all A -- Removed ra_site_uses_all from Bug# 4434287
3754: WHERE A.site_use_id = p_ship_to_site_use_id;
3755:
3756: -- to get tax_category_list
3757: CURSOR tax_catg_list_cur(p_customer_id IN NUMBER, p_address_id IN NUMBER DEFAULT 0) IS

Line 3826: FROM hz_cust_site_uses_all A

3822: WHERE customer_trx_id = cn_customer_trx_id;
3823:
3824: Cursor address_cur(cn_ship_to_site_use_id IN Number) IS
3825: SELECT cust_acct_site_id address_id
3826: FROM hz_cust_site_uses_all A
3827: WHERE A.site_use_id = cn_ship_to_site_use_id;
3828:
3829: CURSOR CREATED_FROM_CUR(cn_customer_trx_id IN RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE)
3830: IS

Line 4164: FROM hz_cust_site_uses_all cuse

4160: WHERE customer_id = pn_party_id;
4161:
4162: CURSOR get_ar_party_site_cur IS
4163: SELECT count(cuse.site_use_id)
4164: FROM hz_cust_site_uses_all cuse
4165: , jai_cmn_cus_addresses jcca
4166: WHERE cuse.site_use_id = pn_party_site_id
4167: AND cuse.site_use_code = 'BILL_TO'
4168: AND cuse.cust_acct_site_id = jcca.address_id;

Line 4174: FROM hz_cust_site_uses_all cuse

4170: CURSOR chk_ar_party_combination_cur(
4171: cn_party_id IN JAI_INTERFACE_LINES_ALL.PARTY_ID%TYPE,
4172: cn_party_site_id IN JAI_INTERFACE_LINES_ALL.PARTY_SITE_ID%TYPE) IS
4173: SELECT count(cuse.site_use_id)
4174: FROM hz_cust_site_uses_all cuse
4175: , jai_cmn_cus_addresses jcca
4176: WHERE cuse.site_use_id = pn_party_site_id
4177: AND cuse.site_use_code = 'BILL_TO'
4178: AND cuse.cust_acct_site_id = jcca.address_id