APPS.HZ_ORIG_SYSTEM_REF_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 1996: --//Table hz_cust_site_uses_all

1992: where sites.cust_acct_site_id = p_owner_table_id
1993: and cust.cust_account_id = sites.cust_account_id;
1994: --and sites.status = 'A'; -- Bug 3196803 : Removed the check of status = 'A'
1995:
1996: --//Table hz_cust_site_uses_all
1997: cursor c_cust_site_uses_id is
1998: select cust.party_id
1999: from hz_cust_accounts cust,hz_cust_acct_sites_all sites,hz_cust_site_uses_all uses
2000: where uses.site_use_id = p_owner_table_id

Line 1999: from hz_cust_accounts cust,hz_cust_acct_sites_all sites,hz_cust_site_uses_all uses

1995:
1996: --//Table hz_cust_site_uses_all
1997: cursor c_cust_site_uses_id is
1998: select cust.party_id
1999: from hz_cust_accounts cust,hz_cust_acct_sites_all sites,hz_cust_site_uses_all uses
2000: where uses.site_use_id = p_owner_table_id
2001: and uses.cust_acct_site_id = sites.cust_acct_site_id
2002: and sites.cust_account_id = cust.cust_account_id;
2003: --and uses.status = 'A'; -- Bug 3196803 : Removed the check of status = 'A'

Line 2066: elsif p_owner_table_name = 'HZ_CUST_SITE_USES_ALL' then

2062: open c_cust_site_id;
2063: fetch c_cust_site_id into x_party_id;
2064: close c_cust_site_id;
2065:
2066: elsif p_owner_table_name = 'HZ_CUST_SITE_USES_ALL' then
2067: open c_cust_site_uses_id ;
2068: fetch c_cust_site_uses_id into x_party_id;
2069: close c_cust_site_uses_id;
2070: