APPS.OZF_VOLUME_OFFER_DISC_PVT dependencies on DUAL

Line 75: SELECT 'Y' from dual where exists (SELECT 'X' FROM ozf_offer_discount_lines WHERE offer_discount_line_id = cp_offerDiscountLineId AND tier_type = 'PBH');

71: ( p_offerDiscountLineId IN NUMBER)
72: RETURN VARCHAR2
73: IS
74: CURSOR c_discountLineExists(cp_offerDiscountLineId NUMBER) is
75: SELECT 'Y' from dual where exists (SELECT 'X' FROM ozf_offer_discount_lines WHERE offer_discount_line_id = cp_offerDiscountLineId AND tier_type = 'PBH');
76: l_discountLineExists VARCHAR2(1) := 'Y';
77: BEGIN
78: OPEN c_discountLineExists(p_offerDiscountLineId );
79: FETCH c_discountLineExists INTO l_discountLineExists;

Line 96: SELECT 1 FROM DUAL WHERE EXISTS

92: IS
93: l_valid_flag VARCHAR2(1);
94: CURSOR c_name(p_name IN VARCHAR2 , p_offer_id IN NUMBER)
95: IS
96: SELECT 1 FROM DUAL WHERE EXISTS
97: (
98: SELECT 1 FROM OZF_OFFR_DISC_STRUCT_NAME_TL tl, ozf_offr_disc_struct_name_b b, ozf_offer_discount_lines l
99: WHERE b.offr_disc_struct_name_id = tl.offr_disc_struct_name_id
100: AND tl.LANGUAGE = userenv('LANG')

Line 847: SELECT 1 FROM dual WHERE EXISTS(SELECT 'X'

843: , cp_offerId NUMBER
844: , cp_parentDiscountLineId NUMBER
845: , cp_offerDiscountLineId NUMBER
846: ) IS
847: SELECT 1 FROM dual WHERE EXISTS(SELECT 'X'
848: FROM ozf_offer_discount_lines
849: WHERE tier_type = 'DIS'
850: AND (
851: ( cp_volumeFrom BETWEEN volume_from AND volume_to)

Line 883: SELECT 1 FROM dual WHERE EXISTS(SELECT 'X'

879:
880: FUNCTION discontinuous_tiers_exist(p_volumeFrom NUMBER, p_volumeTo NUMBER, p_offerId NUMBER , p_offerDiscountLineId NUMBER)
881: RETURN VARCHAR2 IS
882: CURSOR c_getContinuousTiers(cp_volumeFrom NUMBER,cp_volumeTo NUMBER , cp_offerId NUMBER, cp_offerDiscountLineId NUMBER) IS
883: SELECT 1 FROM dual WHERE EXISTS(SELECT 'X'
884: FROM ozf_offer_discount_lines
885: WHERE tier_type = 'DIS'
886: AND (
887: (volume_to IN (cp_volumeFrom , cp_volumeFrom -1 ))

Line 897: FROM dual

893: );
894:
895: CURSOR c_tiersExist( cp_parentDiscountLineId NUMBER )IS
896: SELECT 'Y'
897: FROM dual
898: WHERE EXISTS (SELECT 'X'
899: FROM ozf_offer_discount_lines
900: WHERE parent_discount_line_id = cp_parentDiscountLineId
901: );

Line 2004: FROM dual;

2000: l_object_version_number NUMBER;
2001: l_dummy NUMBER;
2002: CURSOR c_id IS
2003: SELECT ozf_offer_discount_lines_s.NEXTVAL
2004: FROM dual;
2005:
2006: CURSOR c_id_exists (l_id IN NUMBER) IS
2007: SELECT 1
2008: FROM OZF_OFFER_DISCOUNT_LINES

Line 2013: FROM dual;

2009: WHERE offer_discount_line_id = l_id;
2010:
2011: CURSOR c_struct_id IS
2012: SELECT ozf_offr_disc_struct_name_s.NEXTVAL
2013: FROM dual;
2014:
2015: CURSOR c_struct_id_exists (l_id IN NUMBER) IS
2016: SELECT 1
2017: FROM ozf_offr_disc_struct_name_b

Line 2799: SELECT 1 FROM DUAL WHERE EXISTS (SELECT 1

2795: l_uom_code c_uom_code%rowtype;
2796:
2797: CURSOR c_general_uom(p_uom_code VARCHAR2)
2798: IS
2799: SELECT 1 FROM DUAL WHERE EXISTS (SELECT 1
2800: FROM mtl_units_of_measure_vl
2801: WHERE uom_code = p_uom_code);
2802: l_general_uom c_general_uom%rowtype;
2803: l_list_header_id NUMBER;

Line 3362: FROM dual;

3358: l_object_version_number NUMBER;
3359: l_dummy NUMBER;
3360: CURSOR c_id IS
3361: SELECT ozf_offer_discount_products_s.NEXTVAL
3362: FROM dual;
3363:
3364: CURSOR c_id_exists (l_id IN NUMBER) IS
3365: SELECT 1
3366: FROM OZF_OFFER_DISCOUNT_PRODUCTS