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 626: FROM dual;

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