APPS.OE_EXT_CREDIT_EXPOSURE_PVT dependencies on HZ_CUST_ACCT_RELATE

Line 202: FROM HZ_CUST_ACCT_RELATE

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

Line 336: FROM HZ_CUST_ACCT_RELATE

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;