APPS.OKL_SETUPPRODUCTS_PVT dependencies on OKL_ST_GEN_TEMPLATES

Line 1899: l_gtt_id OKL_ST_GEN_TEMPLATES.ID%TYPE;

1895: l_deal_type VARCHAR2(150);
1896: l_deal_type1 VARCHAR2(40);
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

Line 1960: OKL_ST_GEN_TEMPLATES GTTV,

1956: CURSOR c_st_gen_templates_cur (p_pdt_id IN okl_products_v.id%TYPE)
1957: IS
1958: SELECT gttv.id gtt_id, gtsv.name name, gttv.version version
1959: FROM
1960: OKL_ST_GEN_TEMPLATES GTTV,
1961: OKL_ST_GEN_TMPT_SETS GTSV,
1962:
1963: okl_ae_tmpt_sets_v AES,
1964: okl_products_v PDT

Line 1973: CURSOR c_st_gen_template_lns_cur(p_gtt_id IN OKL_ST_GEN_TEMPLATES.id%TYPE,

1969: AES.id = PDT.aes_id AND
1970: PDT.id = p_pdt_id AND
1971: GTSV.product_type ='FINANCIAL';
1972:
1973: CURSOR c_st_gen_template_lns_cur(p_gtt_id IN OKL_ST_GEN_TEMPLATES.id%TYPE,
1974: p_tax_upfront_sty_id IN OKL_SYSTEM_PARAMS.tax_upfront_sty_id%TYPE)
1975: IS
1976: SELECT GTLV.PRIMARY_STY_ID
1977: FROM

Line 1978: OKL_ST_GEN_TEMPLATES GTTV,

1974: p_tax_upfront_sty_id IN OKL_SYSTEM_PARAMS.tax_upfront_sty_id%TYPE)
1975: IS
1976: SELECT GTLV.PRIMARY_STY_ID
1977: FROM
1978: OKL_ST_GEN_TEMPLATES GTTV,
1979: OKL_ST_GEN_TMPT_LNS GTLV
1980: WHERE
1981: GTTV.ID = p_gtt_id AND
1982: GTTV.ID = GTLV.gtt_id AND