DBA Data[Home] [Help]

APPS.AR_RECEIPT_LIB_PVT dependencies on HZ_PARTY_SITES

Line 8202: ,p_party_site_id IN OUT NOCOPY hz_party_sites.party_site_id%TYPE

8198: ,p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE
8199: ,p_currency_code IN fnd_currencies.currency_code%TYPE
8200: ,p_amount IN NUMBER
8201: ,p_party_id IN OUT NOCOPY hz_parties.party_id%TYPE
8202: ,p_party_site_id IN OUT NOCOPY hz_party_sites.party_site_id%TYPE
8203: ,x_party_name OUT NOCOPY hz_parties.party_name%TYPE
8204: ,x_party_number OUT NOCOPY hz_parties.party_number%TYPE
8205: ,x_party_address OUT NOCOPY VARCHAR2
8206: ,x_exchange_rate OUT NOCOPY ar_cash_receipts.exchange_rate%TYPE

Line 8310: hz_party_sites ps,

8306: INTO p_party_site_id
8307: ,x_party_address
8308: FROM hz_cust_acct_sites_all cas,
8309: hz_cust_site_uses_all csu,
8310: hz_party_sites ps,
8311: hz_locations loc
8312: WHERE cas.cust_acct_site_id = csu.cust_acct_site_id
8313: AND csu.site_use_id = l_site_use_id
8314: AND cas.party_site_id = ps.party_site_id