APPS.OKL_QA_DATA_INTEGRITY dependencies on OKL_K_HEADERS_V

Line 6899: ,okl_k_headers_v khr

6895: SELECT
6896: pdt.name
6897: ,pdt.PRODUCT_STATUS_CODE
6898: FROM okl_products_v pdt
6899: ,okl_k_headers_v khr
6900: ,okc_k_headers_b CHR
6901: WHERE 1=1
6902: AND khr.id = p_chr_id
6903: AND pdt_id = pdt.id

Line 7382: FROM okl_k_headers_v

7378: p_chr_id IN NUMBER
7379: ) IS
7380: CURSOR l_hdr_csr IS
7381: SELECT tradein_amount
7382: FROM okl_k_headers_v
7383: WHERE id = p_chr_id;
7384: l_hdr_rec l_hdr_csr%ROWTYPE;
7385:
7386: CURSOR l_line_csr IS

Line 7875: ,okl_k_headers_v khr

7871: CURSOR chk_rpt_prod_id (p_chr_id IN NUMBER) IS
7872: SELECT
7873: pdt.reporting_pdt_id
7874: FROM okl_products_v pdt
7875: ,okl_k_headers_v khr
7876: ,okc_k_headers_b CHR
7877: WHERE 1=1
7878: AND khr.id = p_chr_id
7879: AND pdt_id = pdt.id

Line 10147: ,okl_k_headers_v khr

10143: ,pdt.name product_name
10144: ,CHR.sts_code contract_status
10145: ,khr.deal_type deal_type
10146: FROM okl_products_v pdt
10147: ,okl_k_headers_v khr
10148: ,okc_k_headers_b CHR
10149: WHERE 1=1
10150: AND khr.id = p_contract_id
10151: AND pdt_id = pdt.id

Line 10251: ,okl_k_headers_v khr

10247: ,chr.start_date start_date
10248: ,chr.orig_system_source_code orig_system_source_code
10249: ,rul.rule_information1 Release_asset_yn
10250: FROM okl_products_v pdt
10251: ,okl_k_headers_v khr
10252: ,okc_k_headers_b CHR
10253: ,okc_rules_b RUL
10254: WHERE 1=1
10255: AND khr.id = p_chr_id

Line 12783: ,okl_k_headers_v khr

12779: CURSOR chk_product_status (p_chr_id IN NUMBER) IS
12780: SELECT
12781: pdt.name
12782: FROM okl_products_v pdt
12783: ,okl_k_headers_v khr
12784: ,okc_k_headers_b CHR
12785: WHERE 1=1
12786: AND khr.id = p_chr_id
12787: AND pdt_id = pdt.id