[Home] [Help]
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)
5152:
5153: CURSOR get_acc_event_id(p_tcn_id IN NUMBER)
5154: IS
5155: SELECT distinct dist.accounting_event_id
5156: FROM okl_trns_acc_dstrs_all dist,
5157: okl_txl_cntrct_lns_all txl,
5158: okl_trx_contracts_all trx
5159: WHERE dist.source_id = txl.id
5160: AND txl.tcn_id = trx.id