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;
226: customer_id in (
227: Select p_customer_id from dual
228: union
229: select cust_account_id from
230: hz_cust_acct_relate_all where
231: related_cust_account_id = p_customer_id)
232: and rownum = 1;
233: END IF;
234: x_bill_to_org_id := l_site_use_id;