1946:
1947: CURSOR active_site_cur IS
1948: select cust_acct_site_id, status
1949: from
1950: hz_cust_acct_sites
1951: where
1952: cust_account_id = p_cust_account_id
1953: and party_site_id = p_party_site_id
1954: and status = 'A';
1955:
1956: CURSOR inactive_site_cur IS
1957: select cust_acct_site_id, status
1958: from
1959: hz_cust_acct_sites
1960: where
1961: cust_account_id = p_cust_account_id
1962: and party_site_id = p_party_site_id
1963: and status <> 'A';
1984: /*
1985: CURSOR site_use_cur(cust_acct NUMBER, party_site NUMBER, site_type VARCHAR2) IS
1986: select a.site_use_id, b.status,a.status
1987: from
1988: hz_cust_site_uses a, hz_cust_acct_sites b
1989: where
1990: b.cust_account_id = cust_acct
1991: and b.party_site_id = party_site
1992: and a.cust_acct_site_id = b.cust_acct_site_id