DBA Data[Home] [Help]

APPS.OKL_QA_DATA_INTEGRITY dependencies on OKC_K_HEADERS_B

Line 157: FROM OKC_K_HEADERS_B chr,

153: khr.syndicatable_yn,
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

Line 479: from okc_k_headers_b

475:
476: -- rviriyal bug 5982201 start
477: cursor contract_dtls(chrId Number) is
478: select start_date, end_date
479: from okc_k_headers_b
480: where id =chrId;
481:
482: cursor vend_dtls(OBJECT1_ID1 NUMBER) is
483: select START_DATE_ACTIVE, END_DATE_ACTIVE, NAME