APPS.IEX_CUST_OVERVIEW_PVT dependencies on DUAL

Line 202: l_sql_stmt := 'SELECT 1 FROM dual WHERE EXISTS (SELECT 1 FROM ' || r_filter.entity_name || l_sql_where || r_filter.select_column || l_sql_cond || ')';

198:
199: FOR r_filter in c_filter LOOP
200: -- build SQL for universe
201: -- for bug 5874874 gnramasa 25-Apr-2007
202: l_sql_stmt := 'SELECT 1 FROM dual WHERE EXISTS (SELECT 1 FROM ' || r_filter.entity_name || l_sql_where || r_filter.select_column || l_sql_cond || ')';
203: --l_sql_stmt := l_sql_select || r_filter.entity_name || l_sql_where || r_filter.select_column || l_sql_cond;
204:
205: BEGIN
206: OPEN c_universe FOR l_sql_stmt USING p_party_id;

Line 2058: l_sql_stmt := 'SELECT 1 FROM dual WHERE EXISTS (SELECT 1 FROM ' || r_filter.entity_name || l_sql_where || r_filter.select_column || l_sql_cond || ')';

2054:
2055: FOR r_filter in c_filter LOOP
2056: -- build SQL for universe
2057: -- for bug5874874 gnramasa 25-Apr-2007
2058: l_sql_stmt := 'SELECT 1 FROM dual WHERE EXISTS (SELECT 1 FROM ' || r_filter.entity_name || l_sql_where || r_filter.select_column || l_sql_cond || ')';
2059: -- l_sql_stmt := l_sql_select || r_filter.entity_name || l_sql_where || r_filter.select_column || l_sql_cond;
2060:
2061: BEGIN
2062: OPEN c_universe FOR l_sql_stmt USING p_party_id;

Line 2685: FROM dual;

2681:
2682: IF NVL(fnd_profile.value('HZ_GENERATE_PARTY_NUMBER'), 'Y') = 'N' THEN
2683: SELECT hz_parties_s.nextval
2684: INTO l_party_rel_create_rec.party_rec.party_number
2685: FROM dual;
2686: ELSE
2687: l_party_rel_create_rec.party_rec.party_number := '';
2688: END IF;
2689:

Line 2890: FROM dual;

2886:
2887: IF NVL(fnd_profile.value('HZ_GENERATE_PARTY_SITE_NUMBER'), 'Y') = 'N' THEN
2888: SELECT hz_party_sites_s.nextval
2889: INTO l_Party_Site_Create_rec.Party_Site_Number
2890: FROM dual;
2891: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_party_site_number=' || l_party_site_create_rec.party_site_number);
2892: ELSE
2893: l_Party_Site_Create_rec.Party_Site_Number := NULL;
2894: END IF;

Line 2957: FROM dual;

2953:
2954: IF NVL(fnd_profile.value('HZ_GENERATE_PARTY_SITE_NUMBER'), 'Y') = 'N' THEN
2955: SELECT hz_party_sites_s.nextval
2956: INTO l_Party_Site_Create_rec.Party_Site_Number
2957: FROM dual;
2958: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_party_site_number=' || l_party_site_create_rec.party_site_number);
2959: ELSE
2960: l_Party_Site_Create_rec.Party_Site_Number := NULL;
2961: END IF;