APPS.OZF_RESALE_COMMON_PVT dependencies on OZF_SYS_PARAMETERS

Line 923: from ozf_sys_parameters;

919: WHERE resale_batch_id = p_id;
920:
921: CURSOR allowed_or_claimed_csr IS
922: SELECT ship_debit_calc_type
923: from ozf_sys_parameters;
924: --Bug# 8418811 fixed by muthsubr(+)
925: /*
926: -- bug 5969118 Ship and Debit return order generates positive claim amount
927: CURSOR c_batch_type(p_batch_id NUMBER) IS

Line 6828: FROM ozf_sys_parameters_all sob

6824: WHERE qp_list_header_id = p_offer_id;
6825:
6826: CURSOR c_offinvoice_gl_post_flag(p_org_id IN NUMBER) IS
6827: SELECT NVL(sob.gl_acct_for_offinv_flag, 'F')
6828: FROM ozf_sys_parameters_all sob
6829: WHERE sob.org_id = p_org_id;
6830:
6831:
6832: CURSOR ozf_vol_int_exists_csr IS

Line 7936: , ozf_sys_parameters org

7932: CURSOR csr_get_sys_params( p_org_id IN NUMBER) IS
7933: SELECT gs.currency_code
7934: ,org.exchange_rate_type
7935: FROM gl_sets_of_books gs
7936: , ozf_sys_parameters org
7937: WHERE org.set_of_books_id = gs.set_of_books_id
7938: AND org.org_id = p_org_id;
7939:
7940: CURSOR draft_utilization_id_csr IS