APPS.JAI_OPEN_API_PKG dependencies on JAI_CMN_CUS_ADDRESSES

Line 3759: FROM JAI_CMN_CUS_ADDRESSES a

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
3758: SELECT tax_category_list
3759: FROM JAI_CMN_CUS_ADDRESSES a
3760: WHERE A.customer_id = p_customer_id
3761: AND A.address_id = p_address_id;
3762:
3763: -- to get tax_category_id

Line 4159: FROM jai_cmn_cus_addresses

4155: )IS
4156:
4157: CURSOR get_ar_party_cur IS
4158: SELECT COUNT(customer_id)
4159: FROM jai_cmn_cus_addresses
4160: WHERE customer_id = pn_party_id;
4161:
4162: CURSOR get_ar_party_site_cur IS
4163: SELECT count(cuse.site_use_id)

Line 4165: , jai_cmn_cus_addresses jcca

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;
4169:

Line 4175: , jai_cmn_cus_addresses jcca

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
4179: AND jcca.customer_id = cn_party_id;