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 144: FROM OKL_K_HEADERS A,

140: x_contract_number,
141: x_contract_start_date,
142: l_orig_system_id1,
143: l_orig_system_source_code
144: FROM OKL_K_HEADERS A,
145: OKC_K_HEADERS_B B
146: WHERE A.ID = p_chr_id
147: AND A.ID = B.ID;
148: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 294: okl_k_headers khr,

290: khr.deal_type,
291: pdt.id pid,
292: NVL(pdt.reporting_pdt_id, -1) report_pdt_id
293: FROM okc_k_headers_b CHR,
294: okl_k_headers khr,
295: okl_products_v pdt
296: WHERE khr.id = CHR.id
297: AND CHR.id = chrId
298: AND khr.pdt_id = pdt.id;

Line 373: okl_k_headers khr,

369: khr.deal_type,
370: pdt.id pid,
371: NVL(pdt.reporting_pdt_id, -1) report_pdt_id
372: FROM okc_k_headers_b CHR,
373: okl_k_headers khr,
374: okl_products_v pdt
375: WHERE khr.id = CHR.id
376: AND CHR.id = chrId
377: AND khr.pdt_id = pdt.id;

Line 565: okl_k_headers b

561: CURSOR txn_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
562: SELECT a.date_transaction_occurred,
563: b.date_last_interim_interest_cal
564: FROM okl_trx_contracts a,
565: okl_k_headers b
566: WHERE a.khr_id_new = p_chr_id
567: AND a.tcn_type = 'TRBK'
568: AND a.tsu_code = 'ENTERED'
569: --rkuttiya added for 12.1.1 Multi GAAP

Line 987: OKL_K_HEADERS lease

983: lease.date_last_interim_interest_cal,
984: contract.orig_system_id1
985: FROM OKL_K_RATE_PARAMS rate,
986: OKC_K_HEADERS_B contract,
987: OKL_K_HEADERS lease
988: WHERE rate.khr_id = p_khr_id
989: AND rate.parameter_type_code = p_parameter_type_code
990: AND rate.effective_to_date is null
991: AND rate.khr_id = contract.id

Line 1002: , OKL_K_HEADERS KHR

998: SELECT MAX(STE.STREAM_ELEMENT_DATE) LAST_STREAM_DUE_DATE
999: FROM OKL_STRM_ELEMENTS STE
1000: , OKL_STREAMS STM
1001: , OKL_STRM_TYPE_V STY
1002: , OKL_K_HEADERS KHR
1003: , OKC_K_HEADERS_B CHR
1004: WHERE STM.ID = STE.STM_ID
1005: AND STY.ID = STM.STY_ID
1006: AND KHR.ID = STM.KHR_ID

Line 1747: okl_k_headers b

1743: CURSOR txn_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
1744: SELECT a.date_transaction_occurred,
1745: b.date_last_interim_interest_cal
1746: FROM okl_trx_contracts a,
1747: okl_k_headers b
1748: WHERE a.khr_id_new = p_chr_id
1749: AND a.tcn_type = 'TRBK'
1750: AND a.tsu_code = 'ENTERED'
1751: --rkuttiya added for 12.1.1 Multi GAAP

Line 2769: okl_k_headers khr,

2765: khr.deal_type,
2766: pdt.id pid,
2767: NVL(pdt.reporting_pdt_id, -1) report_pdt_id
2768: FROM okc_k_headers_b CHR,
2769: okl_k_headers khr,
2770: okl_products_v pdt
2771: WHERE khr.id = CHR.id
2772: AND CHR.id = chrId
2773: AND khr.pdt_id = pdt.id(+);

Line 3711: l_interest_proc_date OKL_K_HEADERS.DATE_LAST_INTERIM_INTEREST_CAL%TYPE;

