DBA Data[Home] [Help]

APPS.IEX_BUS_EVENT_SUB_PVT dependencies on GL_SETS_OF_BOOKS

Line 679: GL_SETS_OF_BOOKS gl,

675: MAX(iex_uwq_view_pkg.get_last_payment_number(0, 0, trx_summ.site_use_id)) last_payment_number,
676: trx_summ.site_use_id,
677: trx_summ.org_id
678: FROM AR_TRX_BAL_SUMMARY trx_summ,
679: GL_SETS_OF_BOOKS gl,
680: AR_SYSTEM_PARAMETERS_all sys
681: WHERE
682: gl.SET_OF_BOOKS_ID = sys.SET_OF_BOOKS_ID
683: AND sys.org_id = trx_summ.org_id

Line 749: GL_SETS_OF_BOOKS gl,

745: MAX(iex_uwq_view_pkg.get_last_payment_number(0, trx_summ.cust_account_id, 0)) last_payment_number,
746: TRX_SUMM.cust_account_id,
747: TRX_SUMM.org_id
748: FROM AR_TRX_BAL_SUMMARY TRX_SUMM,
749: GL_SETS_OF_BOOKS gl,
750: AR_SYSTEM_PARAMETERS_all sys
751: WHERE
752: gl.SET_OF_BOOKS_ID = sys.SET_OF_BOOKS_ID
753: AND sys.org_id = trx_summ.org_id

Line 819: GL_SETS_OF_BOOKS gl,

815: MAX(iex_uwq_view_pkg.get_last_payment_number(party.party_id, 0, 0)) last_payment_number,
816: party.party_id party_id,
817: trx_summ.org_id org_id
818: FROM AR_TRX_BAL_SUMMARY trx_summ, hz_cust_accounts acc,hz_parties party,
819: GL_SETS_OF_BOOKS gl,
820: AR_SYSTEM_PARAMETERS_all sys
821: WHERE
822: gl.SET_OF_BOOKS_ID = sys.SET_OF_BOOKS_ID
823: AND sys.org_id = trx_summ.org_id