APPS.IEX_BUS_EVENT_SUB_PVT dependencies on HZ_CUST_ACCOUNTS

Line 623: from hz_cust_accounts

619: cursor c_uwq_level(p_account_id number) is
620: select business_level
621: from iex_dln_uwq_summary
622: where party_id = (select party_id
623: from hz_cust_accounts
624: where cust_account_id=p_account_id);
625: /*CURSOR select_pref IS SELECT PREFERENCE_VALUE FROM IEX_APP_PREFERENCES_VL
626: WHERE PREFERENCE_NAME = 'COLLECTIONS STRATEGY LEVEL';*/
627: --end mls

Line 829: FROM AR_TRX_BAL_SUMMARY trx_summ, hz_cust_accounts acc,hz_parties party,

825: max(gl.CURRENCY_CODE) last_payment_amount_curr,
826: MAX(iex_uwq_view_pkg.get_last_payment_number(party.party_id, 0, 0)) last_payment_number,
827: party.party_id party_id,
828: trx_summ.org_id org_id
829: FROM AR_TRX_BAL_SUMMARY trx_summ, hz_cust_accounts acc,hz_parties party,
830: GL_SETS_OF_BOOKS gl,
831: AR_SYSTEM_PARAMETERS_all sys
832: WHERE
833: gl.SET_OF_BOOKS_ID = sys.SET_OF_BOOKS_ID