APPS.OKL_VAR_INT_REAMORT_PVT dependencies on OKL_PROD_QLTY_VAL_UV

Line 1582: --dkagrawa changed query to use view okl_prod_qlty_val_uv than okl_product_parameters_v for performance

1578: l_tmp_loan_lines_tbl okl_create_streams_pvt.csm_loan_line_tbl_type;
1579: l_tmp_loan_levels_tbl okl_create_streams_pvt.csm_loan_level_tbl_type;
1580: --end bkatraga for bug 14811647
1581:
1582: --dkagrawa changed query to use view okl_prod_qlty_val_uv than okl_product_parameters_v for performance
1583: CURSOR c_chr_id (cp_khr_id VARCHAR2) IS
1584: SELECT okc.contract_number
1585: , NVL(okl.date_last_interim_interest_cal, okc.start_date) start_date
1586: , okl.deal_type deal_type

Line 1592: , okl_prod_qlty_val_uv ppm

1588: , okc.authoring_org_id
1589: , round(months_between(okc.end_date, okl.date_last_interim_interest_cal)) remaining_term_in_months
1590: FROM okc_k_headers_b okc
1591: , okl_k_headers okl
1592: , okl_prod_qlty_val_uv ppm
1593: WHERE okc.id = cp_khr_id
1594: AND okl.id = okc.id
1595: AND okl.pdt_id = ppm.pdt_id
1596: AND ppm.quality_name = 'INTEREST_CALCULATION_BASIS';