APPS.QP_PRICE_BOOK_UTIL dependencies on OE_AGREEMENTS_VL

Line 112: FROM oe_agreements_vl a

108: x_return NUMBER;
109: BEGIN
110: SELECT agreement_id
111: INTO x_return
112: FROM oe_agreements_vl a
113: WHERE name = p_agreement_name
114: AND trunc(nvl(p_pricing_effective_date, sysdate))
115: between trunc(nvl(a.start_date_active,
116: p_pricing_effective_date))

Line 1909: FROM oe_agreements_vl

1905: ELSIF p_pb_input_header_rec.price_based_on = 'AGREEMENT' THEN
1906: BEGIN
1907: SELECT 1
1908: INTO l_count
1909: FROM oe_agreements_vl
1910: WHERE agreement_id = p_pb_input_header_rec.pl_agr_bsa_id
1911: AND (sold_to_org_id = -1 OR
1912: sold_to_org_id IN (SELECT cust_account_id
1913: FROM hz_cust_accounts