DBA Data[Home] [Help]

APPS.OKL_QA_DATA_INTEGRITY dependencies on OKC_K_HEADERS_B

Line 155: FROM OKC_K_HEADERS_B chr,

151: khr.syndicatable_yn,
152: khr.DEAL_TYPE,
153: khr.term_duration term,
154: nvl(pdt.reporting_pdt_id, -1) report_pdt_id
155: FROM OKC_K_HEADERS_B chr,
156: OKL_K_HEADERS khr,
157: OKL_PRODUCTS_V pdt
158: WHERE chr.id = chrid
159: AND chr.id = khr.id

Line 431: from okc_k_headers_b

427:
428: -- rviriyal bug 5982201 start
429: cursor contract_dtls(chrId Number) is
430: select start_date, end_date
431: from okc_k_headers_b
432: where id =chrId;
433:
434: cursor vend_dtls(OBJECT1_ID1 NUMBER) is
435: select START_DATE_ACTIVE, END_DATE_ACTIVE, NAME