APPS.OKL_TRANS_PRICING_PARAMS_PVT dependencies on OKL_ST_GEN_TMPT_SETS

Line 34: l_gts_id okl_st_gen_tmpt_sets.id%TYPE := p_gts_id;

30: IS
31: l_tpp_tbl tpp_tbl_type;
32: l_spmv_tbl spmv_tbl_type;
33: l_sif_id okl_sif_pricing_params.sif_id%TYPE := p_sif_id;
34: l_gts_id okl_st_gen_tmpt_sets.id%TYPE := p_gts_id;
35: l_chr_id okc_k_headers_b.id%TYPE := p_chr_id;
36: i NUMBER := 0;
37: j NUMBER := 0;
38: l_found VARCHAR2(1) := 'N';

Line 53: FROM okl_st_gen_tmpt_sets temp_set,

49:
50: CURSOR st_gen_prc_params(p_gts_id NUMBER) IS
51: SELECT pp.id, pp.name, pp.display_yn,pp.update_yn,
52: pp.default_value, pp.prc_eng_ident, pp.description
53: FROM okl_st_gen_tmpt_sets temp_set,
54: okl_st_gen_templates template,
55: okl_st_gen_prc_params pp
56: WHERE temp_set.id = template.gts_id
57: AND template.id = pp.gtt_id

Line 62: FROM OKL_ST_GEN_TMPT_SETS TST,

58: AND temp_set.id = p_gts_id;
59:
60: CURSOR get_gts_id(p_chr_id NUMBER) IS
61: SELECT TST.ID GTS_ID
62: FROM OKL_ST_GEN_TMPT_SETS TST,
63: OKL_AE_TMPT_SETS_V AES,
64: OKL_PRODUCTS_V PDT,
65: OKL_K_HEADERS KHR
66: WHERE TST.ID = AES.GTS_ID AND