3707: l_interest_calc_basis OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_BASIS%TYPE;
3708: l_interest_calc_meaning OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_MEANING%TYPE;
3709: l_rev_recog_method OKL_PRODUCT_PARAMETERS_V.REVENUE_RECOGNITION_METHOD%TYPE;
3710: --l_rev_recog_meaning OKL_PRODUCT_PARAMETERS_V.REVENUE_RECOGNITION_MEANING%TYPE;
3711: l_interest_proc_date OKL_K_HEADERS.DATE_LAST_INTERIM_INTEREST_CAL%TYPE;
3712: l_stream_name OKL_STRM_TYPE_V.STYB_PURPOSE_MEANING%TYPE;
3713:
3714: l_last_accrued_due_date DATE;
3715: l_last_billed_due_date DATE;

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

3743: NVL(FNDLUP.START_DATE_ACTIVE,SYSDATE)
3744: AND NVL(FNDLUP.END_DATE_ACTIVE,SYSDATE);
3745:
3746: -- Cursor to query to get the Interest Processed flag
3747: CURSOR get_contract_details(cp_chr_id OKL_K_HEADERS.ID%TYPE) IS
3748: SELECT
3749: CHR.CONTRACT_NUMBER
3750: , KHR.DATE_LAST_INTERIM_INTEREST_CAL INTEREST_PROCESSED_FLAG
3751: FROM

Line 3752: OKL_K_HEADERS KHR

3748: SELECT
3749: CHR.CONTRACT_NUMBER
3750: , KHR.DATE_LAST_INTERIM_INTEREST_CAL INTEREST_PROCESSED_FLAG
3751: FROM
3752: OKL_K_HEADERS KHR
3753: , OKC_K_HEADERS_B CHR
3754: WHERE
3755: CHR.ID = KHR.ID
3756: AND KHR.ID = cp_chr_id;

Line 3770: , OKL_K_HEADERS KHR

3766: FROM
3767: OKL_STRM_ELEMENTS STE
3768: , OKL_STREAMS STM
3769: , OKL_STRM_TYPE_V STY
3770: , OKL_K_HEADERS KHR
3771: , OKC_K_HEADERS_B CHR
3772: WHERE
3773: STM.ID = STE.STM_ID
3774: AND STY.ID = STM.STY_ID

Line 3794: , OKL_K_HEADERS KHR

3790: FROM
3791: OKL_STRM_ELEMENTS STE
3792: , OKL_STREAMS STM
3793: , OKL_STRM_TYPE_V STY
3794: , OKL_K_HEADERS KHR
3795: , OKC_K_HEADERS_B CHR
3796: WHERE
3797: STM.ID = STE.STM_ID
3798: AND STY.ID = STM.STY_ID

Line 4936: OKL_K_HEADERS lease

4932: lease.date_last_interim_interest_cal,
4933: contract.orig_system_id1
4934: FROM OKL_K_RATE_PARAMS rate,
4935: OKC_K_HEADERS_B contract,
4936: OKL_K_HEADERS lease
4937: WHERE rate.khr_id = p_khr_id
4938: AND rate.parameter_type_code = p_parameter_type_code
4939: AND rate.effective_to_date is null
4940: AND rate.khr_id = contract.id

Line 4959: , OKL_K_HEADERS KHR

4955: FROM
4956: OKL_STRM_ELEMENTS STE
4957: , OKL_STREAMS STM
4958: , OKL_STRM_TYPE_V STY
4959: , OKL_K_HEADERS KHR
4960: , OKC_K_HEADERS_B CHR
4961: WHERE
4962: STM.ID = STE.STM_ID
4963: AND STY.ID = STM.STY_ID

Line 5237: FROM OKL_K_HEADERS

5233: x_msg_data OUT NOCOPY VARCHAR2,
5234: p_khr_id IN NUMBER) IS
5235: CURSOR implicit_interest_rate_csr(p_id NUMBER) IS
5236: SELECT IMPLICIT_INTEREST_RATE
5237: FROM OKL_K_HEADERS
5238: WHERE ID = p_id;
5239:
5240: l_base_count NUMBER;
5241: l_api_name varchar2(240) := 'sync_base_rate';