DBA Data[Home] [Help]

APPS.WSH_WSHRDSDL_XMLP_PKG dependencies on HZ_CUST_ACCOUNTS

Line 203: HZ_CUST_ACCOUNTS CUST_ACCT

199: WHERE PARTY.PARTY_ID = (
200: SELECT
201: CUST_ACCT.PARTY_ID
202: FROM
203: HZ_CUST_ACCOUNTS CUST_ACCT
204: WHERE CUST_ACCT.CUST_ACCOUNT_ID = P_CUSTOMER_NAME_LOW );
205: END IF;
206: IF (P_CUSTOMER_NAME_HIGH IS NOT NULL) THEN
207: SELECT

Line 218: HZ_CUST_ACCOUNTS CUST_ACCT

214: WHERE PARTY.PARTY_ID = (
215: SELECT
216: CUST_ACCT.PARTY_ID
217: FROM
218: HZ_CUST_ACCOUNTS CUST_ACCT
219: WHERE CUST_ACCT.CUST_ACCOUNT_ID = P_CUSTOMER_NAME_HIGH );
220: END IF;
221: IF ((P_CUSTOMER_NAME_LOW IS NOT NULL) AND (P_CUSTOMER_NAME_HIGH IS NOT NULL)) THEN
222: IF (P_CUSTOMER_NAME_LOW = P_CUSTOMER_NAME_HIGH) THEN