APPS.OZF_MO_PRESET_TIERS_PVT dependencies on DUAL

Line 162: SELECT 1 FROM DUAL

158: )
159: IS
160: CURSOR c_pbh(p_pbh_discount_id NUMBER)
161: IS
162: SELECT 1 FROM DUAL
163: WHERE EXISTS( SELECT 'X' FROM ozf_offer_discount_lines WHERE offer_discount_line_id = p_pbh_discount_id AND tier_type = 'PBH');
164:
165: CURSOR c_dis(p_dis_discount_id NUMBER)
166: IS

Line 167: SELECT 1 FROM dual WHERE EXISTS (SELECT 'X' FROM ozf_offer_discount_lines WHERE offer_discount_line_id = p_dis_discount_id AND tier_type = 'DIS');

163: WHERE EXISTS( SELECT 'X' FROM ozf_offer_discount_lines WHERE offer_discount_line_id = p_pbh_discount_id AND tier_type = 'PBH');
164:
165: CURSOR c_dis(p_dis_discount_id NUMBER)
166: IS
167: SELECT 1 FROM dual WHERE EXISTS (SELECT 'X' FROM ozf_offer_discount_lines WHERE offer_discount_line_id = p_dis_discount_id AND tier_type = 'DIS');
168:
169: l_dummy NUMBER;
170: BEGIN
171: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 217: SELECT 1 FROM dual

213: , x_return_status OUT NOCOPY VARCHAR2
214: )
215: IS
216: CURSOR c_valid(p_dis_discount_id NUMBER, p_pbh_discount_id NUMBER) IS
217: SELECT 1 FROM dual
218: WHERE EXISTS(
219: SELECT 'x' FROM ozf_offer_discount_lines
220: WHERE offer_discount_line_id = p_dis_discount_id
221: AND parent_discount_line_id = p_pbh_discount_id);

Line 369: FROM DUAL;

365:
366: l_preset_tier_rec mo_preset_rec_type;
367: CURSOR c_id IS
368: SELECT ozf_market_preset_tiers_s.nextval
369: FROM DUAL;
370:
371: CURSOR c_id_exists(l_market_preset_tier_id NUMBER)
372: is
373: SELECT 1 FROM dual WHERE exists(SELECT 'X' FROM ozf_market_preset_tiers WHERE market_preset_tier_id = l_market_preset_tier_id);

Line 373: SELECT 1 FROM dual WHERE exists(SELECT 'X' FROM ozf_market_preset_tiers WHERE market_preset_tier_id = l_market_preset_tier_id);

369: FROM DUAL;
370:
371: CURSOR c_id_exists(l_market_preset_tier_id NUMBER)
372: is
373: SELECT 1 FROM dual WHERE exists(SELECT 'X' FROM ozf_market_preset_tiers WHERE market_preset_tier_id = l_market_preset_tier_id);
374: BEGIN
375: -- initialize
376: -- savepoint
377: SAVEPOINT Create_mo_preset_tiers;