APPS.IEX_CUST_OVERVIEW_PVT dependencies on HZ_CUST_ACCOUNT_ROLES

Line 3166: update hz_cust_account_roles set status = 'I'

3162: select cust_account_id into t_cust_account_id from hz_cust_acct_sites
3163: where cust_acct_site_id = (select cust_acct_site_id from hz_cust_site_uses_all where site_use_id = :IEXCUOVW_HEADER.customer_site_use_id);
3164: */
3165:
3166: update hz_cust_account_roles set status = 'I'
3167: where status = 'A'
3168: and created_by_module = l_org_contact_create_rec.created_by_module
3169: and cust_account_id = t_cust_account_id;
3170: -- and cust_account_id in (select cust_account_id from hz_cust_accounts where party_id = p_org_party_id);