APPS.FND_SIF_UTILS SQL Statements

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

Line: 34

          SELECT irep_name
          INTO   l_sif_defn_name
          FROM   fnd_soa_request
          WHERE  message_id = l_sif_inst_id;

Line: 49

        SELECT display_name, description, attr1, service, operation
        INTO   l_sif_defn_dname, l_sif_description, l_sif_wsdl, l_sif_service, l_sif_operation
        FROM   fnd_sif_definitions_vl d
        WHERE  d.definition_name = l_sif_defn_name;

Line: 63

        SELECT error_date, error_code, error_code, error_detail
        INTO   l_error_date, l_erorr_code, l_error_msg, l_error_stack
        FROM   fnd_soa_runtime_error
        WHERE  message_id = l_sif_inst_id;