DBA Data[Home] [Help]

APPS.OKL_MASS_REBOOK_PVT dependencies on OKL_STRM_TYPE_V

Line 3271: okl_strm_type_v TYPE

3267: --Changed Stream Type Subclass to 'INVESTOR_DISBURSEMENT'
3268: CURSOR disb_strm_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
3269: SELECT strm.id
3270: FROM okl_streams strm,
3271: okl_strm_type_v TYPE
3272: WHERE TYPE.id = strm.sty_id
3273: AND TYPE.stream_type_subclass = 'INVESTOR_DISBURSEMENT'
3274: AND strm.khr_id = p_chr_id
3275: AND strm.say_code = 'CURR';

Line 3281: okl_strm_type_v TYPE

3277:
3278: CURSOR accu_strm_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
3279: SELECT strm.id
3280: FROM okl_streams strm,
3281: okl_strm_type_v TYPE
3282: WHERE TYPE.id = strm.sty_id
3283: AND TYPE.stream_type_purpose IN (
3284: 'INVESTOR_RENTAL_ACCRUAL',
3285: 'INVESTOR_PRE_TAX_INCOME',