APPS.OKL_SEC_AGREEMENT_PVT dependencies on OKL_PRODUCTS

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

Line 1676: from okl_products

1672:
1673: -- racheruv .. R12.1.2 .. start
1674: select decode(reporting_pdt_id, NULL, NULL, 'Y')
1675: into lp_khrv_rec.multi_gaap_yn
1676: from okl_products
1677: where id = p_secAgreement_rec.PDT_ID;
1678: -- racheruv .. R12.1.2 end
1679:
1680: lp_khrv_rec.SECURITIZATION_TYPE := p_secAgreement_rec.SECURITIZATION_TYPE;

Line 2101: from okl_products a, okl_k_headers b

2097:
2098: -- racheruv .. R12.1.2 .. start
2099: select decode(reporting_pdt_id, NULL, NULL, 'Y')
2100: into lp_khrv_rec.multi_gaap_yn
2101: from okl_products a, okl_k_headers b
2102: where b.pdt_id = a.id
2103: and b.id = lp_chrv_rec.id;
2104: -- racheruv .. R12.1.2 end
2105: