DBA Data[Home] [Help]

APPS.JAI_AR_TRX_LINES_PKG dependencies on HZ_CUST_ACCT_SITES_ALL

Line 987: FROM hz_cust_site_uses_all hzcsu, hz_cust_acct_sites_all hzcas

983: ln_address_id NUMBER;
984:
985: CURSOR c_get_address IS
986: SELECT hzcas.cust_acct_site_id
987: FROM hz_cust_site_uses_all hzcsu, hz_cust_acct_sites_all hzcas
988: WHERE hzcas.cust_acct_site_id = hzcsu.cust_acct_site_id
989: AND hzcsu.site_use_id = pn_party_site_id
990: AND hzcas.cust_account_id = pn_party_id;
991: