56: status = 'A';
57:
58: Cursor acct_site_use_csr(p_cust_acct_site_id number, p_site_use_code varchar2) IS
59: SELECT site_use_id
60: FROM hz_cust_site_uses_all
61: WHERE cust_acct_site_id = p_cust_acct_site_id and
62: site_use_code = p_site_use_code and
63: status = 'A';
64:
207: status = p_status;
208:
209: Cursor acct_site_use_csr(p_cust_acct_site_id number, p_site_use_code varchar2, p_status varchar2) IS
210: SELECT site_use_id
211: FROM hz_cust_site_uses_all
212: WHERE cust_acct_site_id = p_cust_acct_site_id and
213: site_use_code = p_site_use_code and
214: status = p_status;
215: