APPS.AR_AI_INTEG_PKG dependencies on HZ_CUST_SITE_USES_ALL

Line 72: from hz_cust_site_uses_all site_use,

68: END IF;
69: /* Get the primary bill to site */
70: select site_use.cust_acct_site_id, site_use.PAYMENT_TERM_ID
71: into x_bill_to_address_id,x_payment_term_id
72: from hz_cust_site_uses_all site_use,
73: hz_cust_acct_sites_all sites
74: where sites.cust_account_id = p_bill_to_customer_account_id
75: and sites.status ='A'
76: and sites.cust_acct_site_id = site_use.cust_acct_site_id

Line 97: from hz_cust_site_uses_all site_use,

93: /* Get the primary ship to site */
94: IF p_ship_to_customer_account_id IS NOT NULL THEN
95: select site_use.cust_acct_site_id
96: into x_ship_to_address_id
97: from hz_cust_site_uses_all site_use,
98: hz_cust_acct_sites_all sites
99: where sites.cust_account_id = p_ship_to_customer_account_id
100: and sites.status ='A'
101: and sites.cust_acct_site_id = site_use.cust_acct_site_id