APPS.OZF_QP_PRODUCTS_PVT dependencies on OZF_OFFERS

Line 139: SELECT qp_list_header_id FROM ozf_offers WHERE offer_id = (SELECT offer_id FROM ozf_offer_discount_products WHERE off_discount_product_id = p_off_discount_product_id);

135: SELECT list_header_id FROM qp_pricing_attributes WHERE pricing_attribute_id = p_pricing_attribute_id;
136: l_list_header NUMBER;
137: CURSOR c_list_header2 (p_off_discount_product_id NUMBER)
138: IS
139: SELECT qp_list_header_id FROM ozf_offers WHERE offer_id = (SELECT offer_id FROM ozf_offer_discount_products WHERE off_discount_product_id = p_off_discount_product_id);
140: l_list_header2 NUMBER;
141: BEGIN
142: x_return_status := FND_API.G_RET_STS_SUCCESS;
143: OPEN c_list_header(p_qp_product_rec.pricing_attribute_id);