1990: FUNCTION get_site_address_id(p_site_use_id NUMBER, p_org_id NUMBER ) RETURN NUMBER IS
1991:
1992: CURSOR l_address_id_csr IS
1993: SELECT cust_acct_site_id 1994: FROM hz_cust_site_uses 1995: WHERE site_use_id = p_site_use_id
1996: AND org_id = p_org_id;
1997: l_address_id NUMBER;
1998: