APPS.AR_AI_INTEG_PKG dependencies on HZ_CUST_SITE_USES_ALL

Line 75: from hz_cust_site_uses_all site_use,

71: /* Get the primary bill to site */
72: select site_use.cust_acct_site_id, site_use.PAYMENT_TERM_ID,
73: site_use.site_use_id
74: into x_bill_to_address_id,x_payment_term_id, l_site_use_id
75: from hz_cust_site_uses_all site_use,
76: hz_cust_acct_sites_all sites
77: where sites.cust_account_id = p_bill_to_customer_account_id
78: and sites.status ='A'
79: and sites.cust_acct_site_id = site_use.cust_acct_site_id

Line 100: from hz_cust_site_uses_all site_use,

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

Line 129: hz_cust_site_uses_all su

125: ra_terms t_cp2,
126: ra_terms tl,
127: hz_customer_profiles cp1,
128: hz_customer_profiles cp2,
129: hz_cust_site_uses_all su
130: WHERE p_bill_to_customer_account_id = cp1.cust_account_id(+)
131: AND cp2.cust_account_id = p_bill_to_customer_account_id
132: AND su.site_use_id = cp1.site_use_id(+)
133: AND cp2.site_use_id IS NULL