APPS.OZF_VOLUME_OFFER_ADJ dependencies on OZF_OFFER_ADJUSTMENT_TIERS

Line 38: FROM ozf_offer_discount_lines a, ozf_offer_adjustment_tiers b

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

Line 81: FROM ozf_offer_adjustment_tiers

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

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

254: IS
255: CURSOR c_qpListLines(cp_offerAdjustmentId NUMBER)
256: IS
257: SELECT distinct parent_discount_line_id , c.list_line_id
258: FROM ozf_offer_adjustment_tiers a, ozf_offer_discount_lines b , ozf_qp_discounts c
259: WHERE a.offer_discount_line_id = b.offer_discount_line_id
260: AND b.parent_discount_line_id = c.offer_discount_line_id
261: AND a.offer_adjustment_id = cp_offerAdjustmentId;
262: BEGIN

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

931: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
932: CURSOR c_tierHeader(cp_offerAdjustmentId NUMBER)
933: IS
934: SELECT distinct parent_discount_line_id , c.list_line_id
935: FROM ozf_offer_adjustment_tiers a, ozf_offer_discount_lines b , ozf_qp_discounts c , qp_list_lines d
936: WHERE a.offer_discount_line_id = b.offer_discount_line_id
937: AND b.parent_discount_line_id = c.offer_discount_line_id
938: AND c.list_line_id = d.list_line_id
939: AND d.list_line_type_code = 'PBH'