APPS.ASO_CHECK_TCA_PVT dependencies on HZ_CUST_ACCT_SITES

Line 1942: hz_cust_acct_sites

1938:
1939: CURSOR active_site_cur IS
1940: select cust_acct_site_id, status
1941: from
1942: hz_cust_acct_sites
1943: where
1944: cust_account_id = p_cust_account_id
1945: and party_site_id = p_party_site_id
1946: and status = 'A';

Line 1951: hz_cust_acct_sites

1947:
1948: CURSOR inactive_site_cur IS
1949: select cust_acct_site_id, status
1950: from
1951: hz_cust_acct_sites
1952: where
1953: cust_account_id = p_cust_account_id
1954: and party_site_id = p_party_site_id
1955: and status <> 'A';

Line 1980: hz_cust_site_uses a, hz_cust_acct_sites b

1976: /*
1977: CURSOR site_use_cur(cust_acct NUMBER, party_site NUMBER, site_type VARCHAR2) IS
1978: select a.site_use_id, b.status,a.status
1979: from
1980: hz_cust_site_uses a, hz_cust_acct_sites b
1981: where
1982: b.cust_account_id = cust_acct
1983: and b.party_site_id = party_site
1984: and a.cust_acct_site_id = b.cust_acct_site_id