APPS.WMS_RULES_WORKBENCH_PVT dependencies on HZ_CUST_ACCOUNTS

Line 174: hz_cust_accounts cust_acct

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

Line 190: HZ_CUST_ACCOUNTS CUST_ACCT

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

Line 198: HZ_CUST_ACCOUNTS CUST_ACCT

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