APPS.OKL_SETUPPRODUCTS_PVT dependencies on OKL_ST_GEN_TMPT_LNS

Line 1883: l_primary_sty_id OKL_ST_GEN_TMPT_LNS.primary_sty_id%TYPE;

1879: l_deal_type1 VARCHAR2(40);
1880: l_chk_bc VARCHAR2(100);
1881: l_tax_upfront_sty_id OKL_SYSTEM_PARAMS.tax_upfront_sty_id%TYPE;
1882: l_gtt_id OKL_ST_GEN_TEMPLATES.ID%TYPE;
1883: l_primary_sty_id OKL_ST_GEN_TMPT_LNS.primary_sty_id%TYPE;
1884: l_stream_name okl_strm_type_v.styb_purpose_meaning%TYPE;
1885:
1886: -- Cursor to fetch the Product Quality Values
1887: CURSOR get_pp_csr(p_pdt_id NUMBER)

Line 1962: OKL_ST_GEN_TMPT_LNS GTLV

1958: IS
1959: SELECT GTLV.PRIMARY_STY_ID
1960: FROM
1961: OKL_ST_GEN_TEMPLATES GTTV,
1962: OKL_ST_GEN_TMPT_LNS GTLV
1963: WHERE
1964: GTTV.ID = p_gtt_id AND
1965: GTTV.ID = GTLV.gtt_id AND
1966: GTLV.PRIMARY_STY_ID = p_tax_upfront_sty_id AND