eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_K_RATE_PARAMS_PVT dependencies on OKL_K_HEADERS

Line 134: FROM OKL_K_HEADERS A,

130: x_contract_number,
131: x_contract_start_date,
132: l_orig_system_id1,
133: l_orig_system_source_code
134: FROM OKL_K_HEADERS A,
135: OKC_K_HEADERS_B B
136: WHERE A.ID = p_chr_id
137: AND A.ID = B.ID;
138: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 284: okl_k_headers khr,

280: khr.deal_type,
281: pdt.id pid,
282: NVL(pdt.reporting_pdt_id, -1) report_pdt_id
283: FROM okc_k_headers_b CHR,
284: okl_k_headers khr,
285: okl_products_v pdt
286: WHERE khr.id = CHR.id
287: AND CHR.id = chrId
288: AND khr.pdt_id = pdt.id;

Line 363: okl_k_headers khr,

359: khr.deal_type,
360: pdt.id pid,
361: NVL(pdt.reporting_pdt_id, -1) report_pdt_id
362: FROM okc_k_headers_b CHR,
363: okl_k_headers khr,
364: okl_products_v pdt
365: WHERE khr.id = CHR.id
366: AND CHR.id = chrId
367: AND khr.pdt_id = pdt.id;

Line 555: okl_k_headers b

551: CURSOR txn_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
552: SELECT a.date_transaction_occurred,
553: b.date_last_interim_interest_cal
554: FROM okl_trx_contracts a,
555: okl_k_headers b
556: WHERE a.khr_id_new = p_chr_id
557: AND a.tcn_type = 'TRBK'
558: AND a.tsu_code = 'ENTERED'
559: --rkuttiya added for 12.1.1 Multi GAAP

Line 977: OKL_K_HEADERS lease

973: lease.date_last_interim_interest_cal,
974: contract.orig_system_id1
975: FROM OKL_K_RATE_PARAMS rate,
976: OKC_K_HEADERS_B contract,
977: OKL_K_HEADERS lease
978: WHERE rate.khr_id = p_khr_id
979: AND rate.parameter_type_code = p_parameter_type_code
980: AND rate.effective_to_date is null
981: AND rate.khr_id = contract.id

Line 992: , OKL_K_HEADERS KHR

988: SELECT MAX(STE.STREAM_ELEMENT_DATE) LAST_STREAM_DUE_DATE
989: FROM OKL_STRM_ELEMENTS STE
990: , OKL_STREAMS STM
991: , OKL_STRM_TYPE_V STY
992: , OKL_K_HEADERS KHR
993: , OKC_K_HEADERS_B CHR
994: WHERE STM.ID = STE.STM_ID
995: AND STY.ID = STM.STY_ID
996: AND KHR.ID = STM.KHR_ID

Line 1737: okl_k_headers b

1733: CURSOR txn_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
1734: SELECT a.date_transaction_occurred,
1735: b.date_last_interim_interest_cal
1736: FROM okl_trx_contracts a,
1737: okl_k_headers b
1738: WHERE a.khr_id_new = p_chr_id
1739: AND a.tcn_type = 'TRBK'
1740: AND a.tsu_code = 'ENTERED'
1741: --rkuttiya added for 12.1.1 Multi GAAP

Line 2759: okl_k_headers khr,

2755: khr.deal_type,
2756: pdt.id pid,
2757: NVL(pdt.reporting_pdt_id, -1) report_pdt_id
2758: FROM okc_k_headers_b CHR,
2759: okl_k_headers khr,
2760: okl_products_v pdt
2761: WHERE khr.id = CHR.id
2762: AND CHR.id = chrId
2763: AND khr.pdt_id = pdt.id(+);

Line 3701: l_interest_proc_date OKL_K_HEADERS.DATE_LAST_INTERIM_INTEREST_CAL%TYPE;

