DBA Data[Home] [Help]

APPS.IEX_BUS_EVENT_SUB_PVT dependencies on GL_SETS_OF_BOOKS

Line 690: GL_SETS_OF_BOOKS gl,

686: MAX(iex_uwq_view_pkg.get_last_payment_number(0, 0, trx_summ.site_use_id)) last_payment_number,
687: trx_summ.site_use_id,
688: trx_summ.org_id
689: FROM AR_TRX_BAL_SUMMARY trx_summ,
690: GL_SETS_OF_BOOKS gl,
691: AR_SYSTEM_PARAMETERS_all sys
692: WHERE
693: gl.SET_OF_BOOKS_ID = sys.SET_OF_BOOKS_ID
694: AND sys.org_id = trx_summ.org_id

Line 760: GL_SETS_OF_BOOKS gl,

756: MAX(iex_uwq_view_pkg.get_last_payment_number(0, trx_summ.cust_account_id, 0)) last_payment_number,
757: TRX_SUMM.cust_account_id,
758: TRX_SUMM.org_id
759: FROM AR_TRX_BAL_SUMMARY TRX_SUMM,
760: GL_SETS_OF_BOOKS gl,
761: AR_SYSTEM_PARAMETERS_all sys
762: WHERE
763: gl.SET_OF_BOOKS_ID = sys.SET_OF_BOOKS_ID
764: AND sys.org_id = trx_summ.org_id

Line 830: GL_SETS_OF_BOOKS gl,

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
834: AND sys.org_id = trx_summ.org_id