APPS.OZF_VOLUME_OFFER_ADJ dependencies on QP_RLTD_MODIFIERS

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

502: IS
503: CURSOR c_discountLines(cp_listLineId NUMBER , cp_offerAdjustmentId NUMBER)
504: IS
505: 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
506: FROM qp_rltd_modifiers a, ozf_qp_discounts b , ozf_offer_adjustment_tiers c , qp_list_lines d
507: WHERE a.to_rltd_modifier_id = b.list_line_id(+)
508: and b.offer_discount_line_id = c.offer_discount_line_id(+)
509: AND a.to_rltd_modifier_id = d.list_line_id
510: AND a.from_rltd_modifier_id = cp_listLineId

Line 514: FROM qp_rltd_modifiers

510: AND a.from_rltd_modifier_id = cp_listLineId
511: AND c.offer_adjustment_id(+) = cp_offerAdjustmentId;
512:
513: /*SELECT to_rltd_modifier_id
514: FROM qp_rltd_modifiers
515: WHERE from_rltd_modifier_id = cp_listLineId;
516: */
517: i NUMBER;
518: l_pricingAttrTbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;