APPS.OKL_TRX_CONTRACTS_PVT dependencies on OKL_PRODUCTS

Line 92: CURSOR cntr_prod_csr(pdt_id OKL_PRODUCTS.ID%TYPE) IS

88: ,p_tcnv_rec IN tcnv_rec_type
89: ,x_tcnv_rec OUT NOCOPY tcnv_rec_type) IS
90: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
91: -- Added by zrehman for SLA project (Bug 5707866) 15-Feb-2007 start
92: CURSOR cntr_prod_csr(pdt_id OKL_PRODUCTS.ID%TYPE) IS
93: SELECT name
94: FROM okl_products
95: WHERE id = pdt_id;
96:

Line 94: FROM okl_products

90: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
91: -- Added by zrehman for SLA project (Bug 5707866) 15-Feb-2007 start
92: CURSOR cntr_prod_csr(pdt_id OKL_PRODUCTS.ID%TYPE) IS
93: SELECT name
94: FROM okl_products
95: WHERE id = pdt_id;
96:
97: CURSOR book_csr(p_id OKL_PRODUCTS.ID%TYPE) IS
98: SELECT quality_val, quality_name

Line 97: CURSOR book_csr(p_id OKL_PRODUCTS.ID%TYPE) IS

93: SELECT name
94: FROM okl_products
95: WHERE id = pdt_id;
96:
97: CURSOR book_csr(p_id OKL_PRODUCTS.ID%TYPE) IS
98: SELECT quality_val, quality_name
99: FROM okl_prod_qlty_val_uv
100: WHERE pdt_id = p_id
101: AND QUALITY_NAME IN ('LEASE', 'INVESTOR');

Line 103: CURSOR tax_csr(p_id OKL_PRODUCTS.ID%TYPE) IS

99: FROM okl_prod_qlty_val_uv
100: WHERE pdt_id = p_id
101: AND QUALITY_NAME IN ('LEASE', 'INVESTOR');
102:
103: CURSOR tax_csr(p_id OKL_PRODUCTS.ID%TYPE) IS
104: SELECT quality_val
105: FROM okl_prod_qlty_val_uv
106: WHERE pdt_id = p_id
107: AND QUALITY_NAME = 'TAXOWNER';