APPS.OE_BLANKET_UTIL dependencies on HZ_CUST_ACCOUNTS

Line 163: AND EXISTS(SELECT 1 FROM HZ_CUST_ACCOUNTS WHERE CUST_ACCOUNT_ID =

159: HZ_CUST_ACCT_RELATE_ALL h WHERE
160: RELATED_CUST_ACCOUNT_ID = p_sold_to_org_id
161: and h.org_id=acct_site.org_id
162: and ship_to_flag = 'Y' and status = 'A')
163: AND EXISTS(SELECT 1 FROM HZ_CUST_ACCOUNTS WHERE CUST_ACCOUNT_ID =
164: ACCT_SITE.CUST_ACCOUNT_ID AND STATUS='A')
165: AND ROWNUM = 1;
166: RETURN TRUE;
167: ELSIF g_customer_relations = 'A' THEN

Line 242: AND EXISTS(SELECT 1 FROM HZ_CUST_ACCOUNTS WHERE CUST_ACCOUNT_ID =

238: HZ_CUST_ACCT_RELATE_ALL h WHERE
239: RELATED_CUST_ACCOUNT_ID = p_sold_to_org_id
240: and h.org_id=acct_site.org_id
241: and ship_to_flag = 'Y' and status='A')
242: AND EXISTS(SELECT 1 FROM HZ_CUST_ACCOUNTS WHERE CUST_ACCOUNT_ID =
243: ACCT_SITE.CUST_ACCOUNT_ID AND STATUS='A')
244: AND ROWNUM = 1;
245:
246: IF l_debug_level > 0 then

Line 330: AND EXISTS(SELECT 1 FROM HZ_CUST_ACCOUNTS WHERE CUST_ACCOUNT_ID = ACCT_SITE.CUST_ACCOUNT_ID AND STATUS='A')

326: HZ_CUST_ACCT_RELATE_ALL h WHERE
327: RELATED_CUST_ACCOUNT_ID = p_sold_to_org_id
328: and h.org_id=acct_site.org_id
329: and bill_to_flag = 'Y' and status='A')
330: AND EXISTS(SELECT 1 FROM HZ_CUST_ACCOUNTS WHERE CUST_ACCOUNT_ID = ACCT_SITE.CUST_ACCOUNT_ID AND STATUS='A')
331: AND ROWNUM = 1;
332:
333: RETURN TRUE;
334: END IF;