DBA Data[Home] [Help]

APPS.OKL_AUTO_CASH_APPL_RULES_PVT dependencies on OKL_STRM_TYP_ALLOCS

Line 191: FROM OKL_STRM_TYP_ALLOCS

187: -- Cursor to get the Stream type Id for the given allocation order.
188: CURSOR c_stream_alloc ( cp_str_all_type IN VARCHAR2
189: ,cp_cat_id IN NUMBER ) IS
190: SELECT sty_id
191: FROM OKL_STRM_TYP_ALLOCS
192: WHERE stream_allc_type = cp_str_all_type
193: AND cat_id = cp_cat_id
194: ORDER BY sequence_number;
195:

Line 1600: FROM OKL_STRM_TYP_ALLOCS

1596: -- get stream application order
1597: CURSOR c_stream_alloc ( cp_str_all_type IN VARCHAR2
1598: ,cp_cat_id IN NUMBER ) IS
1599: SELECT sty_id
1600: FROM OKL_STRM_TYP_ALLOCS
1601: WHERE stream_allc_type = cp_str_all_type
1602: AND cat_id = cp_cat_id
1603: ORDER BY sequence_number;
1604:

Line 2999: FROM OKL_STRM_TYP_ALLOCS

2995: -- get stream application order
2996: CURSOR c_stream_alloc ( cp_str_all_type IN VARCHAR2
2997: ,cp_cat_id IN NUMBER ) IS
2998: SELECT sty_id
2999: FROM OKL_STRM_TYP_ALLOCS
3000: WHERE stream_allc_type = cp_str_all_type
3001: AND cat_id = cp_cat_id
3002: ORDER BY sequence_number;
3003: