860: zx_rates_b at,
861: ar_cash_receipts_all ac,
862: ra_customer_trx tr,
863: hz_cust_accounts rc,
864: hz_parties hzp,
865: hz_cust_acct_sites cs,
866: hz_cust_site_uses csu
867: WHERE aa.applied_customer_trx_id = tr.customer_trx_id
868: AND aa.cash_receipt_id = P_CASH_RECEIPT_ID
1111: l_address3 hz_locations.address3%TYPE;
1112: l_address4 hz_locations.address4%TYPE;
1113: l_city hz_locations.city%TYPE;
1114: l_postal_code hz_locations.postal_code%TYPE;
1115: l_contact hz_parties.party_name%TYPE;
1116: l_phone_number hz_contact_points.phone_number%TYPE;
1117: -- Added for Glob-006 ER
1118: l_province VARCHAR2(120);
1119: l_comm_num VARCHAR2(30);