APPS.OZF_VOLUME_OFFER_ADJ dependencies on QP_RLTD_MODIFIERS

Line 561: FROM qp_rltd_modifiers a, ozf_qp_discounts b , ozf_offer_adjustment_tiers c , qp_list_lines d

557: IS
558: CURSOR c_discountLines(cp_listLineId NUMBER , cp_offerAdjustmentId NUMBER)
559: IS
560: SELECT a.from_rltd_modifier_id, a.to_rltd_modifier_id, b.offer_discount_line_id , nvl(c.modified_discount,d.operand) discount , d.arithmetic_operator
561: FROM qp_rltd_modifiers a, ozf_qp_discounts b , ozf_offer_adjustment_tiers c , qp_list_lines d
562: WHERE a.to_rltd_modifier_id = b.list_line_id(+)
563: and b.offer_discount_line_id = c.offer_discount_line_id(+)
564: AND a.to_rltd_modifier_id = d.list_line_id
565: AND a.from_rltd_modifier_id = cp_listLineId

Line 569: FROM qp_rltd_modifiers

565: AND a.from_rltd_modifier_id = cp_listLineId
566: AND c.offer_adjustment_id(+) = cp_offerAdjustmentId;
567:
568: /*SELECT to_rltd_modifier_id
569: FROM qp_rltd_modifiers
570: WHERE from_rltd_modifier_id = cp_listLineId;
571: */
572: i NUMBER;
573: l_pricingAttrTbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;