APPS.OZF_OFFER_MARKET_OPTIONS_PVT dependencies on DUAL

Line 83: SELECT 1 FROM dual

79: )
80: IS
81: l_dummy NUMBER:= -1;
82: CURSOR c_mo_uk (p_offer_id NUMBER, p_group_number NUMBER) IS
83: SELECT 1 FROM dual
84: WHERE EXISTS
85: (SELECT 'X'
86: FROM ozf_offr_market_options
87: WHERE offer_id = p_offer_id --p_mo_rec.offer_id

Line 231: SELECT 1 FROM dual WHERE EXISTS( SELECT 'X' FROM qp_qualifiers WHERE list_header_id = p_list_header_id AND qualifier_grouping_no = p_group_number);

227: )
228: IS
229: l_dummy number := -1;
230: CURSOR c_mo_grp(p_list_header_id NUMBER, p_group_number NUMBER) IS
231: SELECT 1 FROM dual WHERE EXISTS( SELECT 'X' FROM qp_qualifiers WHERE list_header_id = p_list_header_id AND qualifier_grouping_no = p_group_number);
232:
233: BEGIN
234: x_return_status := FND_API.G_RET_STS_SUCCESS;
235: IF p_mo_rec.offer_id IS NOT NULL AND p_mo_rec.offer_id <> FND_API.G_MISS_NUM

Line 627: FROM dual;

623: l_object_version_number NUMBER;
624: l_dummy NUMBER;
625: CURSOR c_id IS
626: SELECT ozf_offr_market_options_s.NEXTVAL
627: FROM dual;
628: CURSOR c_id_exists (l_id IN NUMBER) IS
629: SELECT 1
630: FROM ozf_offr_market_options
631: WHERE offer_market_option_id = l_id;