APPS.AR_GET_CUSTOMER_BALANCE_PKG dependencies on HZ_LOCATIONS

Line 87: p_base_language hz_locations.language%TYPE,

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

Line 88: p_session_language hz_locations.language%TYPE ) IS

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

Line 101: hz_locations loc,

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