APPS.OKL_QA_DATA_INTEGRITY dependencies on OKL_K_HEADERS

Line 145: CURSOR l_hdr_csr(chrid OKL_K_HEADERS.KHR_ID%TYPE) IS

141: From okl_supp_invoice_dtls inv
142: Where inv.fa_cle_id = faid;
143:
144: --Bug#3877032
145: CURSOR l_hdr_csr(chrid OKL_K_HEADERS.KHR_ID%TYPE) IS
146: SELECT chr.SCS_CODE,
147: chr.START_DATE,
148: chr.DATE_SIGNED,
149: chr.CURRENCY_CODE,

Line 158: OKL_K_HEADERS khr,

154: khr.DEAL_TYPE,
155: khr.term_duration term,
156: nvl(pdt.reporting_pdt_id, -1) report_pdt_id
157: FROM OKC_K_HEADERS_B chr,
158: OKL_K_HEADERS khr,
159: OKL_PRODUCTS_V pdt
160: WHERE chr.id = chrid
161: AND chr.id = khr.id
162: --AND khr.pdt_id = pdt.id(+);

Line 174: CURSOR l_topsvclne_csr(ltycode VARCHAR2, chrid OKL_K_HEADERS.KHR_ID%TYPE, lineId NUMBER) IS

170: AND ls.lty_code = 'FREE_FORM1'
171: AND kle.name = n;
172: l_ln l_line_name%ROWTYPE;
173:
174: CURSOR l_topsvclne_csr(ltycode VARCHAR2, chrid OKL_K_HEADERS.KHR_ID%TYPE, lineId NUMBER) IS
175: SELECT cle.id,
176: sub_kle.price_negotiated amount
177: FROM OKC_K_LINES_B cle,
178: OKC_K_LINES_B sub_kle,

Line 189: CURSOR l_svclne_csr(ltycode VARCHAR2, chrid OKL_K_HEADERS.KHR_ID%TYPE) IS

185: AND sub_kle.id = lineId
186: AND cle.id = sub_kle.cle_id
187: AND sts.ste_code not in ( 'HOLD', 'TERMINATED', 'EXPIRED', 'CANCELLED');
188:
189: CURSOR l_svclne_csr(ltycode VARCHAR2, chrid OKL_K_HEADERS.KHR_ID%TYPE) IS
190: SELECT cle.id,
191: cle.price_negotiated amount
192: FROM OKC_K_LINES_B cle,
193: OKC_LINE_STYLES_B ls,

Line 201: CURSOR l_toplne_csr(ltycode VARCHAR2, chrid OKL_K_HEADERS.KHR_ID%TYPE, lineId NUMBER) IS

197: AND cle.dnz_chr_id = chrid
198: AND sts.code = cle.sts_code
199: AND sts.ste_code not in ( 'HOLD', 'TERMINATED', 'EXPIRED', 'CANCELLED');
200:
201: CURSOR l_toplne_csr(ltycode VARCHAR2, chrid OKL_K_HEADERS.KHR_ID%TYPE, lineId NUMBER) IS
202: SELECT kle.name,
203: kle.CURRENCY_CODE,
204: kle.id,
205: kle.RESIDUAL_VALUE,

Line 227: CURSOR l_lne_csr(ltycode VARCHAR2, chrid OKL_K_HEADERS.KHR_ID%TYPE) IS

223: AND sub_kle.id = lineId
224: AND kle.id = sub_kle.cle_id
225: AND sts.ste_code not in ( 'HOLD', 'TERMINATED', 'EXPIRED', 'CANCELLED');
226:
227: CURSOR l_lne_csr(ltycode VARCHAR2, chrid OKL_K_HEADERS.KHR_ID%TYPE) IS
228: SELECT kle.name,
229: kle.amount,
230: kle.CURRENCY_CODE,
231: kle.id,

Line 459: FROM okl_products prod, okl_k_headers_full_v khr

455: AND tl.LANGUAGE = 'US';
456:
457: CURSOR l_product_csr (p_chr_id number) IS
458: SELECT khr.pdt_id, khr.start_date, prod.reporting_pdt_id
459: FROM okl_products prod, okl_k_headers_full_v khr
460: WHERE khr.ID = p_chr_id AND prod.ID = khr.pdt_id;
461:
462:
463: CURSOR l_rep_strm_csr (rep_pdt_id number,styid number,primary_sty_purpose