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 2199: 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 || ')';

2195:
2196: FOR r_filter in c_filter LOOP
2197: -- build SQL for universe
2198: -- for bug5874874 gnramasa 25-Apr-2007
2199: 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 || ')';
2200: -- l_sql_stmt := l_sql_select || r_filter.entity_name || l_sql_where || r_filter.select_column || l_sql_cond;
2201:
2202: BEGIN
2203: OPEN c_universe FOR l_sql_stmt USING p_party_id;

Line 2915: FROM dual;

2911:
2912: IF NVL(fnd_profile.value('HZ_GENERATE_PARTY_NUMBER'), 'Y') = 'N' THEN
2913: SELECT hz_parties_s.nextval
2914: INTO l_party_rel_create_rec.party_rec.party_number
2915: FROM dual;
2916: ELSE
2917: l_party_rel_create_rec.party_rec.party_number := '';
2918: END IF;
2919:

Line 3209: FROM dual;

3205:
3206: IF NVL(fnd_profile.value('HZ_GENERATE_PARTY_SITE_NUMBER'), 'Y') = 'N' THEN
3207: SELECT hz_party_sites_s.nextval
3208: INTO l_Party_Site_Create_rec.Party_Site_Number
3209: FROM dual;
3210: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_party_site_number=' || l_party_site_create_rec.party_site_number);
3211: ELSE
3212: l_Party_Site_Create_rec.Party_Site_Number := NULL;
3213: END IF;