729: --Added for bug 7030415
730:
731: CURSOR c_get_conversion_type( p_org_id IN NUMBER) IS
732: SELECT exchange_rate_type
733: FROM ozf_sys_parameters_all
734: WHERE org_id = p_org_id;
735:
736:
737: l_exchange_rate_type VARCHAR2(30) := FND_API.G_MISS_CHAR;
1929:
1930: --Added for bug 7030415
1931: CURSOR c_get_conversion_type( p_org_id IN NUMBER) IS
1932: SELECT exchange_rate_type
1933: FROM ozf_sys_parameters_all
1934: WHERE org_id = p_org_id;
1935:
1936: l_exchange_rate_type VARCHAR2(30) := FND_API.G_MISS_CHAR;
1937: l_rate NUMBER;
2369:
2370: --Added for bug 7030415
2371: CURSOR c_get_conversion_type( p_org_id IN NUMBER) IS
2372: SELECT exchange_rate_type
2373: FROM ozf_sys_parameters_all
2374: WHERE org_id = p_org_id;
2375:
2376: l_exchange_rate_type VARCHAR2(30) := FND_API.G_MISS_CHAR;
2377: l_rate NUMBER;
3514:
3515: -- Added for bug 7030415, get conversion type
3516: CURSOR c_get_conversion_type( p_org_id IN NUMBER) IS
3517: SELECT exchange_rate_type
3518: FROM ozf_sys_parameters_all
3519: WHERE org_id = p_org_id;
3520:
3521: l_exchange_rate_type VARCHAR2(30) := FND_API.G_MISS_CHAR;
3522: l_rate NUMBER;