APPS.JA_CN_FSG_XML_SUBMIT_PROG SQL Statements

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

Line: 131

   SELECT COMPANY_NAME
   INTO L_COMPANY_NAME
   FROM JA_CN_SYSTEM_PARAMETERS_ALL
   WHERE LEGAL_ENTITY_ID=L_LEGAL_ENTITY;

Line: 136

    SELECT 	row_set_id,
		column_set_id,
		unit_of_measure_id,
		content_set_id,
		row_order_id,
		rounding_option,
		parameter_set_id,
		minimum_display_level,
		report_display_set_id,
		output_option,
		name,
		segment_override
      INTO    report_rec
      FROM    RG_REPORTS
      WHERE   REPORT_ID = X_REPORT_ID;

Line: 157

         SELECT report_run_type
         INTO   rep_run_type
         FROM   rg_report_content_sets
         WHERE  content_set_id = X_content_set_id;

Line: 206

            UPDATE 	FND_CONCURRENT_REQUESTS
            SET
              OUTPUT_FILE_TYPE = 'XML'
            WHERE
              REQUEST_ID = req_id;

Line: 254

            UPDATE 	FND_CONCURRENT_REQUESTS
            SET
              OUTPUT_FILE_TYPE = 'XML'
            WHERE
              REQUEST_ID = req_id;

Line: 547

      SELECT APP.APPLICATION_ID
        INTO l_template_appl
        FROM FND_APPLICATION_VL      APP,
             FND_CONCURRENT_PROGRAMS FCP,
             FND_CONCURRENT_REQUESTS R
       WHERE FCP.CONCURRENT_PROGRAM_ID = R.CONCURRENT_PROGRAM_ID
         AND R.REQUEST_ID = l_fsg_request_id
         AND APP.APPLICATION_ID = FCP.APPLICATION_ID;