7: CUST_ACCT.ACCOUNT_NUMBER
8: INTO CNUM
9: FROM
10: HZ_PARTIES PARTY,
11: HZ_CUST_ACCOUNTS CUST_ACCT
12: WHERE PARTY.PARTY_ID = CUST_ACCT.PARTY_ID
13: AND CUST_ACCT.CUST_ACCOUNT_ID = CUSTOMER_ID;
14: RETURN (CNUM);
15: EXCEPTION
281: WHERE PARTY.PARTY_ID = (
282: SELECT
283: CUST_ACCT.PARTY_ID
284: FROM
285: HZ_CUST_ACCOUNTS CUST_ACCT
286: WHERE CUST_ACCT.CUST_ACCOUNT_ID = P_CUSTOMER );
287: CP_CUSTOMER := CNAME;
288: ELSE
289: CP_CUSTOMER := P_CUSTOMER;