APPS.OZF_OFFER_PVT dependencies on OZF_SUPP_TRD_PRFLS_ALL

Line 10549: FROM ozf_supp_trd_prfls_all

10545:
10546:
10547: CURSOR c_get_grace_days(l_supplier_site_id NUMBER) IS
10548: SELECT nvl(grace_days,0)
10549: FROM ozf_supp_trd_prfls_all
10550: WHERE supplier_site_id = l_supplier_site_id;
10551:
10552:
10553: BEGIN

Line 10805: FROM ozf_supp_trd_prfls_all

10801: WHERE request_header_id = p_sdr_header_id;
10802:
10803: CURSOR cur_get_qty_inc_flag(p_supplier_site_id NUMBER) IS
10804: SELECT allow_qty_increase
10805: FROM ozf_supp_trd_prfls_all
10806: WHERE supplier_site_id = p_supplier_site_id;
10807:
10808:
10809: CURSOR cur_get_limit_id(p_list_line_id NUMBER) IS

Line 11372: FROM ozf_supp_trd_prfls_all

11368: WHERE request_header_id=l_sdr_hdr_id;
11369:
11370: CURSOR c_supp_trd_prfl_info(l_supplier_site_id NUMBER) IS
11371: SELECT cust_account_id, site_use_id
11372: FROM ozf_supp_trd_prfls_all
11373: WHERE supplier_site_id=l_supplier_site_id;
11374:
11375:
11376: CURSOR c_allow_qty_increase(l_supplier_site_id NUMBER) IS

Line 11378: FROM ozf_supp_trd_prfls_all

11374:
11375:
11376: CURSOR c_allow_qty_increase(l_supplier_site_id NUMBER) IS
11377: SELECT allow_qty_increase
11378: FROM ozf_supp_trd_prfls_all
11379: WHERE supplier_site_id=l_supplier_site_id;
11380:
11381: CURSOR c_offer_access(l_qp_list_header_id NUMBER,l_request_header_id NUMBER) IS
11382: SELECT access_id,user_id,status