APPS.WMS_RULES_WORKBENCH_PVT dependencies on HZ_CUST_ACCOUNTS

Line 173: hz_cust_accounts cust_acct

169: Function get_customer_name(p_customer_id IN NUMBER)
170: Return VARCHAR2 is
171: /* TCA changes : replaced ra_customer by
172: hz_parties party,
173: hz_cust_accounts cust_acct
174: */
175: g_pkg_name constant VARCHAR2(50) := 'WMS_SELECTION_CRITERIA_PVT';
176: l_api_name constant VARCHAR2(30) := 'GET_CUSTOMER_NAME';
177:

Line 189: HZ_CUST_ACCOUNTS CUST_ACCT

185:
186: /* SELECT distinct substrb ( PARTY.PARTY_NAME, 1, 50 )
187: INTO l_customer_name
188: FROM HZ_PARTIES PARTY,
189: HZ_CUST_ACCOUNTS CUST_ACCT
190: WHERE CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
191: AND PARTY.PARTY_ID = p_customer_id; */
192:
193:

Line 197: HZ_CUST_ACCOUNTS CUST_ACCT

193:
194: SELECT distinct substrb ( PARTY.PARTY_NAME, 1, 50 )
195: INTO l_customer_name
196: FROM HZ_PARTIES PARTY,
197: HZ_CUST_ACCOUNTS CUST_ACCT
198: WHERE CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
199: AND CUST_ACCT.CUST_ACCOUNT_ID = p_customer_id;
200:
201: Return l_customer_name;