APPS.OKL_SETUPPRODUCTS_PVT dependencies on OKL_STRM_TYPE_V

Line 1901: l_stream_name okl_strm_type_v.styb_purpose_meaning%TYPE;

1897: l_chk_bc VARCHAR2(100);
1898: l_tax_upfront_sty_id OKL_SYSTEM_PARAMS.tax_upfront_sty_id%TYPE;
1899: l_gtt_id OKL_ST_GEN_TEMPLATES.ID%TYPE;
1900: l_primary_sty_id OKL_ST_GEN_TMPT_LNS.primary_sty_id%TYPE;
1901: l_stream_name okl_strm_type_v.styb_purpose_meaning%TYPE;
1902:
1903: -- Cursor to fetch the Product Quality Values
1904: CURSOR get_pp_csr(p_pdt_id NUMBER)
1905: IS

Line 1986: CURSOR c_stream_name(p_id IN okl_strm_type_v.ID%TYPE)

1982: GTTV.ID = GTLV.gtt_id AND
1983: GTLV.PRIMARY_STY_ID = p_tax_upfront_sty_id AND
1984: GTLV.PRIMARY_YN = 'Y' ;
1985:
1986: CURSOR c_stream_name(p_id IN okl_strm_type_v.ID%TYPE)
1987: IS
1988: SELECT styb_purpose_meaning
1989: FROM okl_strm_type_v
1990: WHERE ID = p_id;

Line 1989: FROM okl_strm_type_v

1985:
1986: CURSOR c_stream_name(p_id IN okl_strm_type_v.ID%TYPE)
1987: IS
1988: SELECT styb_purpose_meaning
1989: FROM okl_strm_type_v
1990: WHERE ID = p_id;
1991:
1992: -- Bug 6803437: Start
1993: -- Cursor to fetch the Reporting Product Status