APPS.OZF_OFFR_ELIG_PROD_DENORM_PVT dependencies on OZF_OFFER_DISCOUNT_LINES

Line 944: FROM ozf_offer_discount_lines

940: -- ie the line belonging to the PBH header line
941:
942: CURSOR c_lines(l_offer_id NUMBER) IS
943: SELECT offer_discount_line_id
944: FROM ozf_offer_discount_lines
945: WHERE offer_id = l_offer_id
946: AND offer_discount_line_id = NVL(p_lline_id, offer_discount_line_id)
947: AND tier_type = 'PBH';
948:

Line 951: FROM ozf_offer_discount_lines

947: AND tier_type = 'PBH';
948:
949: CURSOR c_no_lines(l_offer_id NUMBER) IS
950: SELECT COUNT(*)
951: FROM ozf_offer_discount_lines
952: WHERE offer_id = l_offer_id
953: AND offer_discount_line_id = NVL(p_lline_id, offer_discount_line_id)
954: AND tier_type = 'PBH';
955:

Line 2561: FROM ozf_offer_discount_lines a, ozf_offers b

2557: AND arc_act_product_used_by = 'OFFR'
2558: AND excluded_flag = 'N'
2559: UNION
2560: SELECT distinct offer_discount_line_id lline_id
2561: FROM ozf_offer_discount_lines a, ozf_offers b
2562: WHERE b.qp_list_header_id = ll_list_header_id
2563: AND a.offer_id = b.offer_id
2564: AND b.offer_type = 'VOLUME_OFFER'
2565: and a.tier_type = 'PBH'