APPS.PAY_KW_XDO_TEMPLATE SQL Statements

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

Line: 18

      SELECT program_name
        INTO l_file_name
        FROM fnd_lobs
       WHERE file_id = p_file_id;

Line: 24

      DELETE FROM per_gb_xdo_templates
            WHERE file_name = l_file_name AND
                  effective_start_date = l_start_date AND
                  effective_end_date = l_end_date;

Line: 29

      INSERT INTO per_gb_xdo_templates
                  (file_id,
                   file_name,
                   file_description,
                   effective_start_date,
                   effective_end_date)
         SELECT p_file_id, l_file_name, 'Template for year 2005',
                l_start_date, l_end_date
           FROM fnd_lobs
          WHERE file_id = p_file_id;

Line: 55

      SELECT program_name
        INTO l_file_name
        FROM fnd_lobs
       WHERE file_id = p_file_id;

Line: 61

      DELETE FROM per_gb_xdo_templates
            WHERE file_name = l_file_name AND
                  effective_start_date = l_start_date AND
                  effective_end_date = l_end_date;

Line: 66

      INSERT INTO per_gb_xdo_templates
                  (file_id,
                   file_name,
                   file_description,
                   effective_start_date,
                   effective_end_date)
         SELECT p_file_id, l_file_name, 'Template for year 2006',
                l_start_date, l_end_date
           FROM fnd_lobs
          WHERE file_id = p_file_id;

Line: 94

      SELECT program_name
        INTO l_file_name
        FROM fnd_lobs
       WHERE file_id = p_file_id;

Line: 100

      DELETE FROM per_gb_xdo_templates
            WHERE file_name = l_file_name AND
                  effective_start_date = l_start_date AND
                  effective_end_date = l_end_date;

Line: 105

      INSERT INTO per_gb_xdo_templates
                  (file_id,
                   file_name,
                   file_description,
                   effective_start_date,
                   effective_end_date)
         SELECT p_file_id, l_file_name, 'Template for year 2007',
                l_start_date, l_end_date
           FROM fnd_lobs
          WHERE file_id = p_file_id;

Line: 135

      SELECT program_name
        INTO l_file_name
        FROM fnd_lobs
       WHERE file_id = p_file_id;

Line: 141

      DELETE FROM per_gb_xdo_templates
            WHERE file_name = l_file_name AND
                  effective_start_date = l_start_date AND
                  effective_end_date = l_end_date;

Line: 146

      INSERT INTO per_gb_xdo_templates
                  (file_id,
                   file_name,
                   file_description,
                   effective_start_date,
                   effective_end_date)
         SELECT p_file_id, l_file_name, 'Template for year 2010',
                l_start_date, l_end_date
           FROM fnd_lobs
          WHERE file_id = p_file_id;

Line: 176

      SELECT program_name
        INTO l_file_name
        FROM fnd_lobs
       WHERE file_id = p_file_id;

Line: 182

      DELETE FROM per_gb_xdo_templates
            WHERE file_name = l_file_name AND
                  effective_start_date = l_start_date AND
                  effective_end_date = l_end_date;

Line: 187

      INSERT INTO per_gb_xdo_templates
                  (file_id,
                   file_name,
                   file_description,
                   effective_start_date,
                   effective_end_date)
         SELECT p_file_id, l_file_name, 'Template for year 2012',
                l_start_date, l_end_date
           FROM fnd_lobs
          WHERE file_id = p_file_id;