APPS.OZF_VOLUME_OFFER_QUAL_PVT dependencies on DUAL

Line 92: SELECT 'N' FROM dual WHERE EXISTS(SELECT 'X' FROM ozf_offr_market_options WHERE group_number = p_group_number and qp_list_header_id = p_qp_list_header_id);

88: ) RETURN VARCHAR2
89: IS
90: l_return VARCHAR2(1) := 'Y';
91: CURSOR c_create_mo(p_group_number NUMBER, p_qp_list_header_id NUMBER) IS
92: SELECT 'N' FROM dual WHERE EXISTS(SELECT 'X' FROM ozf_offr_market_options WHERE group_number = p_group_number and qp_list_header_id = p_qp_list_header_id);
93: BEGIN
94: OPEN c_create_mo(p_group_number,p_qp_list_header_id);
95: FETCH c_create_mo INTO l_return;
96: IF(c_create_mo%NOTFOUND) THEN

Line 342: SELECT 'Y' FROM dual WHERE EXISTS (SELECT 'X' FROM qp_qualifiers WHERE list_header_id = p_qp_list_header_id AND qualifier_grouping_no = p_group_number);

338: RETURN VARCHAR2
339: IS
340: --l_operation VARCHAR2(30);
341: CURSOR c_group_members_exist(p_qp_list_header_id NUMBER,p_group_number NUMBER) IS
342: SELECT 'Y' FROM dual WHERE EXISTS (SELECT 'X' FROM qp_qualifiers WHERE list_header_id = p_qp_list_header_id AND qualifier_grouping_no = p_group_number);
343: l_grp_mem_exist VARCHAR2(1) := 'A';
344: BEGIN
345: OPEN c_group_members_exist(p_qp_list_header_id,p_group_number);
346: FETCH c_group_members_exist INTO l_grp_mem_exist;