DBA Data[Home] [Help]

APPS.OKL_ACCOUNT_DIST_PVT dependencies on OKL_TRNS_ACC_DSTRS_ALL

Line 2596: FROM OKL_TRNS_ACC_DSTRS_ALL

2592: CURSOR dist_exists_csr(p_source_id NUMBER,
2593: p_source_table VARCHAR2)
2594: IS
2595: SELECT 1
2596: FROM OKL_TRNS_ACC_DSTRS_ALL
2597: WHERE SOURCE_ID = p_source_id
2598: AND SOURCE_TABLE = p_source_table;
2599:
2600: CURSOR get_ext_hdr_csr(p_source_id NUMBER)

Line 5160: FROM okl_trns_acc_dstrs_all dist,

5156:
5157: CURSOR get_acc_event_id(p_tcn_id IN NUMBER)
5158: IS
5159: SELECT distinct dist.accounting_event_id
5160: FROM okl_trns_acc_dstrs_all dist,
5161: okl_txl_cntrct_lns_all txl,
5162: okl_trx_contracts_all trx
5163: WHERE dist.source_id = txl.id
5164: AND txl.tcn_id = trx.id