APPS.OZF_FUND_UTILIZED_PVT dependencies on OZF_SYS_PARAMETERS_ALL

Line 240: FROM ozf_sys_parameters_all sob

236: /*
237: -- yzhao: 11.5.10 check if post to gl for off invoice discount
238: CURSOR c_offinvoice_gl_post_flag(p_fund_id IN NUMBER) IS
239: SELECT NVL(sob.gl_acct_for_offinv_flag, 'F')
240: FROM ozf_sys_parameters_all sob
241: ,ozf_funds_all_b fun
242: WHERE fun.fund_id = p_fund_id
243: AND sob.org_id = fun.ORG_id ;
244: */

Line 247: FROM ozf_sys_parameters_all sob

243: AND sob.org_id = fun.ORG_id ;
244: */
245: CURSOR c_offinvoice_gl_post_flag(p_org_id IN NUMBER) IS
246: SELECT NVL(sob.gl_acct_for_offinv_flag, 'F')
247: FROM ozf_sys_parameters_all sob
248: WHERE sob.org_id = p_org_id;
249:
250: -- yzhao: R12 update ozf_object_fund_summary table
251: CURSOR c_get_objfundsum_rec(p_object_type IN VARCHAR2, p_object_id IN NUMBER, p_fund_id IN NUMBER) IS

Line 328: FROM ozf_sys_parameters_all

324:
325: --Added for bug 7030415
326: CURSOR c_get_conversion_type( p_org_id IN NUMBER) IS
327: SELECT exchange_rate_type
328: FROM ozf_sys_parameters_all
329: WHERE org_id = p_org_id;
330:
331: -- 6657242
332: -- Cursor to get the org_id for order

Line 3870: FROM ozf_sys_parameters_all

3866:
3867: --Added for bug 7030415
3868: CURSOR c_get_conversion_type( p_org_id IN NUMBER) IS
3869: SELECT exchange_rate_type
3870: FROM ozf_sys_parameters_all
3871: WHERE org_id = p_org_id;
3872:
3873: l_exchange_rate_type VARCHAR2(30) := FND_API.G_MISS_CHAR;
3874: l_rate NUMBER;