APPS.OE_BLANKET_UTIL dependencies on HZ_CUST_ACCOUNTS

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

70: HZ_CUST_ACCT_RELATE_ALL h WHERE
71: RELATED_CUST_ACCOUNT_ID = p_sold_to_org_id
72: and h.org_id=acct_site.org_id
73: and ship_to_flag = 'Y' and status = 'A')
74: AND EXISTS(SELECT 1 FROM HZ_CUST_ACCOUNTS WHERE CUST_ACCOUNT_ID =
75: ACCT_SITE.CUST_ACCOUNT_ID AND STATUS='A')
76: AND ROWNUM = 1;
77: RETURN TRUE;
78: ELSIF g_customer_relations = 'A' THEN

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

149: HZ_CUST_ACCT_RELATE_ALL h WHERE
150: RELATED_CUST_ACCOUNT_ID = p_sold_to_org_id
151: and h.org_id=acct_site.org_id
152: and ship_to_flag = 'Y' and status='A')
153: AND EXISTS(SELECT 1 FROM HZ_CUST_ACCOUNTS WHERE CUST_ACCOUNT_ID =
154: ACCT_SITE.CUST_ACCOUNT_ID AND STATUS='A')
155: AND ROWNUM = 1;
156:
157: IF l_debug_level > 0 then

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

237: HZ_CUST_ACCT_RELATE_ALL h WHERE
238: RELATED_CUST_ACCOUNT_ID = p_sold_to_org_id
239: and h.org_id=acct_site.org_id
240: and bill_to_flag = 'Y' and status='A')
241: AND EXISTS(SELECT 1 FROM HZ_CUST_ACCOUNTS WHERE CUST_ACCOUNT_ID = ACCT_SITE.CUST_ACCOUNT_ID AND STATUS='A')
242: AND ROWNUM = 1;
243:
244: RETURN TRUE;
245: END IF;