APPS.OKL_STRM_GEN_TEMPLATE_PVT dependencies on OKL_PRODUCTS

Line 280: FROM OKL_PRODUCTS PDT,

276: CURSOR pdt_for_active_sgt_csr( p_gts_id OKL_ST_GEN_TMPT_SETS.ID%TYPE )
277: IS
278: SELECT PDT.ID PDT_ID
279: ,PRODUCT_STATUS_CODE
280: FROM OKL_PRODUCTS PDT,
281: OKL_AE_TMPT_SETS ATS, OKL_ST_GEN_TMPT_SETS SGT
282: WHERE PDT.AES_ID = ATS.ID
283: AND ATS.GTS_ID = SGT.ID
284: AND SGT.ID = p_gts_id;

Line 312: okl_products pdt

308: from okc_k_headers_b chr,
309: okl_k_headers khr,
310: okl_ae_tmpt_Sets aes,
311: okl_st_gen_templates gtt,
312: okl_products pdt
313: where pdt.id = khr.pdt_id
314: and pdt.aes_id = aes.id
315: and aes.gts_id = gtt.gts_id
316: and khr.id = chr.id

Line 840: okl_products pdt

836: from okc_k_headers_b chr,
837: okl_k_headers khr,
838: okl_ae_tmpt_Sets aes,
839: okl_st_gen_templates gtt,
840: okl_products pdt
841: where pdt.id = khr.pdt_id
842: and pdt.aes_id = aes.id
843: and aes.gts_id = gtt.gts_id
844: and khr.id = chr.id

Line 4580: FROM OKL_PRODUCTS PDT,

4576: CURSOR pdt_for_active_sgt_csr( p_gts_id OKL_ST_GEN_TMPT_SETS.ID%TYPE )
4577: IS
4578: SELECT PDT.ID PDT_ID
4579: ,PRODUCT_STATUS_CODE
4580: FROM OKL_PRODUCTS PDT,
4581: OKL_AE_TMPT_SETS ATS, OKL_ST_GEN_TMPT_SETS SGT
4582: WHERE PDT.AES_ID = ATS.ID
4583: AND ATS.GTS_ID = SGT.ID
4584: AND SGT.ID = p_gts_id;

Line 4865: FROM OKL_PRODUCTS PDT,

4861: CURSOR pdt_for_active_sgt_csr( p_gts_id OKL_ST_GEN_TMPT_SETS.ID%TYPE )
4862: IS
4863: SELECT PDT.ID PDT_ID
4864: ,PRODUCT_STATUS_CODE
4865: FROM OKL_PRODUCTS PDT,
4866: OKL_AE_TMPT_SETS ATS,
4867: OKL_ST_GEN_TMPT_SETS SGT
4868: WHERE PDT.AES_ID = ATS.ID
4869: AND ATS.GTS_ID = SGT.ID