APPS.OKL_SEEDED_FUNCTIONS_PVT dependencies on OKL_K_RATE_PARAMS

Line 3316: FROM OKL_K_RATE_PARAMS

3312:
3313: -- Fetch contract days in a month
3314: CURSOR days_in_month IS
3315: SELECT days_in_a_month_code
3316: FROM OKL_K_RATE_PARAMS
3317: WHERE khr_id = p_khr_id
3318: AND parameter_type_code = 'ACTUAL'
3319: AND effective_to_date IS NULL;
3320:

Line 3330: FROM OKL_K_RATE_PARAMS

3326:
3327: -- Fetch contract days in a year
3328: CURSOR days_in_year IS
3329: SELECT days_in_a_year_code
3330: FROM OKL_K_RATE_PARAMS
3331: WHERE khr_id = p_khr_id
3332: AND parameter_type_code = 'ACTUAL'
3333: AND effective_to_date IS NULL;
3334:

Line 3505: FROM OKL_K_RATE_PARAMS

3501:
3502: -- Fetch contract days in a year
3503: CURSOR lookup_csr(p_ctr_id NUMBER) IS
3504: SELECT days_in_a_year_code
3505: FROM OKL_K_RATE_PARAMS
3506: WHERE khr_id = p_ctr_id
3507: AND parameter_type_code = 'ACTUAL'
3508: AND effective_to_date IS NULL;
3509:

Line 3638: FROM OKL_K_RATE_PARAMS okl,

3634:
3635: -- cursor to get interest rate
3636: CURSOR interest_rate_csr(p_ctr_id NUMBER, p_accrual_date DATE) IS
3637: SELECT idv.value
3638: FROM OKL_K_RATE_PARAMS okl,
3639: OKL_INDEX_VALUES idv,
3640: OKL_INDICES idx
3641: WHERE okl.khr_id = p_ctr_id
3642: AND okl.parameter_type_code = 'ACTUAL'

Line 3649: OKL_K_RATE_PARAMS rate

3645: AND idx.ID = idv.idx_id
3646: AND idv.datetime_valid = (SELECT MAX(idv.datetime_valid)
3647: FROM OKL_INDEX_VALUES idv ,
3648: OKL_INDICES idx,
3649: OKL_K_RATE_PARAMS rate
3650: WHERE rate.khr_id = p_ctr_id
3651: AND rate.parameter_type_code = 'ACTUAL'
3652: AND rate.effective_to_date IS NULL
3653: AND rate.interest_index_id = idx.id

Line 3670: FROM OKL_K_RATE_PARAMS

3666: -- cursor to get adder rate
3667: -- Bug 4737551.
3668: CURSOR adder_rate_csr(p_ctr_id NUMBER) IS
3669: SELECT adder_rate
3670: FROM OKL_K_RATE_PARAMS
3671: WHERE khr_id = p_ctr_id
3672: AND parameter_type_code = 'ACTUAL'
3673: AND effective_to_date IS NULL;
3674:

Line 14385: FROM okl_k_rate_params_v

14381: WHERE qte.id = p_qte_id;
14382:
14383: CURSOR get_base_interest_rate_csr (p_khr_id IN NUMBER) IS
14384: SELECT base_rate
14385: FROM okl_k_rate_params_v
14386: WHERE khr_id = p_khr_id;
14387:
14388: --SECHAWLA 30-NOV-05 4753429 : New declarations begin
14389: CURSOR l_dealtype_csr (cp_khr_id IN NUMBER) IS

Line 14411: lx_days_in_month OKL_K_RATE_PARAMS.days_in_a_month_code%type; --gboomina Bug#4703521 27-Oct-05 - changed VARCHAR2(5) to OKL_K_RATE_PARAMS.days_in_a_month_code%type

14407: iYear NUMBER;
14408:
14409: l_days_in_year NUMBER;
14410: --gboomina Bug#4703521 27-Oct-05 start
14411: lx_days_in_month OKL_K_RATE_PARAMS.days_in_a_month_code%type; --gboomina Bug#4703521 27-Oct-05 - changed VARCHAR2(5) to OKL_K_RATE_PARAMS.days_in_a_month_code%type
14412: lx_days_in_year OKL_K_RATE_PARAMS.days_in_a_month_code%type; --gboomina Bug#4703521 27-Oct-05 - changed VARCHAR2(5) to OKL_K_RATE_PARAMS.days_in_a_month_code%type
14413: --gboomina Bug#4703521 27-Oct-05 end
14414: lx_return_status VARCHAR2(3);
14415:

Line 14412: lx_days_in_year OKL_K_RATE_PARAMS.days_in_a_month_code%type; --gboomina Bug#4703521 27-Oct-05 - changed VARCHAR2(5) to OKL_K_RATE_PARAMS.days_in_a_month_code%type

14408:
14409: l_days_in_year NUMBER;
14410: --gboomina Bug#4703521 27-Oct-05 start
14411: lx_days_in_month OKL_K_RATE_PARAMS.days_in_a_month_code%type; --gboomina Bug#4703521 27-Oct-05 - changed VARCHAR2(5) to OKL_K_RATE_PARAMS.days_in_a_month_code%type
14412: lx_days_in_year OKL_K_RATE_PARAMS.days_in_a_month_code%type; --gboomina Bug#4703521 27-Oct-05 - changed VARCHAR2(5) to OKL_K_RATE_PARAMS.days_in_a_month_code%type
14413: --gboomina Bug#4703521 27-Oct-05 end
14414: lx_return_status VARCHAR2(3);
14415:
14416: