213: lcustomer_relations := OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG',l_orgid);
214: If nvl(lcustomer_relations ,'N') = 'N' Then
215: SELECT site_use_id
216: INTO l_site_use_id
217: FROM oe_invoice_to_orgs_v
218: WHERE customer_id = p_customer_id
219: AND address_id = p_address_id;
220: ELSIF lcustomer_relations = 'Y' THEN
221: SELECT site_use_id
219: AND address_id = p_address_id;
220: ELSIF lcustomer_relations = 'Y' THEN
221: SELECT site_use_id
222: INTO l_site_use_id
223: From oe_invoice_to_orgs_v
224: WHERE address_id = p_address_id
225: AND
226: customer_id in (
227: Select p_customer_id from dual