APPS.OZF_VOLUME_OFFER_QUAL_PVT dependencies on OZF_OFFERS

Line 53: SELECT offer_id FROM ozf_offers

49: , x_msg_data OUT NOCOPY VARCHAR2
50: )
51: IS
52: CURSOR c_offer_id(p_qp_list_header_id NUMBER) IS
53: SELECT offer_id FROM ozf_offers
54: WHERE qp_list_header_id = p_qp_list_header_id
55: AND offer_type = 'VOLUME_OFFER';
56:
57: l_offer_id NUMBER;