APPS.OZF_OFFER_PVT dependencies on OZF_SUPP_TRD_PRFLS_ALL

Line 11131: FROM ozf_supp_trd_prfls_all

11127:
11128:
11129: CURSOR c_get_grace_days(l_supplier_site_id NUMBER) IS
11130: SELECT nvl(grace_days,0)
11131: FROM ozf_supp_trd_prfls_all
11132: WHERE supplier_site_id = l_supplier_site_id;
11133:
11134:
11135: BEGIN

Line 11402: FROM ozf_supp_trd_prfls_all

11398: WHERE request_header_id = p_sdr_header_id;
11399:
11400: CURSOR cur_get_qty_inc_flag(p_supplier_site_id NUMBER) IS
11401: SELECT allow_qty_increase
11402: FROM ozf_supp_trd_prfls_all
11403: WHERE supplier_site_id = p_supplier_site_id;
11404:
11405:
11406: CURSOR cur_get_limit_id(p_list_line_id NUMBER) IS

Line 12180: FROM ozf_supp_trd_prfls_all

12176: WHERE request_header_id=l_sdr_hdr_id;
12177:
12178: CURSOR c_supp_trd_prfl_info(l_supplier_site_id NUMBER) IS
12179: SELECT cust_account_id, site_use_id
12180: FROM ozf_supp_trd_prfls_all
12181: WHERE supplier_site_id=l_supplier_site_id;
12182:
12183:
12184: CURSOR c_allow_qty_increase(l_supplier_site_id NUMBER) IS

Line 12186: FROM ozf_supp_trd_prfls_all

12182:
12183:
12184: CURSOR c_allow_qty_increase(l_supplier_site_id NUMBER) IS
12185: SELECT allow_qty_increase
12186: FROM ozf_supp_trd_prfls_all
12187: WHERE supplier_site_id=l_supplier_site_id;
12188:
12189: CURSOR c_offer_access(l_qp_list_header_id NUMBER,l_request_header_id NUMBER) IS
12190: SELECT access_id,user_id,status