APPS.OZF_OFFER_BACKDATE_PVT dependencies on OZF_OFFER_DISCOUNT_LINES

Line 1753: FROM ozf_offer_adjustment_products a, ozf_offer_discount_products b , ozf_offer_discount_lines c , ozf_offers d , ozf_offer_adjustments_b e

1749: , c.discount_type
1750: , e.effective_date
1751: , a.apply_discount_flag
1752: , a.include_volume_flag
1753: FROM ozf_offer_adjustment_products a, ozf_offer_discount_products b , ozf_offer_discount_lines c , ozf_offers d , ozf_offer_adjustments_b e
1754: WHERE a.offer_discount_line_id = c.offer_discount_line_id
1755: AND b.offer_discount_line_id = c.offer_discount_line_id
1756: AND a.product_context = b.product_context
1757: AND a.product_attribute = b.product_attribute

Line 1766: FROM ozf_offer_discount_lines where parent_discount_line_id = p_offer_discount_line_id;

1762: AND a.offer_adjustment_id = p_offer_adjustment_id;
1763:
1764: CURSOR c_adj_prod_dis(p_offer_discount_line_id number) IS
1765: SELECT volume_from, volume_to, discount_type, discount
1766: FROM ozf_offer_discount_lines where parent_discount_line_id = p_offer_discount_line_id;
1767:
1768: i NUMBER:= 0;
1769: k NUMBER := 0;
1770: l_modifiers_tbl Qp_Modifiers_Pub.modifiers_tbl_type;

Line 1941: FROM ozf_offer_adjustment_products a, ozf_offer_discount_lines b, ozf_offer_adjustments_b c, qp_list_lines d

1937: AND a.product_attr_value = d.product_attr_value
1938: AND a.offer_adjustment_id = p_offer_adjustment_id;
1939: CURSOR c_prod_reln(p_offer_adjustment_id NUMBER) IS
1940: SELECT b.offer_discount_line_id , d.list_line_id
1941: FROM ozf_offer_adjustment_products a, ozf_offer_discount_lines b, ozf_offer_adjustments_b c, qp_list_lines d
1942: WHERE a.offer_discount_line_id = DECODE(b.tier_type,'PBH',offer_discount_line_id,parent_discount_line_id)
1943: AND b.offer_adjustment_id = a.offer_adjustment_id
1944: AND a.offer_adjustment_id = p_offer_adjustment_id
1945: AND c.list_header_id = d.list_header_id

Line 1952: FROM ozf_offer_adjustment_products a, ozf_offer_discount_products b, ozf_offer_discount_lines c , ozf_offer_adjustments_b e ,qp_pricing_attributes d

1948: --AND nvl(b.discount_type,'-1') = nvl(d.arithmetic_operator)
1949: */
1950: CURSOR c_create_reln(p_offer_adjustment_id NUMBER) IS
1951: SELECT c.offer_discount_line_id, b.off_discount_product_id , d.list_line_id , d.pricing_attribute_id
1952: FROM ozf_offer_adjustment_products a, ozf_offer_discount_products b, ozf_offer_discount_lines c , ozf_offer_adjustments_b e ,qp_pricing_attributes d
1953: WHERE a.offer_discount_line_id = b.offer_discount_line_id
1954: AND a.product_attr_value = b.product_attr_value
1955: AND a.offer_adjustment_id = p_offer_adjustment_id
1956: AND b.offer_discount_line_id = decode(c.tier_type , 'DIS',c.parent_discount_line_id, c.offer_discount_line_id)

Line 2201: FROM ozf_offer_adjustment_tiers a, ozf_offer_discount_lines b

2197: DECLARE
2198: CURSOR c_discounts(p_offer_adjustment_id NUMBER) IS
2199: SELECT
2200: a.modified_discount, a.offer_discount_line_id , b.object_version_number , b.offer_id
2201: FROM ozf_offer_adjustment_tiers a, ozf_offer_discount_lines b
2202: WHERE a.offer_adjustment_id = p_offer_adjustment_id
2203: AND a.offer_discount_line_id = b.offer_discount_line_id;
2204: l_vo_disc_rec OZF_Volume_Offer_disc_PVT.vo_disc_rec_type;
2205: BEGIN

Line 2295: FROM ozf_offer_adjustment_tiers a, ozf_offer_adjustments_b b , ozf_offer_discount_lines c , qp_list_lines d , qp_pricing_attributes e , ozf_offer_discount_products f

2291: DECLARE
2292: CURSOR c_create_reln(p_offer_adjustment_id NUMBER)
2293: IS
2294: SELECT a.offer_discount_line_id , f.off_discount_product_id , e.pricing_attribute_id , d.list_line_id
2295: FROM ozf_offer_adjustment_tiers a, ozf_offer_adjustments_b b , ozf_offer_discount_lines c , qp_list_lines d , qp_pricing_attributes e , ozf_offer_discount_products f
2296: WHERE a.offer_adjustment_id = b.offer_adjustment_id
2297: AND c.offer_discount_line_id = a.offer_discount_line_id
2298: AND b.list_header_id = d.list_header_id
2299: AND d.list_line_id = e.list_line_id