161: ,1
162: ,50)
163: INTO RP_CUSTOMER
164: FROM
165: HZ_PARTIES PARTY,
166: HZ_CUST_ACCOUNTS CUST_ACCT
167: WHERE CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
168: AND CUST_ACCT.CUST_ACCOUNT_ID = P_CUSTOMER_ID;
169: EXCEPTION