DBA Data[Home] [Help]

APPS.OKL_MASS_REBOOK_PVT dependencies on OKL_STRM_TYPE_V

Line 3147: okl_strm_type_v TYPE

3143: --Changed Stream Type Subclass to 'INVESTOR_DISBURSEMENT'
3144: CURSOR disb_strm_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
3145: SELECT strm.id
3146: FROM okl_streams strm,
3147: okl_strm_type_v TYPE
3148: WHERE TYPE.id = strm.sty_id
3149: AND TYPE.stream_type_subclass = 'INVESTOR_DISBURSEMENT'
3150: AND strm.khr_id = p_chr_id
3151: AND strm.say_code = 'CURR';

Line 3157: okl_strm_type_v TYPE

3153:
3154: CURSOR accu_strm_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
3155: SELECT strm.id
3156: FROM okl_streams strm,
3157: okl_strm_type_v TYPE
3158: WHERE TYPE.id = strm.sty_id
3159: AND TYPE.stream_type_purpose IN (
3160: 'INVESTOR_RENTAL_ACCRUAL',
3161: 'INVESTOR_PRE_TAX_INCOME',