APPS.OZF_OFFER_ADJ_PRODUCTS_PVT dependencies on OZF_OFFERS

Line 71: SELECT a.offer_type FROM ozf_offers a, ozf_offer_adjustments_b b

67: )
68: RETURN VARCHAR2
69: IS
70: CURSOR c_offerType(cp_offerAdjustmentId NUMBER) IS
71: SELECT a.offer_type FROM ozf_offers a, ozf_offer_adjustments_b b
72: WHERE a.qp_list_header_id = b.list_header_id
73: AND b.offer_adjustment_id = cp_offerAdjustmentId;
74: l_offerType VARCHAR2(30);
75: BEGIN

Line 94: (SELECT 'X' FROM ozf_offer_discount_products a, ozf_offer_adjustments_b b, ozf_offers c

90: IS
91: /*CURSOR c_prod(p_offer_adjustment_id NUMBER,p_product_context VARCHAR2, p_product_attribute VARCHAR2, p_product_attr_value VARCHAR2, p_excluder_flag VARCHAR2)
92: IS
93: SELECT 1 FROM dual WHERE EXISTS
94: (SELECT 'X' FROM ozf_offer_discount_products a, ozf_offer_adjustments_b b, ozf_offers c
95: WHERE
96: a.offer_id = c.offer_id
97: AND c.qp_list_header_id = b.list_header_id
98: AND b.offer_adjustment_id = p_offer_adjustment_id

Line 106: FROM ozf_offers a, ozf_offer_adjustments_b b

102: AND excluder_flag = p_excluder_flag ;
103: */
104: CURSOR c_offerId (cp_offerAdjustmentId NUMBER) IS
105: SELECT a.offer_id
106: FROM ozf_offers a, ozf_offer_adjustments_b b
107: WHERE a.qp_list_header_id = b.list_header_id
108: AND b.offer_adjustment_id = cp_offerAdjustmentId;
109:
110: l_attr varchar2(500) := 'product_attribute = ''' || p_adj_prod.product_attribute ||''' AND product_attr_value = '''|| p_adj_prod.product_attr_value ;

Line 336: , ozf_offers d

332: SELECT 1 FROM DUAL WHERE EXISTS (SELECT 'X'
333: FROM ozf_offer_discount_lines a
334: , ozf_offer_discount_products b
335: , ozf_offer_adjustments_b c
336: , ozf_offers d
337: WHERE a.offer_discount_line_id = b.offer_discount_line_id
338: AND a.offer_id = d.offer_id
339: AND d.qp_list_header_id = c.list_header_id
340: AND a.offer_discount_line_id = p_offer_discount_line_id