DBA Data[Home] [Help]

APPS.HZ_CUSTOMER_INT dependencies on HZ_CUST_ACCT_RELATE_ALL

Line 791: hz_cust_acct_relate_all rel, -- bug 4454799

787:
788: CURSOR c2 IS -- Checking if the relationship already exists
789: SELECT 'x'
790: FROM hz_cust_accounts cust,
791: hz_cust_acct_relate_all rel, -- bug 4454799
792: hz_cust_acct_sites_all site, -- bug 4454799
793: hz_cust_site_uses_all su -- bug 4454799
794: WHERE cust.orig_system_reference = p_orig_system_customer_ref
795: AND rel.related_cust_account_id = cust.cust_account_id