APPS.OKL_LA_STREAM_PVT dependencies on OKL_K_RATE_PARAMS

Line 9575: FROM okl_k_rate_params rate_params

9571: -- DECODE(rate_params.days_in_a_month_code,'30','360',rate_params.days_in_a_month_code) days_in_a_month_code
9572: DECODE(rate_params.days_in_a_month_code,'30','360',rate_params.days_in_a_month_code) days_in_a_month_code,
9573: rate_params.days_in_a_year_code
9574: --srsreeni bug6076113 ends
9575: FROM okl_k_rate_params rate_params
9576: WHERE khr_id = p_chr_id;
9577:
9578: CURSOR get_day_conv_on_sgt
9579: IS

Line 11951: FROM okl_k_rate_params rate_params

11947: -- DECODE(rate_params.days_in_a_month_code,'30','360',rate_params.days_in_a_month_code) days_in_a_month_code
11948: DECODE(rate_params.days_in_a_month_code,'30','360',rate_params.days_in_a_month_code) days_in_a_month_code,
11949: rate_params.days_in_a_year_code
11950: --srsreeni bug6076113 ends
11951: FROM okl_k_rate_params rate_params
11952: WHERE khr_id = p_chr_id;
11953:
11954: CURSOR get_day_conv_on_sgt
11955: IS

Line 11978: FROM OKL_K_RATE_PARAMS parm

11974: CURSOR get_base_rate_csr(p_chr_id IN NUMBER,
11975: p_date IN DATE)
11976: IS
11977: SELECT PARM.BASE_RATE
11978: FROM OKL_K_RATE_PARAMS parm
11979: WHERE PARM.KHR_ID = p_chr_id
11980: AND PARM.PARAMETER_TYPE_CODE = 'ACTUAL'
11981: AND p_date BETWEEN EFFECTIVE_FROM_DATE AND NVL(EFFECTIVE_TO_DATE,p_date);
11982:

Line 13206: FROM okl_k_rate_params rate_params

13202: -- DECODE(rate_params.days_in_a_month_code,'30','360',rate_params.days_in_a_month_code) days_in_a_month_code
13203: DECODE(rate_params.days_in_a_month_code,'30','360',rate_params.days_in_a_month_code) days_in_a_month_code,
13204: rate_params.days_in_a_year_code
13205: --srsreeni bug6076113 ends
13206: FROM okl_k_rate_params rate_params
13207: WHERE khr_id = p_chr_id;
13208:
13209: CURSOR get_day_conv_on_sgt
13210: IS

Line 15281: FROM okl_k_rate_params rate_params

15277: -- DECODE(rate_params.days_in_a_month_code,'30','360',rate_params.days_in_a_month_code) days_in_a_month_code
15278: DECODE(rate_params.days_in_a_month_code,'30','360',rate_params.days_in_a_month_code) days_in_a_month_code,
15279: rate_params.days_in_a_year_code
15280: --srsreeni bug6076113 ends
15281: FROM okl_k_rate_params rate_params
15282: WHERE khr_id = p_chr_id;
15283:
15284: CURSOR get_day_conv_on_sgt
15285: IS

Line 15348: FROM OKL_K_RATE_PARAMS parm

15344: CURSOR get_base_rate_csr(p_chr_id IN NUMBER,
15345: p_date IN DATE)
15346: IS
15347: SELECT PARM.BASE_RATE
15348: FROM OKL_K_RATE_PARAMS parm
15349: WHERE PARM.KHR_ID = p_chr_id
15350: AND PARM.PARAMETER_TYPE_CODE = 'ACTUAL'
15351: AND p_date BETWEEN EFFECTIVE_FROM_DATE AND NVL(EFFECTIVE_TO_DATE,p_date);
15352:

Line 17755: FROM okl_k_rate_params rate_params

17751: -- DECODE(rate_params.days_in_a_month_code,'30','360',rate_params.days_in_a_month_code) days_in_a_month_code
17752: DECODE(rate_params.days_in_a_month_code,'30','360',rate_params.days_in_a_month_code) days_in_a_month_code,
17753: rate_params.days_in_a_year_code
17754: --srsreeni bug6076113 ends
17755: FROM okl_k_rate_params rate_params
17756: WHERE khr_id = p_chr_id;
17757:
17758: CURSOR get_day_conv_on_sgt
17759: IS

Line 22235: FROM okl_k_rate_params rate_params

22231: -- DECODE(rate_params.days_in_a_month_code,'30','360',rate_params.days_in_a_month_code) days_in_a_month_code
22232: DECODE(rate_params.days_in_a_month_code,'30','360',rate_params.days_in_a_month_code) days_in_a_month_code,
22233: rate_params.days_in_a_year_code
22234: --srsreeni bug6076113 ends
22235: FROM okl_k_rate_params rate_params
22236: WHERE khr_id = p_chr_id;
22237:
22238: CURSOR get_day_conv_on_sgt
22239: IS