APPS.OKL_SETUPPRODUCTS_PVT dependencies on OKL_SYSTEM_PARAMS

Line 1881: l_tax_upfront_sty_id OKL_SYSTEM_PARAMS.tax_upfront_sty_id%TYPE;

1877: --rkuttiya added for Multi GAAP Project
1878: l_deal_type VARCHAR2(150);
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:

Line 1937: FROM OKL_SYSTEM_PARAMS;

1933: AND pqy.name IN('LEASE','INVESTOR');
1934:
1935: CURSOR c_tax_sty_id_cur IS
1936: SELECT tax_upfront_sty_id
1937: FROM OKL_SYSTEM_PARAMS;
1938:
1939: CURSOR c_st_gen_templates_cur (p_pdt_id IN okl_products_v.id%TYPE)
1940: IS
1941: SELECT gttv.id gtt_id, gtsv.name name, gttv.version version

Line 1957: p_tax_upfront_sty_id IN OKL_SYSTEM_PARAMS.tax_upfront_sty_id%TYPE)

1953: PDT.id = p_pdt_id AND
1954: GTSV.product_type ='FINANCIAL';
1955:
1956: CURSOR c_st_gen_template_lns_cur(p_gtt_id IN OKL_ST_GEN_TEMPLATES.id%TYPE,
1957: p_tax_upfront_sty_id IN OKL_SYSTEM_PARAMS.tax_upfront_sty_id%TYPE)
1958: IS
1959: SELECT GTLV.PRIMARY_STY_ID
1960: FROM
1961: OKL_ST_GEN_TEMPLATES GTTV,