APPS.OZF_OFFER_ADJ_PRODUCTS_PVT dependencies on DUAL

Line 93: SELECT 1 FROM dual WHERE EXISTS

89: )
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

Line 332: SELECT 1 FROM DUAL WHERE EXISTS (SELECT 'X'

328: , x_return_status OUT NOCOPY VARCHAR2
329: )
330: IS
331: CURSOR C(p_offer_discount_line_id NUMBER, p_off_discount_product_id NUMBER) is
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

Line 551: SELECT ozf_offer_adj_products_s.nextval from dual;

547: l_adj_prod offer_adj_prod_rec;
548:
549: l_object_version_number NUMBER;
550: CURSOR C_ID IS
551: SELECT ozf_offer_adj_products_s.nextval from dual;
552: l_offer_adjustment_product_id NUMBER;
553:
554: CURSOR c_id_exists(l_offer_adjustment_product_id NUMBER)
555: IS

Line 556: SELECT 1 FROM DUAL WHERE EXISTS (SELECT 'X' FROM ozf_offer_adjustment_products where offer_adjustment_product_id = l_offer_adjustment_product_id);

552: l_offer_adjustment_product_id NUMBER;
553:
554: CURSOR c_id_exists(l_offer_adjustment_product_id NUMBER)
555: IS
556: SELECT 1 FROM DUAL WHERE EXISTS (SELECT 'X' FROM ozf_offer_adjustment_products where offer_adjustment_product_id = l_offer_adjustment_product_id);
557: l_dummy NUMBER;
558:
559: l_excluder_flag VARCHAR2(1) := 'N';
560: BEGIN