APPS.AR_RECEIPT_API_PUB dependencies on HZ_PARTY_SITES

Line 7396: ,p_party_site_id IN hz_party_sites.party_site_id%TYPE

7392: ,p_remittance_message1 IN ap_invoices.remittance_message1%TYPE
7393: ,p_remittance_message2 IN ap_invoices.remittance_message2%TYPE
7394: ,p_remittance_message3 IN ap_invoices.remittance_message3%TYPE
7395: ,p_party_id IN hz_parties.party_id%TYPE
7396: ,p_party_site_id IN hz_party_sites.party_site_id%TYPE
7397: ,p_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE
7398: ,p_payment_priority IN ap_invoices_interface.PAYMENT_PRIORITY%TYPE --Bug8290172
7399: ,p_terms_id IN ap_invoices_interface.TERMS_ID%TYPE --Bug8290172
7400: ) IS

Line 7432: l_party_site_id hz_party_sites.party_site_id%TYPE;

7428:
7429: l_party_id hz_parties.party_id%TYPE;
7430: l_party_name hz_parties.party_name%TYPE;
7431: l_party_number hz_parties.party_number%TYPE;
7432: l_party_site_id hz_party_sites.party_site_id%TYPE;
7433: l_party_address VARCHAR2(360);
7434: l_payment_method_code iby_payment_methods_vl.payment_method_code%TYPE;
7435: l_payment_method_name iby_payment_methods_vl.payment_method_name%TYPE;
7436: l_bank_account_id iby_ext_bank_accounts.ext_bank_account_id%TYPE;

Line 12083: hz_party_sites party_site,

12079:
12080: SELECT site_uses.site_use_id
12081: INTO l_location
12082: FROM hz_cust_acct_sites acct_site,
12083: hz_party_sites party_site,
12084: hz_locations loc,
12085: hz_cust_site_uses site_uses
12086: WHERE acct_site.cust_acct_site_id = site_uses.cust_acct_site_id
12087: AND acct_site.party_site_id = party_site.party_site_id