APPS.IEX_UTILITIES dependencies on HZ_CUST_ACCOUNTS

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:

Line 1541: SELECT party_id FROM HZ_CUST_ACCOUNTS

1537: select dunning_letters from hz_customer_profiles
1538: where site_use_id = p_site_use_id and status = 'A';
1539:
1540: CURSOR get_party_id_cur (p_cust_account_id number) is
1541: SELECT party_id FROM HZ_CUST_ACCOUNTS
1542: WHERE cust_account_id = p_cust_account_id ;
1543:
1544: cursor c_account (p_cust_account_id number) is
1545: select dunning_letters from hz_customer_profiles