183: customer_id in (
184: Select p_customer_id from dual
185: union
186: select cust_account_id from
187: hz_cust_acct_relate_all where
188: related_cust_account_id = p_customer_id)
189: and rownum = 1;
190: END IF;
191: x_ship_to_org_id := l_site_use_id;
228: customer_id in (
229: Select p_customer_id from dual
230: union
231: select cust_account_id from
232: hz_cust_acct_relate_all where
233: related_cust_account_id = p_customer_id)
234: and rownum = 1;
235: END IF;
236: x_bill_to_org_id := l_site_use_id;