APPS.JG_RX_FAREG_MULTIREPTS SQL Statements

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

Line: 59

      SELECT R.report_id
        INTO X_asset_report_id
        FROM fnd_concurrent_programs c,
             fnd_application         a,
             fa_rx_reports           r
       WHERE c.application_id = a.application_id
         AND a.application_short_name ='JG'
	 AND c.concurrent_program_name=p_asset_concurr_name
	 AND c.application_id = r.application_id
	 AND r.concurrent_program_id = c.concurrent_program_id;

Line: 98

   INSERT INTO fa_rx_multiformat_reps (
                                       request_id,
                                       sub_request_id,
                                       sub_attribute_set,
                                       sub_report_id,
                                       seq_number,
                                       complex_flag,
                                       last_update_date,
                                       last_updated_by,
                                       creation_date,
                                       created_by
                                      )
   VALUES (
           this_request_id,
           r,
           p_asset_attribute_set,
           X_asset_report_id,
           i,
           report_complex_flag,
           sysdate,
           1,
           sysdate,
           1
          );

Line: 128

      SELECT R.report_id
        INTO X_rtmnt_report_id
        FROM fnd_concurrent_programs c,
             fnd_application         a,
             fa_rx_reports           r
       WHERE c.application_id = a.application_id
         AND a.application_short_name ='JG'
	 AND c.concurrent_program_name=p_rtmnt_concurr_name
	 AND c.application_id = r.application_id
	 AND r.concurrent_program_id = c.concurrent_program_id;

Line: 167

   INSERT INTO fa_rx_multiformat_reps (
                                       request_id,
                                       sub_request_id,
                                       sub_attribute_set,
                                       sub_report_id,
                                       seq_number,
                                       complex_flag,
                                       last_update_date,
                                       last_updated_by,
                                       creation_date,
                                       created_by
                                      )
   VALUES (
           this_request_id,
           r,
           p_rtmnt_attribute_set,
           X_rtmnt_report_id,
           i,
           report_complex_flag,
           sysdate,
           1,
           sysdate,
           1
          );