APPS.OZF_FUND_UTILIZED_PVT dependencies on OZF_SYS_PARAMETERS_ALL

Line 345: FROM ozf_sys_parameters_all sob

341: /*
342: -- yzhao: 11.5.10 check if post to gl for off invoice discount
343: CURSOR c_offinvoice_gl_post_flag(p_fund_id IN NUMBER) IS
344: SELECT NVL(sob.gl_acct_for_offinv_flag, 'F')
345: FROM ozf_sys_parameters_all sob
346: ,ozf_funds_all_b fun
347: WHERE fun.fund_id = p_fund_id
348: AND sob.org_id = fun.ORG_id ;
349: */

Line 352: FROM ozf_sys_parameters_all sob

348: AND sob.org_id = fun.ORG_id ;
349: */
350: CURSOR c_offinvoice_gl_post_flag(p_org_id IN NUMBER) IS
351: SELECT NVL(sob.gl_acct_for_offinv_flag, 'F')
352: FROM ozf_sys_parameters_all sob
353: WHERE sob.org_id = p_org_id;
354:
355: -- yzhao: R12 update ozf_object_fund_summary table
356: CURSOR c_get_objfundsum_rec(p_object_type IN VARCHAR2, p_object_id IN NUMBER, p_fund_id IN NUMBER) IS

Line 453: FROM ozf_sys_parameters_all

449:
450: --Added for bug 7030415
451: CURSOR c_get_conversion_type( p_org_id IN NUMBER) IS
452: SELECT exchange_rate_type
453: FROM ozf_sys_parameters_all
454: WHERE org_id = p_org_id;
455:
456: CURSOR c_offer_org_id (p_plan_id IN NUMBER) IS
457: SELECT orig_org_id

Line 4365: FROM ozf_sys_parameters_all

4361:
4362: --Added for bug 7030415
4363: CURSOR c_get_conversion_type( p_org_id IN NUMBER) IS
4364: SELECT exchange_rate_type
4365: FROM ozf_sys_parameters_all
4366: WHERE org_id = p_org_id;
4367:
4368: CURSOR c_offer_currency (p_activity_id IN NUMBER) IS
4369: SELECT NVL(transaction_currency_code,fund_request_curr_code) fund_request_curr_code,