198: SELECT p_exposure_rec.bill_to_customer_id
199: FROM DUAL
200: UNION
201: SELECT CUST_ACCOUNT_ID
202: FROM HZ_CUST_ACCT_RELATE
203: WHERE RELATED_CUST_ACCOUNT_ID = p_exposure_rec.bill_to_customer_id
204: AND bill_to_flag = 'Y');
205:
206: CURSOR C2 (p_bill_to_state VARCHAR2) IS
332: (SELECT p_exposure_rec.bill_to_customer_id
333: FROM DUAL
334: UNION
335: SELECT CUST_ACCOUNT_ID
336: FROM HZ_CUST_ACCT_RELATE
337: WHERE RELATED_CUST_ACCOUNT_ID = p_exposure_rec.bill_to_customer_id
338: AND bill_to_flag = 'Y');
339: oe_debug_pub.add('after select found='||l_bill_to_site_use_id);
340: END IF;