APPS.AR_GET_CUSTOMER_BALANCE_PKG dependencies on HZ_LOCATIONS

Line 88: p_base_language hz_locations.language%TYPE,

84: upper(cust_acct.account_number) <= upper(p_customer_number_high));
85:
86:
87: CURSOR siteinfo(p_customer_id ar_payment_schedules.customer_id%TYPE,
88: p_base_language hz_locations.language%TYPE,
89: p_session_language hz_locations.language%TYPE ) IS
90: SELECT site_uses.site_use_id ,
91: acct_site.translated_customer_name,
92: loc.address1,

Line 89: p_session_language hz_locations.language%TYPE ) IS

85:
86:
87: CURSOR siteinfo(p_customer_id ar_payment_schedules.customer_id%TYPE,
88: p_base_language hz_locations.language%TYPE,
89: p_session_language hz_locations.language%TYPE ) IS
90: SELECT site_uses.site_use_id ,
91: acct_site.translated_customer_name,
92: loc.address1,
93: loc.address2,

Line 102: hz_locations loc,

98: loc.postal_code,
99: loc.country
100: FROM hz_cust_acct_sites acct_site,
101: hz_party_sites party_site,
102: hz_locations loc,
103: hz_cust_site_uses site_uses
104: WHERE acct_site.cust_account_id =p_customer_id
105: AND nvl(acct_site.status,'A') = 'A'
106: AND acct_site.bill_to_flag in ( 'Y', 'P' )