DBA Data[Home] [Help]

APPS.OKL_LOSS_PROV_PVT dependencies on FND_CURRENCIES_VL

Line 1163: CURSOR precision_csr(p_curr_code FND_CURRENCIES_VL.currency_code%TYPE) IS

1159: AND pqy.name IN ('LEASE','INVESTOR')
1160: AND pdt.id = l_product_id;
1161:
1162: -- cursor to get precision
1163: CURSOR precision_csr(p_curr_code FND_CURRENCIES_VL.currency_code%TYPE) IS
1164: SELECT PRECISION
1165: FROM fnd_currencies_vl
1166: WHERE currency_code = p_curr_code
1167: AND enabled_flag = 'Y'

Line 1165: FROM fnd_currencies_vl

1161:
1162: -- cursor to get precision
1163: CURSOR precision_csr(p_curr_code FND_CURRENCIES_VL.currency_code%TYPE) IS
1164: SELECT PRECISION
1165: FROM fnd_currencies_vl
1166: WHERE currency_code = p_curr_code
1167: AND enabled_flag = 'Y'
1168: AND NVL(start_date_active, l_sysdate) <= l_sysdate
1169: AND NVL(end_date_active, l_sysdate) >= l_sysdate;