APPS.OKL_CONTRACT_PVT dependencies on OKL_PRODUCTS

Line 541: From okl_products pdt,

537: --Cursor to find out the product from_date and to_date
538: Cursor pdt_dts_csr(p_chr_id IN NUMBER) IS
539: Select pdt.from_date,
540: pdt.to_date
541: From okl_products pdt,
542: okl_k_headers khr
543: where pdt.id = khr.pdt_id
544: and khr.id = p_chr_id;
545:

Line 550: From okl_products pdt

546: -- Bug# 9115610 - Added cursor to get product effective dates
547: CURSOR c_pdt_dts_csr(p_pdt_id IN NUMBER) IS
548: SELECT pdt.from_date,
549: pdt.to_date
550: From okl_products pdt
551: WHERE pdt.id = p_pdt_id;
552:
553: l_pdt_to_date okl_products.to_date%TYPE;
554: l_pdt_from_date okl_products.from_date%TYPE;

Line 553: l_pdt_to_date okl_products.to_date%TYPE;

549: pdt.to_date
550: From okl_products pdt
551: WHERE pdt.id = p_pdt_id;
552:
553: l_pdt_to_date okl_products.to_date%TYPE;
554: l_pdt_from_date okl_products.from_date%TYPE;
555:
556: l_new_start_date date;
557: l_new_end_date date;

Line 554: l_pdt_from_date okl_products.from_date%TYPE;

550: From okl_products pdt
551: WHERE pdt.id = p_pdt_id;
552:
553: l_pdt_to_date okl_products.to_date%TYPE;
554: l_pdt_from_date okl_products.from_date%TYPE;
555:
556: l_new_start_date date;
557: l_new_end_date date;
558:

Line 1784: From OKL_PRODUCTS_V

1780:
1781: --cursor to get product name for exception conditions
1782: Cursor get_pdtname_csr (pdtid in Number) is
1783: Select name
1784: From OKL_PRODUCTS_V
1785: Where id = pdtid;
1786:
1787: l_pdt_name OKL_PRODUCTS_V.NAME%TYPE default null;
1788:

Line 1787: l_pdt_name OKL_PRODUCTS_V.NAME%TYPE default null;

1783: Select name
1784: From OKL_PRODUCTS_V
1785: Where id = pdtid;
1786:
1787: l_pdt_name OKL_PRODUCTS_V.NAME%TYPE default null;
1788:
1789: --Bug#2727161 : 11.5.9 Rebooks - product can not be modified
1790: -- cursor to get product of the original contract
1791: Cursor ger_orig_pdt_csr(p_rbk_chr_id IN NUMBER) is