201: WHERE PARTY.PARTY_ID = (
202: SELECT
203: CUST_ACCT.PARTY_ID
204: FROM
205: HZ_CUST_ACCOUNTS CUST_ACCT
206: WHERE CUST_ACCT.CUST_ACCOUNT_ID = P_CUSTOMER_NAME_LOW );
207: END IF;
208: IF (P_CUSTOMER_NAME_HIGH IS NOT NULL) THEN
209: SELECT
216: WHERE PARTY.PARTY_ID = (
217: SELECT
218: CUST_ACCT.PARTY_ID
219: FROM
220: HZ_CUST_ACCOUNTS CUST_ACCT
221: WHERE CUST_ACCT.CUST_ACCOUNT_ID = P_CUSTOMER_NAME_HIGH );
222: END IF;
223: ELSE
224: IF (P_CUSTOMER_NAME_LOW IS NOT NULL) THEN