DBA Data[Home] [Help]

APPS.OKL_SETUPPRODUCTS_PVT dependencies on OKL_K_HEADERS_V

Line 306: FROM Okl_K_Headers_V khr,

302: p_from_date IN Okl_Products_V.FROM_DATE%TYPE,
303: p_to_date IN Okl_Products_V.TO_DATE%TYPE
304: ) IS
305: SELECT '1'
306: FROM Okl_K_Headers_V khr,
307: Okl_K_Headers_Full_V khf
308: WHERE khr.PDT_ID = p_pdt_id
309: AND khf.ID = khr.ID
310: AND khf.START_DATE BETWEEN p_from_date AND p_to_date;

Line 315: SELECT '1' FROM okl_k_headers_v khdr

311:
312:
313: CURSOR okl_pdtv_chk(p_pdt_id NUMBER
314: ) IS
315: SELECT '1' FROM okl_k_headers_v khdr
316: WHERE khdr.pdt_id = p_pdt_id;
317:
318: CURSOR okl_pdt_constraints_csr (p_pdt_id IN Okl_Products_V.ID%TYPE,
319: p_from_date IN Okl_Products_V.FROM_DATE%TYPE,

Line 2009: FROM okl_k_headers_v khdr

2005: --rkuttiya added for 12.1.1 Multi GAAP Project
2006: --to check whether the reporting product is attached to any other contract
2007: CURSOR okl_rpt_pdtv_chk(p_pdt_id NUMBER) IS
2008: SELECT '1'
2009: FROM okl_k_headers_v khdr
2010: WHERE khdr.pdt_id = p_pdt_id;
2011: --
2012:
2013: /* Bug 7134895 */