[Home] [Help]
1930: from hz_party_sites
1931: where party_site_id = p_owner_table_id;
1932: --and status = 'A'; -- Bug 3196803 : Removed the check of status = 'A'
1933:
1934: --//Table hz_cust_accounts
1935: cursor c_cust_id is
1936: select party_id
1937: from hz_cust_accounts
1938: where cust_account_id = p_owner_table_id;
1933:
1934: --//Table hz_cust_accounts
1935: cursor c_cust_id is
1936: select party_id
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
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:
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'
1990:
1991: --//Table hz_cust_account_roles
1992: cursor c_cust_acct_role_id is
1993: select cust.party_id
1994: from hz_cust_account_roles role,hz_cust_accounts cust
1995: where role.cust_account_role_id = p_owner_table_id
1996: and role.cust_account_id = cust.cust_account_id;
1997: --and role.status = 'A'; -- Bug 3196803 : Removed the check of status = 'A'
1998:
2005: open c_party_site_id;
2006: fetch c_party_site_id into x_party_id;
2007: close c_party_site_id;
2008:
2009: elsif p_owner_table_name = 'HZ_CUST_ACCOUNTS' then
2010: open c_cust_id;
2011: fetch c_cust_id into x_party_id;
2012: close c_cust_id;
2013: