APPS.ICX_POR_EXT_TEST dependencies on DUAL

Line 1090: FROM dual

1086: xErrLoc:= 100;
1087: BEGIN
1088: SELECT 1
1089: INTO xExist
1090: FROM dual
1091: WHERE EXISTS (SELECT 'installed language'
1092: FROM fnd_languages
1093: WHERE installed_flag = 'I'
1094: AND language_code = p_language);

Line 1115: 'FROM dual ' ||

1111: ':description, ' ||
1112: ':language, ' ||
1113: ':language, ' ||
1114: 'SYSDATE ' ||
1115: 'FROM dual ' ||
1116: 'WHERE NOT EXISTS (SELECT 1 ' ||
1117: 'FROM imtl_categories_tl ' ||
1118: 'WHERE category_id =:category_id ' ||
1119: 'AND language =:language) '

Line 1701: FROM dual

1697: xErrLoc:= 100;
1698: BEGIN
1699: SELECT 1
1700: INTO xExist
1701: FROM dual
1702: WHERE EXISTS (SELECT 'installed language'
1703: FROM fnd_languages
1704: WHERE installed_flag = 'I'
1705: AND language_code = p_language);

Line 1728: 'FROM dual ' ||

1724: ':description, ' ||
1725: ':language, ' ||
1726: ':language, ' ||
1727: 'SYSDATE ' ||
1728: 'FROM dual ' ||
1729: 'WHERE NOT EXISTS (SELECT 1 ' ||
1730: 'FROM imtl_system_items_tl ' ||
1731: 'WHERE inventory_item_id =:inventory_item_id ' ||
1732: 'AND organization_id =:organization_id ' ||