APPS.FV_INSTALL_EXTN SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 4

PROCEDURE insert_ap_income_tax_types;

Line: 28

  cursor  c_territory is select iso_territory
			   from fnd_languages
			  where installed_flag  = 'B';

Line: 36

  SELECT resp_enabled_flag, user_enabled_flag
  FROM fnd_profile_options
  WHERE profile_option_name = 'FV_ENABLED';

Line: 197

  insert_ap_income_tax_types;

Line: 230

PROCEDURE insert_ap_income_tax_types IS
l_module_name varchar2(200);

Line: 236

l_module_name := g_module_name || 'insert_ap_income_tax_types';

Line: 238

INSERT INTO ap_income_tax_types
(income_tax_type,
description,
last_update_date,
last_updated_by,
last_update_login,
creation_date,
created_by)
(SELECT 'GOV 1','Unemployment compensation',sysdate,1,1,sysdate,1
FROM DUAL
WHERE NOT EXISTS
            (SELECT 'x'
                   FROM ap_income_tax_types
                   WHERE income_tax_type = 'GOV 1'
                   AND      description = 'Unemployment compensation'));

Line: 254

INSERT INTO ap_income_tax_types
(income_tax_type,
description,
last_update_date,
last_updated_by,
last_update_login,
creation_date,
created_by)
(SELECT 'GOV 6','Taxable grants',sysdate,1,1,sysdate,1
FROM DUAL
WHERE NOT EXISTS
            (SELECT 'x'
             FROM ap_income_tax_types
             WHERE income_tax_type = 'GOV 6'
             AND     description = 'Taxable grants'));

Line: 270

INSERT INTO ap_income_tax_types
(income_tax_type,
description,
last_update_date,
last_updated_by,
last_update_login,
creation_date,
created_by)
(SELECT 'GOV 6A','Energy grants',sysdate,1,1,sysdate,1
FROM DUAL
WHERE NOT EXISTS
            (SELECT 'x'
             FROM ap_income_tax_types
             WHERE income_tax_type = 'GOV 6A'
             AND     description = 'Energy grants'));

Line: 286

INSERT INTO ap_income_tax_types
(income_tax_type,
description,
last_update_date,
last_updated_by,
last_update_login,
creation_date,
created_by)
(SELECT 'GOV 7','Agriculture payments',sysdate,1,1,sysdate,1
FROM DUAL
WHERE NOT EXISTS
            (SELECT 'x'
             FROM ap_income_tax_types
             WHERE income_tax_type = 'GOV 7'
             AND     description = 'Agriculture payments'));

Line: 302

INSERT INTO ap_income_tax_types
(income_tax_type,
description,
last_update_date,
last_updated_by,
last_update_login,
creation_date,
created_by)
(SELECT 'INT 1','Interest income not included in box 3',sysdate,1,1,sysdate,1
FROM DUAL
WHERE NOT EXISTS
            (SELECT 'x'
             FROM ap_income_tax_types
             WHERE income_tax_type = 'INT 1'
              AND     description = 'Interest income not included in box 3'));

Line: 318

INSERT INTO ap_income_tax_types
(income_tax_type,
description,
last_update_date,
last_updated_by,
last_update_login,
creation_date,
created_by)
(SELECT 'INT 1A','Financial institution interest income not included in box 3',
        sysdate,1,1,sysdate,1
FROM DUAL
WHERE NOT EXISTS
 (SELECT 'x'
  FROM ap_income_tax_types
  WHERE income_tax_type = 'INT 1A'
  AND   description = 'Financial institution interest income not included in box
 3'));

Line: 336

INSERT INTO ap_income_tax_types
(income_tax_type,
description,
last_update_date,
last_updated_by,
last_update_login,
creation_date,
created_by)
(SELECT 'INT 3','Interest on U.S. Savings Bonds and Treasury obligations',
        sysdate,1,1,sysdate,1
FROM DUAL
WHERE NOT EXISTS
  (SELECT 'x'
   FROM ap_income_tax_types
   WHERE income_tax_type = 'INT 3'
   AND description = 'Interest on U.S. Savings Bonds and Treasury obligations'))
;

Line: 359

END insert_ap_income_tax_types;

Line: 377

  CURSOR  c_territory IS select iso_territory
                         from fnd_languages
                         where installed_flag in ('I', 'B');