DBA Data[Home] [Help]

APPS.IEX_UTILITIES dependencies on HZ_CUST_ACCT_SITES

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

1527: l_delinquency_id number;
1528:
1529: CURSOR get_party_account_id_cur (p_customer_site_use_id number) is
1530: SELECT ca.party_id party_id, ca.cust_account_id cust_account_id
1531: FROM hz_cust_site_uses site_uses, hz_cust_acct_sites acct_sites, hz_cust_accounts ca
1532: WHERE site_uses.site_use_id = p_customer_site_use_id
1533: AND acct_sites.cust_acct_site_id = site_uses.cust_acct_site_id
1534: AND ca.cust_account_id = acct_sites.cust_account_id;
1535: