APPS.OKL_SEEDED_FUNCTIONS_PVT dependencies on OKL_K_RATE_PARAMS

Line 2852: FROM OKL_K_RATE_PARAMS

2848:
2849: -- Fetch contract days in a month
2850: CURSOR days_in_month IS
2851: SELECT days_in_a_month_code
2852: FROM OKL_K_RATE_PARAMS
2853: WHERE khr_id = p_khr_id
2854: AND parameter_type_code = 'ACTUAL'
2855: AND effective_to_date IS NULL;
2856:

Line 2866: FROM OKL_K_RATE_PARAMS

2862:
2863: -- Fetch contract days in a year
2864: CURSOR days_in_year IS
2865: SELECT days_in_a_year_code
2866: FROM OKL_K_RATE_PARAMS
2867: WHERE khr_id = p_khr_id
2868: AND parameter_type_code = 'ACTUAL'
2869: AND effective_to_date IS NULL;
2870:

Line 3041: FROM OKL_K_RATE_PARAMS

3037:
3038: -- Fetch contract days in a year
3039: CURSOR lookup_csr(p_ctr_id NUMBER) IS
3040: SELECT days_in_a_year_code
3041: FROM OKL_K_RATE_PARAMS
3042: WHERE khr_id = p_ctr_id
3043: AND parameter_type_code = 'ACTUAL'
3044: AND effective_to_date IS NULL;
3045:

Line 3174: FROM OKL_K_RATE_PARAMS okl,

3170:
3171: -- cursor to get interest rate
3172: CURSOR interest_rate_csr(p_ctr_id NUMBER, p_accrual_date DATE) IS
3173: SELECT idv.value
3174: FROM OKL_K_RATE_PARAMS okl,
3175: OKL_INDEX_VALUES idv,
3176: OKL_INDICES idx
3177: WHERE okl.khr_id = p_ctr_id
3178: AND okl.parameter_type_code = 'ACTUAL'

Line 3185: OKL_K_RATE_PARAMS rate

3181: AND idx.ID = idv.idx_id
3182: AND idv.datetime_valid = (SELECT MAX(idv.datetime_valid)
3183: FROM OKL_INDEX_VALUES idv ,
3184: OKL_INDICES idx,
3185: OKL_K_RATE_PARAMS rate
3186: WHERE rate.khr_id = p_ctr_id
3187: AND rate.parameter_type_code = 'ACTUAL'
3188: AND rate.effective_to_date IS NULL
3189: AND rate.interest_index_id = idx.id

Line 3206: FROM OKL_K_RATE_PARAMS

3202: -- cursor to get adder rate
3203: -- Bug 4737551.
3204: CURSOR adder_rate_csr(p_ctr_id NUMBER) IS
3205: SELECT adder_rate
3206: FROM OKL_K_RATE_PARAMS
3207: WHERE khr_id = p_ctr_id
3208: AND parameter_type_code = 'ACTUAL'
3209: AND effective_to_date IS NULL;
3210:

Line 13153: FROM okl_k_rate_params_v

13149: WHERE qte.id = p_qte_id;
13150:
13151: CURSOR get_base_interest_rate_csr (p_khr_id IN NUMBER) IS
13152: SELECT base_rate
13153: FROM okl_k_rate_params_v
13154: WHERE khr_id = p_khr_id;
13155:
13156: --SECHAWLA 30-NOV-05 4753429 : New declarations begin
13157: CURSOR l_dealtype_csr (cp_khr_id IN NUMBER) IS

Line 13179: 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

13175: iYear NUMBER;
13176:
13177: l_days_in_year NUMBER;
13178: --gboomina Bug#4703521 27-Oct-05 start
13179: 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
13180: 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
13181: --gboomina Bug#4703521 27-Oct-05 end
13182: lx_return_status VARCHAR2(3);
13183:

Line 13180: 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

13176:
13177: l_days_in_year NUMBER;
13178: --gboomina Bug#4703521 27-Oct-05 start
13179: 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
13180: 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
13181: --gboomina Bug#4703521 27-Oct-05 end
13182: lx_return_status VARCHAR2(3);
13183:
13184: