APPS.HZ_ORIG_SYSTEM_REF_PVT dependencies on HZ_CUST_SITE_USES

Line 1949: --//Table hz_cust_site_uses_all

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:
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

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 2019: elsif p_owner_table_name = 'HZ_CUST_SITE_USES_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:
2019: elsif p_owner_table_name = 'HZ_CUST_SITE_USES_ALL' then
2020: open c_cust_site_uses_id ;
2021: fetch c_cust_site_uses_id into x_party_id;
2022: close c_cust_site_uses_id;
2023: