APPS.OE_EXTERNAL_CREDIT_PVT dependencies on HZ_CUST_ACCT_RELATE

Line 356: FROM HZ_CUST_ACCT_RELATE

352: SELECT p_customer_id
353: FROM DUAL
354: UNION
355: SELECT CUST_ACCOUNT_ID
356: FROM HZ_CUST_ACCT_RELATE
357: WHERE RELATED_CUST_ACCOUNT_ID = p_customer_id
358: AND bill_to_flag = 'Y');
359:
360: CURSOR C2 IS

Line 481: FROM HZ_CUST_ACCT_RELATE

477: (SELECT p_customer_id
478: FROM DUAL
479: UNION
480: SELECT CUST_ACCOUNT_ID
481: FROM HZ_CUST_ACCT_RELATE
482: WHERE RELATED_CUST_ACCOUNT_ID = p_customer_id
483: AND bill_to_flag = 'Y');
484: oe_debug_pub.add('after select found='||l_bill_to_site_use_id);
485: END IF;