DBA Data[Home] [Help]

APPS.FV_INSTALL_EXTN dependencies on DUAL

Line 247: FROM DUAL

243: last_update_login,
244: creation_date,
245: created_by)
246: (SELECT 'GOV 1','Unemployment compensation',sysdate,1,1,sysdate,1
247: FROM DUAL
248: WHERE NOT EXISTS
249: (SELECT 'x'
250: FROM ap_income_tax_types
251: WHERE income_tax_type = 'GOV 1'

Line 263: FROM DUAL

259: last_update_login,
260: creation_date,
261: created_by)
262: (SELECT 'GOV 6','Taxable grants',sysdate,1,1,sysdate,1
263: FROM DUAL
264: WHERE NOT EXISTS
265: (SELECT 'x'
266: FROM ap_income_tax_types
267: WHERE income_tax_type = 'GOV 6'

Line 279: FROM DUAL

275: last_update_login,
276: creation_date,
277: created_by)
278: (SELECT 'GOV 6A','Energy grants',sysdate,1,1,sysdate,1
279: FROM DUAL
280: WHERE NOT EXISTS
281: (SELECT 'x'
282: FROM ap_income_tax_types
283: WHERE income_tax_type = 'GOV 6A'

Line 295: FROM DUAL

291: last_update_login,
292: creation_date,
293: created_by)
294: (SELECT 'GOV 7','Agriculture payments',sysdate,1,1,sysdate,1
295: FROM DUAL
296: WHERE NOT EXISTS
297: (SELECT 'x'
298: FROM ap_income_tax_types
299: WHERE income_tax_type = 'GOV 7'

Line 311: FROM DUAL

307: last_update_login,
308: creation_date,
309: created_by)
310: (SELECT 'INT 1','Interest income not included in box 3',sysdate,1,1,sysdate,1
311: FROM DUAL
312: WHERE NOT EXISTS
313: (SELECT 'x'
314: FROM ap_income_tax_types
315: WHERE income_tax_type = 'INT 1'

Line 328: FROM DUAL

324: creation_date,
325: created_by)
326: (SELECT 'INT 1A','Financial institution interest income not included in box 3',
327: sysdate,1,1,sysdate,1
328: FROM DUAL
329: WHERE NOT EXISTS
330: (SELECT 'x'
331: FROM ap_income_tax_types
332: WHERE income_tax_type = 'INT 1A'

Line 346: FROM DUAL

342: creation_date,
343: created_by)
344: (SELECT 'INT 3','Interest on U.S. Savings Bonds and Treasury obligations',
345: sysdate,1,1,sysdate,1
346: FROM DUAL
347: WHERE NOT EXISTS
348: (SELECT 'x'
349: FROM ap_income_tax_types
350: WHERE income_tax_type = 'INT 3'