APPS.HZ_ORIG_SYSTEM_REF_PVT dependencies on HZ_CUST_ACCT_SITES

Line 1941: --//Table hz_cust_acct_sites_all

1937: from hz_cust_accounts
1938: where cust_account_id = p_owner_table_id;
1939: --and status = 'A'; -- Bug 3196803 : Removed the check of status = 'A'
1940:
1941: --//Table hz_cust_acct_sites_all
1942: cursor c_cust_site_id is
1943: select cust.party_id
1944: from hz_cust_accounts cust,hz_cust_acct_sites sites
1945: where sites.cust_acct_site_id = p_owner_table_id

Line 1944: from hz_cust_accounts cust,hz_cust_acct_sites sites

1940:
1941: --//Table hz_cust_acct_sites_all
1942: cursor c_cust_site_id is
1943: select cust.party_id
1944: from hz_cust_accounts cust,hz_cust_acct_sites sites
1945: where sites.cust_acct_site_id = p_owner_table_id
1946: and cust.cust_account_id = sites.cust_account_id;
1947: --and sites.status = 'A'; -- Bug 3196803 : Removed the check of status = 'A'
1948:

Line 1952: from hz_cust_accounts cust,hz_cust_acct_sites sites,hz_cust_site_uses uses

1948:
1949: --//Table hz_cust_site_uses_all
1950: cursor c_cust_site_uses_id is
1951: select cust.party_id
1952: from hz_cust_accounts cust,hz_cust_acct_sites sites,hz_cust_site_uses uses
1953: where uses.site_use_id = p_owner_table_id
1954: and uses.cust_acct_site_id = sites.cust_acct_site_id
1955: and sites.cust_account_id = cust.cust_account_id;
1956: --and uses.status = 'A'; -- Bug 3196803 : Removed the check of status = 'A'

Line 2014: elsif p_owner_table_name = 'HZ_CUST_ACCT_SITES_ALL' then

2010: open c_cust_id;
2011: fetch c_cust_id into x_party_id;
2012: close c_cust_id;
2013:
2014: elsif p_owner_table_name = 'HZ_CUST_ACCT_SITES_ALL' then
2015: open c_cust_site_id;
2016: fetch c_cust_site_id into x_party_id;
2017: close c_cust_site_id;
2018: