APPS.OKL_SEC_AGREEMENT_PVT dependencies on OKL_PRODUCTS_V

Line 179: CURSOR Product_csr (p_contract_id IN okl_products_v.id%TYPE) IS

175: and rgp.dnz_chr_id = chrId );
176:
177: l_custBillTo_rec custBillTo_csr%ROWTYPE;
178: */
179: CURSOR Product_csr (p_contract_id IN okl_products_v.id%TYPE) IS
180: SELECT pdt.id product_id
181: ,pdt.name product_name
182: ,khr.sts_code contract_status
183: ,khr.start_date start_date

Line 191: FROM okl_products_v pdt

187: ,khr.currency_conversion_type currency_conversion_type
188: ,khr.currency_conversion_date currency_conversion_date
189: --Bug# 4622198
190: ,khr.scs_code
191: FROM okl_products_v pdt
192: ,okl_k_headers_full_v khr
193: WHERE khr.id = p_contract_id
194: AND khr.pdt_id = pdt.id;
195:

Line 974: FROM okl_products_v

970: l_row_not_found BOOLEAN := FALSE;
971:
972: CURSOR c_pdt IS
973: SELECT 'x'
974: FROM okl_products_v
975: WHERE id = p_secAgreement_rec.pdt_id
976: ;
977:
978: BEGIN