APPS.INV_ONHAND_BALANCE dependencies on HZ_CUST_ACCOUNTS

Line 86: FROM hz_cust_accounts

82: SELECT trading_partner_site_id
83: INTO l_Party_Site_ID
84: FROM mtl_client_parameters
85: WHERE client_id IN (SELECT cust_account_id
86: FROM hz_cust_accounts
87: WHERE party_id = P_txn_hist_record.trading_partner_id);
88:
89:
90: ELSE

Line 358: FROM hz_cust_accounts

354: l_curr_txn_hist_record.Client_Code := P_client_code;
355:
356: SELECT party_id
357: INTO l_party_id
358: FROM hz_cust_accounts
359: WHERE cust_account_id IN (SELECT client_id
360: FROM mtl_client_parameters
361: WHERE client_code = P_client_code);
362: else