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 841: from okl_k_headers_full_v khr

837: , khr.currency_code
838: , ppm.revenue_recognition_method
839: , ppm.interest_calculation_basis
840: , ppm.name product_name
841: from okl_k_headers_full_v khr
842: ,okl_product_parameters_v ppm
843: where khr.pdt_id = ppm.id
844: and ppm.revenue_recognition_method = 'ACTUAL'
845: and khr.id = NVL(cp_khr_id, khr.id)

Line 1529: FROM okl_k_headers_full_v khr,

1525: CURSOR check_contract_csr(cp_contract_number IN VARCHAR2) IS
1526: SELECT khr.id khr_id
1527: ,khr.contract_number
1528: ,khr.authoring_org_id
1529: FROM okl_k_headers_full_v khr,
1530: okl_prod_qlty_val_uv ppm,
1531: okc_statuses_b ste
1532: WHERE khr.contract_number = NVL(cp_contract_number, khr.contract_number)
1533: AND khr.pdt_id = ppm.pdt_id