DBA Data[Home] [Help]

APPS.IEX_UTILITIES dependencies on HZ_CUST_ACCT_SITES

Line 1422: FROM hz_cust_site_uses site_uses, hz_cust_acct_sites acct_sites, hz_cust_accounts ca

1418: l_delinquency_id number;
1419:
1420: CURSOR get_party_account_id_cur (p_customer_site_use_id number) is
1421: SELECT ca.party_id party_id, ca.cust_account_id cust_account_id
1422: FROM hz_cust_site_uses site_uses, hz_cust_acct_sites acct_sites, hz_cust_accounts ca
1423: WHERE site_uses.site_use_id = p_customer_site_use_id
1424: AND acct_sites.cust_acct_site_id = site_uses.cust_acct_site_id
1425: AND ca.cust_account_id = acct_sites.cust_account_id;
1426: