APPS.OZF_ADJUSTMENT_EXT_PVT dependencies on OZF_SYS_PARAMETERS_ALL

Line 656: FROM ozf_sys_parameters_all

652:
653: -- get conversion type
654: CURSOR c_get_conversion_type( p_org_id IN NUMBER) IS
655: SELECT exchange_rate_type
656: FROM ozf_sys_parameters_all
657: WHERE org_id = p_org_id;
658:
659: -- get sites org id type
660: CURSOR c_org_id (p_site_use_id IN NUMBER) IS

Line 1215: FROM ozf_sys_parameters_all

1211:
1212:
1213: CURSOR c_exchange_rate_type(p_org_id IN NUMBER) IS
1214: SELECT exchange_rate_type
1215: FROM ozf_sys_parameters_all
1216: WHERE org_id = p_org_id;
1217:
1218:
1219: l_offer_info c_offer_info%ROWTYPE;

Line 4201: FROM ozf_sys_parameters_all

4197: -- AND adjustment_type_id in(-4,-5,-1);
4198:
4199: CURSOR c_exchange_rate_type(p_org_id IN NUMBER) IS
4200: SELECT exchange_rate_type
4201: FROM ozf_sys_parameters_all
4202: WHERE org_id = p_org_id;
4203:
4204:
4205: l_api_name CONSTANT VARCHAR2(30) := 'Process_VO_Result';

Line 4875: FROM ozf_sys_parameters_all

4871:
4872: -- added for bug 7030415 get conversion type
4873: CURSOR c_get_conversion_type(p_org_id IN NUMBER) IS
4874: SELECT exchange_rate_type
4875: FROM ozf_sys_parameters_all
4876: WHERE org_id = p_org_id;
4877:
4878:
4879: l_api_name CONSTANT VARCHAR2(30) := 'Process_SSD_Result';

Line 6503: FROM ozf_sys_parameters_all

6499:
6500: -- get conversion type (nirprasa 12.1.1 fix)
6501: CURSOR c_get_conversion_type( p_org_id IN NUMBER) IS
6502: SELECT exchange_rate_type
6503: FROM ozf_sys_parameters_all
6504: WHERE org_id = p_org_id;
6505: l_offer_info c_offer_info%ROWTYPE;
6506: l_index NUMBER := 1;
6507: l_rate NUMBER;

Line 7161: FROM ozf_sys_parameters_all

7157:
7158: -- Added for bug 7030415, cursor for currency conversion type.
7159: CURSOR c_get_conversion_type( p_org_id IN NUMBER) IS
7160: SELECT exchange_rate_type
7161: FROM ozf_sys_parameters_all
7162: WHERE org_id = p_org_id;
7163:
7164: l_exchange_rate_type VARCHAR2(30) := FND_API.G_MISS_CHAR;
7165: