[Home] [Help]
270: SELECT party_id
271: INTO l_party_id
272: FROM hz_cust_accounts
273: WHERE cust_account_id IN (SELECT client_id
274: FROM mtl_client_parameters
275: WHERE client_code = P_client_code);
276: else
277:
278: select location_id