APPS.OKL_STREAMS_UTIL dependencies on OKL_ST_GEN_TMPT_SETS

Line 1851: OKL_ST_GEN_TMPT_SETS gts

1847: FROM
1848: okl_k_headers khr,
1849: okl_products_v pdt,
1850: okl_ae_tmpt_sets_v aes,
1851: OKL_ST_GEN_TMPT_SETS gts
1852: WHERE
1853: khr.pdt_id = pdt.id AND
1854: pdt.aes_id = aes.id AND
1855: aes.gts_id = gts.id AND

Line 1858: l_pricing_engine okl_st_gen_tmpt_sets.pricing_engine%TYPE;

1854: pdt.aes_id = aes.id AND
1855: aes.gts_id = gts.id AND
1856: khr.id = p_khr_id;
1857:
1858: l_pricing_engine okl_st_gen_tmpt_sets.pricing_engine%TYPE;
1859:
1860: BEGIN
1861:
1862: OPEN prc_eng_csr;

Line 1903: OKL_ST_GEN_TMPT_SETS gts

1899: FROM
1900: okl_k_headers khr,
1901: okl_products_v pdt,
1902: okl_ae_tmpt_sets_v aes,
1903: OKL_ST_GEN_TMPT_SETS gts
1904: WHERE
1905: khr.pdt_id = pdt.id AND
1906: pdt.aes_id = aes.id AND
1907: aes.gts_id = gts.id AND

Line 1910: l_pricing_engine okl_st_gen_tmpt_sets.pricing_engine%TYPE;

1906: pdt.aes_id = aes.id AND
1907: aes.gts_id = gts.id AND
1908: khr.id = p_khr_id;
1909:
1910: l_pricing_engine okl_st_gen_tmpt_sets.pricing_engine%TYPE;
1911: l_st_tmpt_name okl_st_gen_tmpt_sets.name%TYPE;
1912:
1913: BEGIN
1914: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 1911: l_st_tmpt_name okl_st_gen_tmpt_sets.name%TYPE;

1907: aes.gts_id = gts.id AND
1908: khr.id = p_khr_id;
1909:
1910: l_pricing_engine okl_st_gen_tmpt_sets.pricing_engine%TYPE;
1911: l_st_tmpt_name okl_st_gen_tmpt_sets.name%TYPE;
1912:
1913: BEGIN
1914: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1915:

Line 2895: ,okl_st_gen_tmpt_sets_all gts

2891: ,okc_k_headers_all_b chr
2892: ,okl_k_headers khr
2893: ,okl_products pdt
2894: ,okl_ae_tmpt_sets_all aes
2895: ,okl_st_gen_tmpt_sets_all gts
2896: Where sao.org_id = chr.authoring_org_id
2897: and chr.id = osi.khr_id
2898: and osi.transaction_number = p_trx_number
2899: and chr.id = khr.id

Line 3029: ,okl_st_gen_tmpt_sets_all gts

3025: from okc_k_headers_all_b chr
3026: ,okl_k_headers khr
3027: ,okl_products pdt
3028: ,okl_ae_tmpt_sets_all aes
3029: ,okl_st_gen_tmpt_sets_all gts
3030: Where chr.id = p_khr_id
3031: and chr.id = khr.id
3032: and khr.pdt_id = pdt.id
3033: and pdt.aes_id = aes.id

Line 3152: ,okl_st_gen_tmpt_sets_all gts

3148: ,okc_k_headers_all_b chr
3149: ,okl_k_headers khr
3150: ,okl_products pdt
3151: ,okl_ae_tmpt_sets_all aes
3152: ,okl_st_gen_tmpt_sets_all gts
3153: WHERE osi.transaction_number = p_trx_id
3154: AND siyb.sif_id = osi.id
3155: AND siyb.target_value IS NOT NULL
3156: AND chr.id = osi.khr_id