DBA Data[Home] [Help]

APPS.OZF_FUND_ADJUSTMENT_PVT dependencies on OZF_SYS_PARAMETERS_ALL

Line 864: FROM ozf_sys_parameters_all

860: --Added for bug 7030415
861:
862: CURSOR c_get_conversion_type( p_org_id IN NUMBER) IS
863: SELECT exchange_rate_type
864: FROM ozf_sys_parameters_all
865: WHERE org_id = p_org_id;
866:
867:
868: l_exchange_rate_type VARCHAR2(30) := FND_API.G_MISS_CHAR;

Line 1802: FROM ozf_sys_parameters_all

1798: FROM ozf_offers
1799: WHERE qp_list_header_id = p_offer_id;
1800: CURSOR c_get_conversion_type( p_org_id IN NUMBER) IS
1801: SELECT exchange_rate_type
1802: FROM ozf_sys_parameters_all
1803: WHERE org_id = p_org_id;
1804:
1805: l_activity_id NUMBER;
1806: l_obj_ver_num NUMBER;

Line 2455: FROM ozf_sys_parameters_all

2451:
2452: --Added for bug 7030415
2453: CURSOR c_get_conversion_type( p_org_id IN NUMBER) IS
2454: SELECT exchange_rate_type
2455: FROM ozf_sys_parameters_all
2456: WHERE org_id = p_org_id;
2457:
2458: l_exchange_rate_type VARCHAR2(30) := FND_API.G_MISS_CHAR;
2459: l_rate NUMBER;

Line 2901: FROM ozf_sys_parameters_all

2897:
2898: --Added for bug 7030415
2899: CURSOR c_get_conversion_type( p_org_id IN NUMBER) IS
2900: SELECT exchange_rate_type
2901: FROM ozf_sys_parameters_all
2902: WHERE org_id = p_org_id;
2903:
2904: l_exchange_rate_type VARCHAR2(30) := FND_API.G_MISS_CHAR;
2905: l_rate NUMBER;

Line 4196: FROM ozf_sys_parameters_all

4192:
4193: -- Added for bug 7030415, get conversion type
4194: CURSOR c_get_conversion_type( p_org_id IN NUMBER) IS
4195: SELECT exchange_rate_type
4196: FROM ozf_sys_parameters_all
4197: WHERE org_id = p_org_id;
4198:
4199: l_exchange_rate_type VARCHAR2(30) := FND_API.G_MISS_CHAR;
4200: l_rate NUMBER;