APPS.OKL_LA_STREAM_PVT dependencies on OKL_K_RATE_PARAMS

Line 11163: FROM okl_k_rate_params rate_params

11159: -- DECODE(rate_params.days_in_a_month_code,'30','360',rate_params.days_in_a_month_code) days_in_a_month_code
11160: DECODE(rate_params.days_in_a_month_code,'30','360',rate_params.days_in_a_month_code) days_in_a_month_code,
11161: rate_params.days_in_a_year_code
11162: --srsreeni bug6076113 ends
11163: FROM okl_k_rate_params rate_params
11164: WHERE khr_id = p_chr_id;
11165:
11166: CURSOR get_day_conv_on_sgt
11167: IS

Line 13881: FROM okl_k_rate_params rate_params

13877: -- DECODE(rate_params.days_in_a_month_code,'30','360',rate_params.days_in_a_month_code) days_in_a_month_code
13878: DECODE(rate_params.days_in_a_month_code,'30','360',rate_params.days_in_a_month_code) days_in_a_month_code,
13879: rate_params.days_in_a_year_code
13880: --srsreeni bug6076113 ends
13881: FROM okl_k_rate_params rate_params
13882: WHERE khr_id = p_chr_id;
13883:
13884: CURSOR get_day_conv_on_sgt
13885: IS

Line 13908: FROM OKL_K_RATE_PARAMS parm

13904: CURSOR get_base_rate_csr(p_chr_id IN NUMBER,
13905: p_date IN DATE)
13906: IS
13907: SELECT PARM.BASE_RATE
13908: FROM OKL_K_RATE_PARAMS parm
13909: WHERE PARM.KHR_ID = p_chr_id
13910: AND PARM.PARAMETER_TYPE_CODE = 'ACTUAL'
13911: AND p_date BETWEEN EFFECTIVE_FROM_DATE AND NVL(EFFECTIVE_TO_DATE,p_date);
13912:

Line 15309: FROM okl_k_rate_params rate_params

15305: -- DECODE(rate_params.days_in_a_month_code,'30','360',rate_params.days_in_a_month_code) days_in_a_month_code
15306: DECODE(rate_params.days_in_a_month_code,'30','360',rate_params.days_in_a_month_code) days_in_a_month_code,
15307: rate_params.days_in_a_year_code
15308: --srsreeni bug6076113 ends
15309: FROM okl_k_rate_params rate_params
15310: WHERE khr_id = p_chr_id;
15311:
15312: CURSOR get_day_conv_on_sgt
15313: IS

Line 17594: FROM okl_k_rate_params rate_params

17590: -- DECODE(rate_params.days_in_a_month_code,'30','360',rate_params.days_in_a_month_code) days_in_a_month_code
17591: DECODE(rate_params.days_in_a_month_code,'30','360',rate_params.days_in_a_month_code) days_in_a_month_code,
17592: rate_params.days_in_a_year_code
17593: --srsreeni bug6076113 ends
17594: FROM okl_k_rate_params rate_params
17595: WHERE khr_id = p_chr_id;
17596:
17597: CURSOR get_day_conv_on_sgt
17598: IS

Line 17669: FROM OKL_K_RATE_PARAMS parm

17665: CURSOR get_base_rate_csr(p_chr_id IN NUMBER,
17666: p_date IN DATE)
17667: IS
17668: SELECT PARM.BASE_RATE
17669: FROM OKL_K_RATE_PARAMS parm
17670: WHERE PARM.KHR_ID = p_chr_id
17671: AND PARM.PARAMETER_TYPE_CODE = 'ACTUAL'
17672: AND p_date BETWEEN EFFECTIVE_FROM_DATE AND NVL(EFFECTIVE_TO_DATE,p_date);
17673:

Line 20393: FROM okl_k_rate_params rate_params

20389: -- DECODE(rate_params.days_in_a_month_code,'30','360',rate_params.days_in_a_month_code) days_in_a_month_code
20390: DECODE(rate_params.days_in_a_month_code,'30','360',rate_params.days_in_a_month_code) days_in_a_month_code,
20391: rate_params.days_in_a_year_code
20392: --srsreeni bug6076113 ends
20393: FROM okl_k_rate_params rate_params
20394: WHERE khr_id = p_chr_id;
20395:
20396: CURSOR get_day_conv_on_sgt
20397: IS

Line 25078: FROM okl_k_rate_params rate_params

25074: -- DECODE(rate_params.days_in_a_month_code,'30','360',rate_params.days_in_a_month_code) days_in_a_month_code
25075: DECODE(rate_params.days_in_a_month_code,'30','360',rate_params.days_in_a_month_code) days_in_a_month_code,
25076: rate_params.days_in_a_year_code
25077: --srsreeni bug6076113 ends
25078: FROM okl_k_rate_params rate_params
25079: WHERE khr_id = p_chr_id;
25080:
25081: CURSOR get_day_conv_on_sgt
25082: IS