APPS.OZF_VOLUME_OFFER_ADJ dependencies on OZF_OFFER_ADJUSTMENT_TIERS

Line 36: FROM ozf_offer_discount_lines a, ozf_offer_adjustment_tiers b

32: SELECT a.object_version_number
33: , a.offer_id
34: , a.parent_discount_line_id
35: , b.modified_discount
36: FROM ozf_offer_discount_lines a, ozf_offer_adjustment_tiers b
37: WHERE a.offer_discount_line_id = b.offer_discount_line_id
38: AND b.offer_discount_line_id = cp_offerDiscountLineId
39: AND b.offer_adjustment_id = cp_offerAdjustmentId;
40: BEGIN

Line 79: FROM ozf_offer_adjustment_tiers

75: IS
76: CURSOR c_adjustmentTiers(cp_offerAdjustmentId NUMBER)
77: IS
78: SELECT offer_discount_line_id
79: FROM ozf_offer_adjustment_tiers
80: WHERE offer_adjustment_id = cp_offerAdjustmentId;
81: BEGIN
82: -- initialize return status
83: -- loop thru. all adjustment tiers

Line 203: FROM ozf_offer_adjustment_tiers a, ozf_offer_discount_lines b , ozf_qp_discounts c

199: IS
200: CURSOR c_qpListLines(cp_offerAdjustmentId NUMBER)
201: IS
202: SELECT distinct parent_discount_line_id , c.list_line_id
203: FROM ozf_offer_adjustment_tiers a, ozf_offer_discount_lines b , ozf_qp_discounts c
204: WHERE a.offer_discount_line_id = b.offer_discount_line_id
205: AND b.parent_discount_line_id = c.offer_discount_line_id
206: AND a.offer_adjustment_id = cp_offerAdjustmentId;
207: BEGIN

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 880: FROM ozf_offer_adjustment_tiers a, ozf_offer_discount_lines b , ozf_qp_discounts c , qp_list_lines d

876: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
877: CURSOR c_tierHeader(cp_offerAdjustmentId NUMBER)
878: IS
879: SELECT distinct parent_discount_line_id , c.list_line_id
880: FROM ozf_offer_adjustment_tiers a, ozf_offer_discount_lines b , ozf_qp_discounts c , qp_list_lines d
881: WHERE a.offer_discount_line_id = b.offer_discount_line_id
882: AND b.parent_discount_line_id = c.offer_discount_line_id
883: AND c.list_line_id = d.list_line_id
884: AND d.list_line_type_code = 'PBH'