APPS.OZF_ACCRUAL_ENGINE dependencies on OZF_SYS_PARAMETERS_ALL

Line 458: FROM ozf_sys_parameters_all

454:
455: -- added for bug 7030415
456: CURSOR c_get_conversion_type( p_org_id IN NUMBER) IS
457: SELECT exchange_rate_type
458: FROM ozf_sys_parameters_all
459: WHERE org_id = p_org_id;
460:
461: BEGIN
462: IF g_debug_flag = 'Y' THEN

Line 881: FROM ozf_sys_parameters_all

877: */
878: /*
879: CURSOR c_order_sob(p_org_id IN NUMBER) IS
880: SELECT SET_OF_BOOKS_ID
881: FROM ozf_sys_parameters_all
882: WHERE org_id = p_org_id;
883:
884: -- yzhao: 11.5.10 check if post to gl for off invoice discount
885: CURSOR c_fund_sob(p_fund_id IN NUMBER) IS

Line 887: FROM ozf_sys_parameters_all sob

883:
884: -- yzhao: 11.5.10 check if post to gl for off invoice discount
885: CURSOR c_fund_sob(p_fund_id IN NUMBER) IS
886: SELECT sob.set_of_books_id, fun.ORG_id, NVL(sob.gl_acct_for_offinv_flag, 'F')
887: FROM ozf_sys_parameters_all sob
888: ,ozf_funds_all_b fun
889: WHERE fun.fund_id = p_fund_id
890: AND sob.org_id = fun.ORG_id ;
891: */

Line 895: FROM ozf_sys_parameters_all sob

891: */
892:
893: CURSOR c_fund_ledger(p_fund_id IN NUMBER) IS
894: SELECT fun.ledger_id
895: FROM ozf_sys_parameters_all sob
896: ,ozf_funds_all_b fun
897: WHERE fun.fund_id = p_fund_id
898: AND sob.org_id = fun.org_id;
899:

Line 902: FROM ozf_sys_parameters_all sob

898: AND sob.org_id = fun.org_id;
899:
900: CURSOR c_offinv_flag(p_org_id IN NUMBER) IS
901: SELECT NVL(sob.gl_acct_for_offinv_flag, 'F')
902: FROM ozf_sys_parameters_all sob
903: WHERE sob.org_id = p_org_id;
904:
905: -- yzhao: 11.5.10 populate reference_type/id for special pricing
906: CURSOR c_get_request_header_id(p_list_header_id IN NUMBER) IS

Line 944: FROM ozf_sys_parameters_all

940:
941: -- nirprasa, cursor for currency conversion type.
942: CURSOR c_get_conversion_type( p_org_id IN NUMBER) IS
943: SELECT exchange_rate_type
944: FROM ozf_sys_parameters_all
945: WHERE org_id = p_org_id;
946:
947: BEGIN
948: --------------------- initialize -----------------------

Line 2022: FROM ozf_sys_parameters_all

2018:
2019: --Added for bug 7030415, get conversion type
2020: CURSOR c_get_conversion_type( p_org_id IN NUMBER) IS
2021: SELECT exchange_rate_type
2022: FROM ozf_sys_parameters_all
2023: WHERE org_id = p_org_id;
2024:
2025: --Added c_site_org_id for bug 6278466
2026: CURSOR c_site_org_id (p_site_use_id IN NUMBER) IS

Line 2426: FROM ozf_sys_parameters_all

2422:
2423: -- added for bug 7030415 get conversion type
2424: CURSOR c_get_conversion_type( p_org_id IN NUMBER) IS
2425: SELECT exchange_rate_type
2426: FROM ozf_sys_parameters_all
2427: WHERE org_id = p_org_id;
2428:
2429: BEGIN
2430: SAVEPOINT adjust_accrual;

Line 4603: FROM ozf_sys_parameters_all

4599:
4600: --nirprasa, added for bug 7030415.
4601: CURSOR c_get_conversion_type( p_org_id IN NUMBER) IS
4602: SELECT exchange_rate_type
4603: FROM ozf_sys_parameters_all
4604: WHERE org_id = p_org_id;
4605:
4606: CURSOR c_get_fund (p_fund_id IN NUMBER) IS
4607: SELECT object_version_number, parent_fund_id, currency_code_tc,liability_flag,accrual_basis

Line 4644: FROM ozf_sys_parameters_all sob

4640: AND fund_id = p_fund_id;
4641:
4642: CURSOR c_offinv_flag(p_org_id IN NUMBER) IS
4643: SELECT NVL(sob.gl_acct_for_offinv_flag, 'F')
4644: FROM ozf_sys_parameters_all sob
4645: WHERE sob.org_id = p_org_id;
4646:
4647: BEGIN
4648: SAVEPOINT post_accrual_to_gl_sp;