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
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