APPS.HZ_ORIG_SYSTEM_REF_PVT dependencies on HZ_CUST_ACCOUNTS

Line 1981: --//Table hz_cust_accounts

1977: from hz_party_sites
1978: where party_site_id = p_owner_table_id;
1979: --and status = 'A'; -- Bug 3196803 : Removed the check of status = 'A'
1980:
1981: --//Table hz_cust_accounts
1982: cursor c_cust_id is
1983: select party_id
1984: from hz_cust_accounts
1985: where cust_account_id = p_owner_table_id;

Line 1984: from hz_cust_accounts

1980:
1981: --//Table hz_cust_accounts
1982: cursor c_cust_id is
1983: select party_id
1984: from hz_cust_accounts
1985: where cust_account_id = p_owner_table_id;
1986: --and status = 'A'; -- Bug 3196803 : Removed the check of status = 'A'
1987:
1988: --//Table hz_cust_acct_sites_all

Line 1991: from hz_cust_accounts cust,hz_cust_acct_sites_all sites

1987:
1988: --//Table hz_cust_acct_sites_all
1989: cursor c_cust_site_id is
1990: select cust.party_id
1991: from hz_cust_accounts cust,hz_cust_acct_sites_all sites
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:

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 2041: from hz_cust_account_roles role,hz_cust_accounts cust

2037:
2038: --//Table hz_cust_account_roles
2039: cursor c_cust_acct_role_id is
2040: select cust.party_id
2041: from hz_cust_account_roles role,hz_cust_accounts cust
2042: where role.cust_account_role_id = p_owner_table_id
2043: and role.cust_account_id = cust.cust_account_id;
2044: --and role.status = 'A'; -- Bug 3196803 : Removed the check of status = 'A'
2045:

Line 2056: elsif p_owner_table_name = 'HZ_CUST_ACCOUNTS' then

2052: open c_party_site_id;
2053: fetch c_party_site_id into x_party_id;
2054: close c_party_site_id;
2055:
2056: elsif p_owner_table_name = 'HZ_CUST_ACCOUNTS' then
2057: open c_cust_id;
2058: fetch c_cust_id into x_party_id;
2059: close c_cust_id;
2060: