APPS.OKL_DAILY_INTEREST_CALC_PVT dependencies on OKL_K_HEADERS_FULL_V

Line 407: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;

403: l_contract_start_date DATE;
404: l_start_date DATE;
405: l_counter NUMBER := 0;
406: l_receipt_tbl receipt_tbl_type;
407: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
408: l_stream_element_date DATE;
409: l_principal_balance NUMBER;
410:
411: l_receipt_tbl_temp receipt_tbl_type;

Line 417: FROM okl_k_headers_full_v

413: l_temp_receipt_date DATE := NULL;
414:
415: Cursor contract_csr (p_contract_id NUMBER) IS
416: SELECT start_date, deal_type
417: FROM okl_k_headers_full_v
418: WHERE id = p_contract_id;
419:
420: -- Begin - Billing Inline changes - Bug#5898792 - varangan - 23/2/2007
421: --Bug# 6742532: Modified cursor to fetch correct receipt amount

Line 690: from okl_k_headers_full_v khr

686: , khr.currency_code
687: , ppm.revenue_recognition_method
688: , ppm.interest_calculation_basis
689: , ppm.name product_name
690: from okl_k_headers_full_v khr
691: ,okl_product_parameters_v ppm
692: where khr.pdt_id = ppm.id
693: and ppm.revenue_recognition_method = 'ACTUAL'
694: and khr.id = NVL(cp_khr_id, khr.id)

Line 1378: FROM okl_k_headers_full_v khr,

1374: CURSOR check_contract_csr(cp_contract_number IN VARCHAR2) IS
1375: SELECT khr.id khr_id
1376: ,khr.contract_number
1377: ,khr.authoring_org_id
1378: FROM okl_k_headers_full_v khr,
1379: okl_prod_qlty_val_uv ppm,
1380: okc_statuses_b ste
1381: WHERE khr.contract_number = NVL(cp_contract_number, khr.contract_number)
1382: AND khr.pdt_id = ppm.pdt_id