3697: l_interest_calc_basis OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_BASIS%TYPE;
3698: l_interest_calc_meaning OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_MEANING%TYPE;
3699: l_rev_recog_method OKL_PRODUCT_PARAMETERS_V.REVENUE_RECOGNITION_METHOD%TYPE;
3700: --l_rev_recog_meaning OKL_PRODUCT_PARAMETERS_V.REVENUE_RECOGNITION_MEANING%TYPE;
3701: l_interest_proc_date OKL_K_HEADERS.DATE_LAST_INTERIM_INTEREST_CAL%TYPE;
3702: l_stream_name OKL_STRM_TYPE_V.STYB_PURPOSE_MEANING%TYPE;
3703:
3704: l_last_accrued_due_date DATE;
3705: l_last_billed_due_date DATE;

Line 3737: CURSOR get_contract_details(cp_chr_id OKL_K_HEADERS.ID%TYPE) IS

3733: NVL(FNDLUP.START_DATE_ACTIVE,SYSDATE)
3734: AND NVL(FNDLUP.END_DATE_ACTIVE,SYSDATE);
3735:
3736: -- Cursor to query to get the Interest Processed flag
3737: CURSOR get_contract_details(cp_chr_id OKL_K_HEADERS.ID%TYPE) IS
3738: SELECT
3739: CHR.CONTRACT_NUMBER
3740: , KHR.DATE_LAST_INTERIM_INTEREST_CAL INTEREST_PROCESSED_FLAG
3741: FROM

Line 3742: OKL_K_HEADERS KHR

3738: SELECT
3739: CHR.CONTRACT_NUMBER
3740: , KHR.DATE_LAST_INTERIM_INTEREST_CAL INTEREST_PROCESSED_FLAG
3741: FROM
3742: OKL_K_HEADERS KHR
3743: , OKC_K_HEADERS_B CHR
3744: WHERE
3745: CHR.ID = KHR.ID
3746: AND KHR.ID = cp_chr_id;

Line 3759: , OKL_K_HEADERS KHR

3755: FROM
3756: OKL_STRM_ELEMENTS STE
3757: , OKL_STREAMS STM
3758: , OKL_STRM_TYPE_V STY
3759: , OKL_K_HEADERS KHR
3760: , OKC_K_HEADERS_B CHR
3761: WHERE
3762: STM.ID = STE.STM_ID
3763: AND STY.ID = STM.STY_ID

Line 3782: , OKL_K_HEADERS KHR

3778: FROM
3779: OKL_STRM_ELEMENTS STE
3780: , OKL_STREAMS STM
3781: , OKL_STRM_TYPE_V STY
3782: , OKL_K_HEADERS KHR
3783: , OKC_K_HEADERS_B CHR
3784: WHERE
3785: STM.ID = STE.STM_ID
3786: AND STY.ID = STM.STY_ID

Line 4839: OKL_K_HEADERS lease

4835: lease.date_last_interim_interest_cal,
4836: contract.orig_system_id1
4837: FROM OKL_K_RATE_PARAMS rate,
4838: OKC_K_HEADERS_B contract,
4839: OKL_K_HEADERS lease
4840: WHERE rate.khr_id = p_khr_id
4841: AND rate.parameter_type_code = p_parameter_type_code
4842: AND rate.effective_to_date is null
4843: AND rate.khr_id = contract.id

Line 4862: , OKL_K_HEADERS KHR

4858: FROM
4859: OKL_STRM_ELEMENTS STE
4860: , OKL_STREAMS STM
4861: , OKL_STRM_TYPE_V STY
4862: , OKL_K_HEADERS KHR
4863: , OKC_K_HEADERS_B CHR
4864: WHERE
4865: STM.ID = STE.STM_ID
4866: AND STY.ID = STM.STY_ID

Line 5140: FROM OKL_K_HEADERS

5136: x_msg_data OUT NOCOPY VARCHAR2,
5137: p_khr_id IN NUMBER) IS
5138: CURSOR implicit_interest_rate_csr(p_id NUMBER) IS
5139: SELECT IMPLICIT_INTEREST_RATE
5140: FROM OKL_K_HEADERS
5141: WHERE ID = p_id;
5142:
5143: l_base_count NUMBER;
5144: l_api_name varchar2(240) := 'sync_base_rate';