1968: FUNCTION get_site_address_id(p_site_use_id NUMBER, p_org_id NUMBER ) RETURN NUMBER IS
1969:
1970: CURSOR l_address_id_csr IS
1971: SELECT cust_acct_site_id 1972: FROM hz_cust_site_uses 1973: WHERE site_use_id = p_site_use_id
1974: AND org_id = p_org_id;
1975: l_address_id NUMBER;
1976: