APPS.OKL_STRM_GEN_TEMPLATE_PVT dependencies on OKL_PRODUCTS

Line 281: FROM OKL_PRODUCTS PDT,

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

Line 313: okl_products pdt

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

Line 854: okl_products pdt

850: from okc_k_headers_b chr,
851: okl_k_headers khr,
852: okl_ae_tmpt_Sets aes,
853: okl_st_gen_templates gtt,
854: okl_products pdt
855: where pdt.id = khr.pdt_id
856: and pdt.aes_id = aes.id
857: and aes.gts_id = gtt.gts_id
858: and khr.id = chr.id

Line 4595: FROM OKL_PRODUCTS PDT,

4591: CURSOR pdt_for_active_sgt_csr( p_gts_id OKL_ST_GEN_TMPT_SETS.ID%TYPE )
4592: IS
4593: SELECT PDT.ID PDT_ID
4594: ,PRODUCT_STATUS_CODE
4595: FROM OKL_PRODUCTS PDT,
4596: OKL_AE_TMPT_SETS ATS, OKL_ST_GEN_TMPT_SETS SGT
4597: WHERE PDT.AES_ID = ATS.ID
4598: AND ATS.GTS_ID = SGT.ID
4599: AND SGT.ID = p_gts_id;

Line 4880: FROM OKL_PRODUCTS PDT,

4876: CURSOR pdt_for_active_sgt_csr( p_gts_id OKL_ST_GEN_TMPT_SETS.ID%TYPE )
4877: IS
4878: SELECT PDT.ID PDT_ID
4879: ,PRODUCT_STATUS_CODE
4880: FROM OKL_PRODUCTS PDT,
4881: OKL_AE_TMPT_SETS ATS,
4882: OKL_ST_GEN_TMPT_SETS SGT
4883: WHERE PDT.AES_ID = ATS.ID
4884: AND ATS.GTS_ID = SGT.ID