APPS.ARP_CMERGE_ARCUS dependencies on HZ_ORIG_SYS_REFERENCES

Line 4460: delete from hz_orig_sys_references where

4456: --lock rows
4457: OPEN cust_site_uses;
4458: CLOSE cust_site_uses;
4459:
4460: delete from hz_orig_sys_references where
4461: owner_table_name = 'HZ_CUST_SITE_USES_ALL' and
4462: owner_table_id in (
4463: select site_use_id from hz_cust_site_uses_all su
4464: where status = 'D'

Line 4503: delete from hz_orig_sys_references where

4499: --lock rows
4500: OPEN cust_sites;
4501: CLOSE cust_sites;
4502:
4503: delete from hz_orig_sys_references where
4504: owner_table_name = 'HZ_CUST_ACCT_SITES_ALL' and
4505: owner_table_id in (
4506: select cust_acct_site_id from hz_cust_acct_sites_all sites --SSuptake
4507: where status = 'D'

Line 4542: delete from hz_orig_sys_references where

4538: --lock rows
4539: OPEN cust_accounts;
4540: CLOSE cust_accounts;
4541:
4542: delete from hz_orig_sys_references where
4543: owner_table_name = 'HZ_CUST_ACCOUNTS' and
4544: owner_table_id in (
4545: select cust_account_id from hz_cust_accounts where
4546: status = 'D' and cust_account_id in