APPS.ARP_CMERGE_ARCUS dependencies on HZ_ORIG_SYS_REFERENCES

Line 4770: delete from hz_orig_sys_references where

4766: --lock rows
4767: OPEN cust_site_uses;
4768: CLOSE cust_site_uses;
4769:
4770: delete from hz_orig_sys_references where
4771: owner_table_name = 'HZ_CUST_SITE_USES_ALL' and
4772: owner_table_id in (
4773: select site_use_id from hz_cust_site_uses_all su
4774: where status = 'D'

Line 4813: delete from hz_orig_sys_references where

4809: --lock rows
4810: OPEN cust_sites;
4811: CLOSE cust_sites;
4812:
4813: delete from hz_orig_sys_references where
4814: owner_table_name = 'HZ_CUST_ACCT_SITES_ALL' and
4815: owner_table_id in (
4816: select cust_acct_site_id from hz_cust_acct_sites_all sites --SSuptake
4817: where status = 'D'

Line 4852: delete from hz_orig_sys_references where

4848: --lock rows
4849: OPEN cust_accounts;
4850: CLOSE cust_accounts;
4851:
4852: delete from hz_orig_sys_references where
4853: owner_table_name = 'HZ_CUST_ACCOUNTS' and
4854: owner_table_id in (
4855: select cust_account_id from hz_cust_accounts where
4856: status = 'D' and cust_account_id in