DBA Data[Home] [Help]

APPS.AR_RECEIPT_LIB_PVT dependencies on HZ_PARTY_SITES

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

7899: ,p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE
7900: ,p_currency_code IN fnd_currencies.currency_code%TYPE
7901: ,p_amount IN NUMBER
7902: ,p_party_id IN OUT NOCOPY hz_parties.party_id%TYPE
7903: ,p_party_site_id IN OUT NOCOPY hz_party_sites.party_site_id%TYPE
7904: ,x_party_name OUT NOCOPY hz_parties.party_name%TYPE
7905: ,x_party_number OUT NOCOPY hz_parties.party_number%TYPE
7906: ,x_party_address OUT NOCOPY VARCHAR2
7907: ,x_exchange_rate OUT NOCOPY ar_cash_receipts.exchange_rate%TYPE

Line 8011: hz_party_sites ps,

8007: INTO p_party_site_id
8008: ,x_party_address
8009: FROM hz_cust_acct_sites_all cas,
8010: hz_cust_site_uses_all csu,
8011: hz_party_sites ps,
8012: hz_locations loc
8013: WHERE cas.cust_acct_site_id = csu.cust_acct_site_id
8014: AND csu.site_use_id = l_site_use_id
8015: AND cas.party_site_id = ps.party_site_id