70: SELECT cust_acct.cust_account_id customer_id ,
71: cust_acct.account_number ,
72: party.party_name ,
73: party.tax_reference
74: FROM hz_cust_accounts cust_acct,
75: hz_parties party
76: WHERE cust_acct.party_id = party.party_id
77: AND (p_customer_name_from is null or
78: upper(party.party_name) >= upper(p_customer_name_from))