APPS.OZF_QP_DISCOUNTS_PVT dependencies on DUAL

Line 27: SELECT 1 FROM DUAL

23: , x_return_status OUT NOCOPY VARCHAR2
24: )
25: IS
26: CURSOR c_valid_offer(p_offer_discount_line_id NUMBER, p_list_line_id NUMBER) IS
27: SELECT 1 FROM DUAL
28: WHERE exists
29: (
30: SELECT 'X' FROM qp_list_lines a, ozf_offer_discount_lines b, ozf_offers c WHERE
31: a.list_header_id = c.qp_list_header_id

Line 283: SELECT ozf_qp_discounts_s.nextval FROM DUAL;

279: l_object_version_number NUMBER;
280: l_qp_disc_rec qp_discount_rec_type;
281:
282: CURSOR c_id IS
283: SELECT ozf_qp_discounts_s.nextval FROM DUAL;
284:
285: CURSOR c_id_exists(p_qp_discount_id NUMBER)
286: is
287: SELECT 1 FROM dual

Line 287: SELECT 1 FROM dual

283: SELECT ozf_qp_discounts_s.nextval FROM DUAL;
284:
285: CURSOR c_id_exists(p_qp_discount_id NUMBER)
286: is
287: SELECT 1 FROM dual
288: WHERE EXISTS(SELECT 'X' FROM ozf_qp_discounts WHERE ozf_qp_discount_id = p_qp_discount_id);
289:
290: BEGIN
291: -- INITIALIZE