505: CURSOR l_chk_mass_rbk_csr
506: IS
507: SELECT '1'
508: FROM okc_k_headers_b chrb,
509: okl_trx_contracts ktrx
510: WHERE chrb.ID = p_chr_id
511: AND ktrx.khr_id = chrb.id
512: AND ktrx.tsu_code = 'ENTERED'
513: AND ktrx.rbr_code IS NOT NULL
547: CURSOR l_chk_rbk_csr
548: IS
549: SELECT '1'
550: FROM okc_k_headers_b chrb,
551: okl_trx_contracts ktrx
552: WHERE ktrx.khr_id_new = chrb.id
553: AND ktrx.tsu_code = 'ENTERED'
554: AND ktrx.rbr_code IS NOT NULL
555: AND ktrx.tcn_type = 'TRBK'