APPS.OKL_GTL_PVT dependencies on OKL_STRM_TYPE_V

Line 148: FROM OKL_STRM_TYPE_V

144: CURSOR gtl_pri_dup_csr( p_id OKL_ST_GEN_TMPT_LNS.ID%TYPE
145: ,p_gtt_id OKL_ST_GEN_TMPT_LNS.GTT_ID%TYPE
146: ,p_pri_sty_id OKL_ST_GEN_TMPT_LNS.PRIMARY_STY_ID%TYPE) IS
147: SELECT NAME stream_name
148: FROM OKL_STRM_TYPE_V
149: WHERE ID IN
150: (
151: SELECT primary_Sty_id
152: FROM OKL_ST_GEN_TMPT_LNS GTL

Line 164: FROM OKL_STRM_TYPE_V

160: ,p_gtt_id OKL_ST_GEN_TMPT_LNS.GTT_ID%TYPE
161: ,p_pri_sty_id OKL_ST_GEN_TMPT_LNS.PRIMARY_STY_ID%TYPE
162: ,p_dep_sty_id OKL_ST_GEN_TMPT_LNS.DEPENDENT_STY_ID%TYPE) IS
163: SELECT NAME stream_name
164: FROM OKL_STRM_TYPE_V
165: WHERE ID IN
166: (
167: SELECT dependent_sty_id
168: FROM OKL_ST_GEN_TMPT_LNS GTL

Line 178: l_strm_name OKL_STRM_TYPE_V.NAME%TYPE;

174: );
175:
176:
177: l_found VARCHAR2(1);
178: l_strm_name OKL_STRM_TYPE_V.NAME%TYPE;
179: BEGIN
180: -- Get the gtt_id
181: IF( l_gtlv_rec.primary_yn = 'Y' )
182: THEN