APPS.OZF_QP_DISCOUNTS_PVT dependencies on OZF_OFFERS

Line 30: SELECT 'X' FROM qp_list_lines a, ozf_offer_discount_lines b, ozf_offers c WHERE

26: CURSOR c_valid_offer(p_offer_discount_line_id NUMBER, p_list_line_id NUMBER) IS
27: SELECT 1 FROM DUAL
28: WHERE exists
29: (
30: SELECT 'X' FROM qp_list_lines a, ozf_offer_discount_lines b, ozf_offers c WHERE
31: a.list_header_id = c.qp_list_header_id
32: AND b.offer_id = c.offer_id
33: AND a.list_line_id = p_list_line_id
34: AND b.offer_discount_line_id = p_offer_discount_line_id