APPS.OZF_ACCRUAL_ENGINE dependencies on OZF_SYS_PARAMETERS_ALL

Line 545: FROM ozf_sys_parameters_all

541:
542: -- added for bug 7030415
543: CURSOR c_get_conversion_type( p_org_id IN NUMBER) IS
544: SELECT exchange_rate_type
545: FROM ozf_sys_parameters_all
546: WHERE org_id = p_org_id;
547:
548: CURSOR c_offer_type (p_offer_id IN NUMBER) IS
549: SELECT nvl(transaction_currency_code,fund_request_curr_code) offer_currency_code

Line 1035: FROM ozf_sys_parameters_all

1031: */
1032: /*
1033: CURSOR c_order_sob(p_org_id IN NUMBER) IS
1034: SELECT SET_OF_BOOKS_ID
1035: FROM ozf_sys_parameters_all
1036: WHERE org_id = p_org_id;
1037:
1038: -- yzhao: 11.5.10 check if post to gl for off invoice discount
1039: CURSOR c_fund_sob(p_fund_id IN NUMBER) IS

Line 1041: FROM ozf_sys_parameters_all sob

1037:
1038: -- yzhao: 11.5.10 check if post to gl for off invoice discount
1039: CURSOR c_fund_sob(p_fund_id IN NUMBER) IS
1040: SELECT sob.set_of_books_id, fun.ORG_id, NVL(sob.gl_acct_for_offinv_flag, 'F')
1041: FROM ozf_sys_parameters_all sob
1042: ,ozf_funds_all_b fun
1043: WHERE fun.fund_id = p_fund_id
1044: AND sob.org_id = fun.ORG_id ;
1045: */

Line 1057: FROM ozf_sys_parameters_all sob

1053: and fun.fund_id = p_fund_id;
1054:
1055: CURSOR c_offinv_flag(p_org_id IN NUMBER) IS
1056: SELECT NVL(sob.gl_acct_for_offinv_flag, 'F')
1057: FROM ozf_sys_parameters_all sob
1058: WHERE sob.org_id = p_org_id;
1059:
1060: -- yzhao: 11.5.10 populate reference_type/id for special pricing
1061: CURSOR c_get_request_header_id(p_list_header_id IN NUMBER) IS

Line 1099: FROM ozf_sys_parameters_all

1095:
1096: -- nirprasa, cursor for currency conversion type.
1097: CURSOR c_get_conversion_type( p_org_id IN NUMBER) IS
1098: SELECT exchange_rate_type
1099: FROM ozf_sys_parameters_all
1100: WHERE org_id = p_org_id;
1101:
1102: --kdass - bug 9470625
1103: --if formula is specified on offer line, then operand in oe_price_adjustments is not correct,

Line 2451: FROM ozf_sys_parameters_all

2447:
2448: --Added for bug 7030415, get conversion type
2449: CURSOR c_get_conversion_type( p_org_id IN NUMBER) IS
2450: SELECT exchange_rate_type
2451: FROM ozf_sys_parameters_all
2452: WHERE org_id = p_org_id;
2453:
2454: --Added c_site_org_id for bug 6278466
2455: CURSOR c_site_org_id (p_site_use_id IN NUMBER) IS

Line 2942: FROM ozf_sys_parameters_all

2938:
2939: -- added for bug 7030415 get conversion type
2940: CURSOR c_get_conversion_type( p_org_id IN NUMBER) IS
2941: SELECT exchange_rate_type
2942: FROM ozf_sys_parameters_all
2943: WHERE org_id = p_org_id;
2944:
2945: CURSOR c_offer_details(p_qp_list_header_id NUMBER) IS
2946: SELECT custom_setup_id, description

Line 5841: FROM ozf_sys_parameters_all

5837:
5838: --nirprasa, added for bug 7030415.
5839: CURSOR c_get_conversion_type( p_org_id IN NUMBER) IS
5840: SELECT exchange_rate_type
5841: FROM ozf_sys_parameters_all
5842: WHERE org_id = p_org_id;
5843:
5844: CURSOR c_get_fund (p_fund_id IN NUMBER) IS
5845: SELECT object_version_number, parent_fund_id, currency_code_tc,liability_flag,accrual_basis

Line 5882: FROM ozf_sys_parameters_all sob

5878: AND fund_id = p_fund_id;
5879:
5880: CURSOR c_offinv_flag(p_org_id IN NUMBER) IS
5881: SELECT NVL(sob.gl_acct_for_offinv_flag, 'F')
5882: FROM ozf_sys_parameters_all sob
5883: WHERE sob.org_id = p_org_id;
5884:
5885: BEGIN
5886: SAVEPOINT post_accrual_to_gl_sp;

Line 6730: FROM ozf_sys_parameters_all

6726: IS
6727:
6728: CURSOR c_get_conversion_type( p_org_id IN NUMBER) IS
6729: SELECT exchange_rate_type
6730: FROM ozf_sys_parameters_all
6731: WHERE org_id = p_org_id;
6732:
6733: CURSOR c_get_objfundsum_rec(p_object_type IN VARCHAR2, p_object_id IN NUMBER, p_fund_id IN NUMBER) IS
6734: SELECT objfundsum_id