DBA Data[Home] [Help]

APPS.FV_INSTALL_EXTN dependencies on DUAL

Line 224: FROM DUAL

220: last_update_login,
221: creation_date,
222: created_by)
223: (SELECT 'GOV 1','Unemployment compensation',sysdate,1,1,sysdate,1
224: FROM DUAL
225: WHERE NOT EXISTS
226: (SELECT 'x'
227: FROM ap_income_tax_types
228: WHERE income_tax_type = 'GOV 1'

Line 240: FROM DUAL

236: last_update_login,
237: creation_date,
238: created_by)
239: (SELECT 'GOV 6','Taxable grants',sysdate,1,1,sysdate,1
240: FROM DUAL
241: WHERE NOT EXISTS
242: (SELECT 'x'
243: FROM ap_income_tax_types
244: WHERE income_tax_type = 'GOV 6'

Line 256: FROM DUAL

252: last_update_login,
253: creation_date,
254: created_by)
255: (SELECT 'GOV 6A','Energy grants',sysdate,1,1,sysdate,1
256: FROM DUAL
257: WHERE NOT EXISTS
258: (SELECT 'x'
259: FROM ap_income_tax_types
260: WHERE income_tax_type = 'GOV 6A'

Line 272: FROM DUAL

268: last_update_login,
269: creation_date,
270: created_by)
271: (SELECT 'GOV 7','Agriculture payments',sysdate,1,1,sysdate,1
272: FROM DUAL
273: WHERE NOT EXISTS
274: (SELECT 'x'
275: FROM ap_income_tax_types
276: WHERE income_tax_type = 'GOV 7'

Line 288: FROM DUAL

284: last_update_login,
285: creation_date,
286: created_by)
287: (SELECT 'INT 1','Interest income not included in box 3',sysdate,1,1,sysdate,1
288: FROM DUAL
289: WHERE NOT EXISTS
290: (SELECT 'x'
291: FROM ap_income_tax_types
292: WHERE income_tax_type = 'INT 1'

Line 305: FROM DUAL

301: creation_date,
302: created_by)
303: (SELECT 'INT 1A','Financial institution interest income not included in box 3',
304: sysdate,1,1,sysdate,1
305: FROM DUAL
306: WHERE NOT EXISTS
307: (SELECT 'x'
308: FROM ap_income_tax_types
309: WHERE income_tax_type = 'INT 1A'

Line 323: FROM DUAL

319: creation_date,
320: created_by)
321: (SELECT 'INT 3','Interest on U.S. Savings Bonds and Treasury obligations',
322: sysdate,1,1,sysdate,1
323: FROM DUAL
324: WHERE NOT EXISTS
325: (SELECT 'x'
326: FROM ap_income_tax_types
327: WHERE income_tax_type = 'INT 3'