46: CURSOR c_get_btc_irm_id(cp_btc_id IN VARCHAR2) IS
47: SELECT irm_id,
48: batch_total,
49: date_gl_requested
50: FROM okl_trx_csh_batch_v a
51: WHERE a.id = cp_btc_id;
52:
53: -- get org_id for contract
54: CURSOR c_get_org_id(cp_contract_num IN VARCHAR2) IS
61: SELECT date_gl_requested,
62: a.irm_id,
63: 'x',
64: trx_status_code
65: FROM okl_trx_csh_batch_v a,
66: okl_trx_csh_receipt_v b
67: WHERE a.id = cp_btc_id
68: AND a.id = b.btc_id
69: AND rownum = 1;
316: --cursor to get batch level details from db
317: CURSOR c_get_btc_dtls(cp_btc_id IN VARCHAR2) IS
318: SELECT date_gl_requested,
319: a.irm_id
320: FROM okl_trx_csh_batch_v a,
321: okl_trx_csh_receipt_v b
322: WHERE a.id = cp_btc_id
323: AND a.id = b.btc_id
324: AND rownum = 1;
541: --cursor to get batch level details from db
542: CURSOR c_get_btc_dtls(cp_btc_id IN VARCHAR2) IS
543: SELECT date_gl_requested,
544: a.irm_id
545: FROM okl_trx_csh_batch_v a,
546: okl_trx_csh_receipt_v b
547: WHERE a.id = cp_btc_id
548: AND a.id = b.btc_id
549: AND rownum = 1;
976: CURSOR c_get_btc_irm_id(cp_btc_id IN VARCHAR2) IS
977: SELECT irm_id,
978: batch_total,
979: date_gl_requested
980: FROM okl_trx_csh_batch_v a
981: WHERE a.id = cp_btc_id;
982:
983: ----------
984:
992:
993: -- get new batch details
994: CURSOR c_get_btc_dtls(cp_btc_id IN VARCHAR2) IS
995: SELECT 'x'
996: FROM okl_trx_csh_batch_v a,
997: okl_trx_csh_receipt_v b
998: WHERE a.id = cp_btc_id
999: AND a.id = b.btc_id
1000: AND rownum = 1;